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

MDX to calculate measure between two dates Expand / Collapse
Author
Message
Posted Thursday, January 24, 2013 6:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 5:53 AM
Points: 4, Visits: 11

Hi ,

I have a dimension which has the following data

Name StartDate
EndDate Duration
PreSalesStartDate PostSalesEndDate

Sales1 01-Jan-2010
31-Jan-2010 31
01-Dec-2009 02-Mar-2010

Duration refers to the dfference between start date and end date .

PreSalesStart date is nothing but subtracting 31 days ( the duration ) from the start date and PostSalesEndDate refers to the addition of duration period to the End Date .

I have a cube which returns me the sales which happened between the start date and the end date . ( I have a separate time dimension which is related to the fact table )

Now when i try to find the sales which happened between the presalesstartdate and startdate . i am not getting null in the display .

I have tried using the mdx as follows

(presalesstartdate:startdate,measures.sales)

Please let me know what i am missing, i am sure it should be something with the logic that i am applying and not on the syntax because i am not getting any #value error while displaying the data

Regards,

Savio
Post #1411116
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse