Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

One attribute having different ordering in two hierarchies Expand / Collapse
Author
Message
Posted Friday, April 18, 2008 1:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 01, 2011 12:38 AM
Points: 1, Visits: 11

Hello 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.

Regards

Mus
Post #486934
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse