Tuesday, March 20, 2012

custom sorting dimension values

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