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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
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.
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.
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!
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.