Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 One attribute having different ordering in two hie

Author  Topic 

jasraja
Starting Member

22 Posts

Posted - 2008-04-18 : 03:16:27

Hello All,

I have a Day attribute in my Time Dimensions. This attribute is used in two different hierarchies ( Calendar Year Hierarchy and Fiscal Year Hierarchy). I want Day attribute to have ascending order in Calendar Year Hierarchy and descending order in Fiscal Year Hierarchy.

Since the OrderBy property is at the attribute level is there any way I can achieve this by not having a redundant Day attribute?

Please advice.

Regards

Jasraja
   

- Advertisement -