Hi

I want to create a % growth formula in MDX but do not know
how. Can someone advise me. I need % growth in terms of
year on year and % growth for month-on-month.

Thank you.

If you need to apply %growth analysis across multiple measures, then you
can add a Time Series Dimension:

There is a Microsoft support article that explains this, using the
Foodmart 2000 Sales cube:

http://support.microsoft.com/default...;EN-US;q304118
...
Growth for a specific measure can be a calculated measure:
as 'iif(IsEmpty(([Measures].[Unit Sales],[Time].PrevMember)), NULL,
([Measures].[Unit Sales]-([Measures].[Unit
Sales],[Time].PrevMember))/([Measures].[Unit
Sales],[Time].PrevMember))',
FORMAT_STRING = 'Percent'
Select
{[Measures].[Unit Sales],[Measures].[Unit Sales Growth]} on columns,
Descendants([Time].[1997],[Time].[Month],SELF_AND_BEFORE) on rows
from Sales
- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi freger,

here you have an example of the mdx query with the warehouse cube of the
foodmart 2000.

( ([Time].CurrentMember, [Measures].[Warehouse Sales]) -
([Time].CurrentMember.Lag(1), [Measures].[Warehouse Sales]) ) /
([Time].CurrentMember.Lag(1), [Measures].[Warehouse Sales])

Un saludo,

Enrique Barceló

"freger" <freger79 (AT) hotmail (DOT) com> escribió en el mensaje
news:0d9d01c3406a$a0d0dee0$a101280a (AT) phx (DOT) gbl...