Hi,
This one seems like a weird problem to me.
Lets say I have a dimension which has only 5 values: High,Low,Medium,VeryHigh,VeryLow.
When i browse this dimension, I want it to be custom sorted so that I always get them in the below order: VeryLow, Low,Medium,High,VeryHigh
Is there any way to accomplish this? I can arrange them in this order in the VS 2005 browser ide, but can i persist my custom arrangement?
Thanks
If you're using AS 2005, you could create an attribute to order the 5 members by. If the dimension source table is in SQL Server, you could add a named calculation for the attribute, like:
case dimvalue
when 'VeryLow' then 1
when 'Low' then 2
when 'Medium' then 3
when 'High' then 4
when 'VeryHigh' then 5 end as dimorder
http://msdn2.microsoft.com/en-us/library/ms166763.aspx
>>
SQL Server 2005 Books Online
Sorting Attribute Members Based on a Secondary Attribute
However, sometimes you may have to order attribute members based on a secondary attribute to achieve the desired sort order, for example if neither the name of the attribute nor the key of the attribute provide the sort order that you want. In order to sort an attribute by a secondary attribute name or key, you must use a secondary attribute that is related to the attribute.
>>
No comments:
Post a Comment