Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Order of dimensions on mutlidrill menu
Go
New
Search
Notify
Tools
Reply
  
Order of dimensions on mutlidrill menu
 Login/Join
 
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, 2009Reply With QuoteReport This Post
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, 2003Reply With QuoteReport This Post
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, 2009Reply With QuoteReport This Post
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, 2003Reply With QuoteReport This Post
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: 70 | Location: United States | Registered: March 28, 2007Reply With QuoteReport This Post
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, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

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

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.