InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 22:55:06 GMT20http://www.sqlservercentral.com/Forums/Topic486934-147-1.aspxHello All,I have a Day attribute in my Time Dimesnions. 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.RegardsMusFri, 18 Apr 2008 01:06:54 GMTjasraja