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