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

Value of opening period of non-calendar dimension (Many-to-many relationship) Expand / Collapse
Author
Message
Posted Friday, February 13, 2009 12:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 1, 2013 7:34 PM
Points: 4, Visits: 147
Hi All,

I have a cube with an [Events] dimension, which has many-to-many relationship with the [Calendar] dimension. For example, Valentines (event) corresponds to weeks 1 through 13; Spring Sales (event) corresponds to weeks 4 through 25, etc.

I need to create a calculated member for the sales on the first week of each event and use the static value in other formulas. So, for example, I need a value for week 1 for Valentines; week 4 value for Spring Sales. In addition, the [Element] dimension should be equal to [Element].[Element].[1].

Furthermore, I need to create a calculated member with cumulative sales for each event for each week.

I've tried various combinations, but unsuccessful so far. Any ideas would definitely help!

--
Thanks,

Pasha
Post #656939
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse