June 4, 2004 at 9:08 am
I need help from any mdx experts out there.
I have a basic olap cube that contains:
Dimensions: Time (Year,Month), Account (Top Level, low leverl)
Measures: Actual, Budget
Calculated member: Variance (Actual-Budget)
I need to create a new calculated member that will give the ytd figure for the month being queried. I.e. My financial year is Apr to Mar. In April I spend £50 so the TD shows £50. In May I spend £70. If I look at measure in the context of the yesr, it will still show the correct ytd.
However, if I get to December and look back at May I have no way of getting the ytd figure other than adding April and May together.
I would also like to do this with the variance so I can see the difference at a point of time.
I say I, but I really mean the CEO here. Any help would be appreciated. I think that I can do this in mdx but I am having real problems writing anything in the calculated member screen. There's no help out there that I can find.
June 7, 2004 at 6:03 am
Try this:
SUM(YTD([TIME]),[Variance])
June 7, 2004 at 7:13 am
Thanks. It works a treat.
I managed to get me hands on a book at about the same time I read this and it was in there also.
Thanks again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply