January 24, 2013 at 6:56 am
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
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy