Simon, if you are doing financial app, I recommend creating real dimension
members with Custom Rollup Formula instead of calculated members.
This way you can control ordering by carefully chosing member keys and
asking Analysis Services to sort dimension by key.
Mosha Pasumansky (moshap at microsoft dot com)
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
Quote:> Crystal Analysis does allow users to add create calc members and
> change the order of dimension memebers but when user drills up or
> down, the ordering is lost and the default cube dimension order
> prevails. Can the cube be changed to overcome this problem?
> We have an issue with a dimension and calculated members that need to
> be ordered in a certain way: We have a finance cube and an object
> dimension and calculated
> members that needs to show in the following order:
> External Revenue
> Internal Revenue
> TOTAL REVENUE
> TOTAL EXPENDITURE
> TOTAL PROFIT AND LOSS
> **Upper case show calculated members and rest are Object dimension
> members in the correct order.
> We have no issue sorting the object dimension members - we need to
> sort the calculated members with the object dimension members as above
> - any assistance appreciated.