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

Simulate multiple default members on Calendar dimension Expand / Collapse
Author
Message
Posted Tuesday, May 7, 2013 3:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 4:24 PM
Points: 5, Visits: 234
Hi All -

I'm implementing a Calendar dimension that allows us to incorporate multiple types of calendar (Gregorian, Fiscal, CustomerX...) per Dave Fackler's great article . [url=http://davefackler.blogspot.com/2008/05/handling-multiple-calendars-with-m2m.html][/url].

The gist of it is that at the top of the hierarchy (which specific calendar system you're using), the IsAggregatable property should be set to false to prevent improper aggregations across all calendars, which means that you need to set a specific default member as [All] has been removed. So , I can choose &[Gregorian] in my case. The problem is that I also need to have a default of "yesterday". I can easily set either/or [Gregorian] for calendar type or "yesterday" for the bottom of the hierarchy in MDX, bit not both. I've read all about how dimensions can have only one default member, but I really need to set both. Can anyone direct me?

Much thanks!
Post #1450348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse