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.

thanks

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.

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

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?

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