One thing I didn't like in AS 2000 and looks it's same in AS 2005.

There is no way to sort measures or I don't know yet. One of my cube has
100s of measures and its very hard to find one I am looking for.

I see there is option to sort "measure groups" but that doesn't help much.

Is there any way to set sort order in measures in "Cube Structure" tab.

Thank you - Ashok

I issued the same thing during beta program, but there is no option yet as I
know.

At that time, I tried next kind of query, but could not control the order
fully.

WITH
MEMBER [Product].[Category].MeasureKey AS
Measures.CurrentMember.Properties("Key")
MEMBER [Product].[Category].MeasureID AS
Measures.CurrentMember.Properties("ID")
SELECT
Order({Measures.AllMembers}, Measures.CurrentMember.Properties("ID"),ASC) ON
0,
{MeasureKey, MeasureID} ON 1
FROM [Sales Summary]

It looks like that Calculated Members have ID values greater than regular
measures, they, however, behaves like that they have smaller values instead.

Ohjoo

"Ashok" <Ashok (AT) discussions (DOT) microsoft.com> wrote