Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [Solved] Dimension Tree filtering behaviour

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Solved] Dimension Tree filtering behaviour
 Login/Join
 
Guru
posted
Hi,

My client has a six level dimension called Organization. If they enter a measure at the lowest level of the dimension, the actual values are stored just fine. The problem occurs when they are trying to use the dimension tree filters to only show measures at the lowest level. They get a screen indicating no records were found. If they choose the level just ABOVE where they entered the measure, it shows them the lowest level values instead of the level they clicked on. Because of this behaviour, they are prevented from accurate filtering with the dimension tree.

Is this working as designed, and if so, why? If not, please advise.

Cheers,

Joey

This message has been edited. Last edited by: Moogle,


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
Master
posted Hide Post
Sounds as if it's working as designed in this case... the tree reports break out the next level at the level you click. So if you put the data in quarterly and then click on a quarter in that report, you might expect to see just that quarter, but actually what you will see is the months within that quarter.

Same with the other dimensions when you click them... it breaks out all items of the next lowest level that appear within a level. So if you have for example a location dimension that goes country>region>state>city and click Region, it will list States in that region.

Hope this makes sense.


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Guru
posted Hide Post
Yes, this does makes sense. If the client wants different behaviour, I will build them an HTML launch page instead.

Cheers,

Joey
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [Solved] Dimension Tree filtering behaviour

Copyright © 1996-2020 Information Builders