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)    Order of dimensions on mutlidrill menu

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Order of dimensions on mutlidrill menu
 Login/Join
 
Rob North
Member
posted
How is the sort order of the dimensions on the multidrill menu controlled? It appears to be based on the DIMENSION_NUMBER in the dimensions_type table. Is this true? Is so, how is the value of DIMENSION_NUMBER set? It appears to be the order in which the dimensions were created, which, if true, leads to a pretty random drillmenu sort order from the user's prespective.


WF 76x, 77x, PMF 52x, 53x
 
Posts: 18 | Registered: October 22, 2009Report This Post
Bob Jude Ferrante
Master
posted Hide Post
Note that each measure can have its own special dimension linkage and order. For any single measure name listed on a view, the first linked dimension is the default and once that is exhausted (drilled to the lowest level) the next one pertains.

For multiple measures, you are absolutely right, they're listed in the order they were created. In other words in serial order. No other logical order has even been significant to customers to date; e.g., nobody's ever had a problem with the order, but if this is a real high-priority issue for someone a feature could be created.

Does the order matter at your site? What's the business case for why? We're interested.

thanks


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
Rob North
Member
posted Hide Post
I was just thinking that alphabetical order would be better than dimension number order. It takes a little longer to find the one you want, especially if you have more than a few. I guess one could create them in alphabetical order as long as no new ones are added.


WF 76x, 77x, PMF 52x, 53x
 
Posts: 18 | Registered: October 22, 2009Report This Post
Bob Jude Ferrante
Master
posted Hide Post
OK, thanks Rob. So the feedback so far is:

For a single measure views, the order should be that specified in the measure's dimension linkage.
For multi-measure views, use alpha order, not dimension numeric order.

However, please note: We find that Time is the most frequently drilled Dimension, though. Putting it in alpha order moves it down. Would you like Time to stay on top?

thanks


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
Janice
Gold member
posted Hide Post
Our client has asked that the multi select box have up and down arrows so they can control the order that the measures are displayed. Has there been any enhancements to this in the latest release?


WF 8.09
 
Posts: 68 | Location: United States | Registered: March 28, 2007Report This Post
Bob Jude Ferrante
Master
posted Hide Post
No, that was not changed in 5.2.1, the latest, current release. 5.2.1 was in final Beta when the feature was requested, so the request came in too late.

If you formally want a new feature, please contact customer support and open a NF case. Commitments are not made in the forum (except in that we are committed to answering each others' questions).

thanks
bjf


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
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Order of dimensions on mutlidrill menu

Copyright © 1996-2020 Information Builders