Wednesday, March 21, 2012

How to add time dependent calculed mesure

Is there a way to add time dependent calculed mesure for ex (Delta% of a standard mesure which represent its evolution within the time dimension)

Regards

I guess you're looking for something like this (from Foodmart 2000):

with member [Measures].[Delta] as '[Measures].[Unit Sales]-([Measures].[Unit Sales],[Time].currentmember.lag(1))'

select {[Measures].[Unit Sales],[Measures].[Delta]} on 0,
{[Time].members} on 1
from sales

No comments:

Post a Comment