Period to Period growth in Report

Hey,

now I got a new problem. :(

In SSAS I created a MDX query for the "period to period growth". In the SSAS browser it works fine but when I use this measure in my report it doesn´t work because I defined a time drilldown function (year - quarter - month). For the month hierarchy it´s ok, but in the quarter and year groups it summarizes the percantages. For example it calculates the growth of month 1 + month 2 + month 3 + month 4 and shows me the result of it for the quarter. That doesn´t make sense.

I hope you can understand my problem and sorry for my English. :)

When you drag the measure into the report, does it say sum(Fields!measureName)?  If it does, try removing the sum from the expression and see if that helps.

Yes, it does. When I removed sum in every cell stands exactly the same value. When I tried aggregate instead of sum period to period growth worked, but then the other measures changed.

Can you post an example of your period over period growth calculation?  I'm guessing that the drilldown is what is making things not work properly but I'd like to see the query to confirm.

Can you post your calculation for the period over period Growth

Here is my MDX statement:

When [ZEIT MONAT].[Jahreskalender].CurrentMember.Level Is
     [ZEIT MONAT].[Jahreskalender].[(All)]
Then "NA"

When IsEmpty
     (
       (
         ParallelPeriod
         (
            [[ZEIT MONAT].[Jahreskalender].[JAHR],
            1,
            [ZEIT MONAT].[Jahreskalender].CurrentMember
         ),
         [Measures].[UMSATZ]
        )
     )
Then Null

Else (
       ( [ZEIT MONAT].[Jahreskalender].CurrentMember,
         [Measures].[UMSATZ] )
       -
       (
         ParallelPeriod
         (
            [ZEIT MONAT].[Jahreskalender].[JAHR],
            1,
            [ZEIT MONAT].[Jahreskalender].CurrentMember
         ),
         [Measures].[UMSATZ]
       )
     )

     /

     (
       ParallelPeriod
       (
          [ZEIT MONAT].[Jahreskalender].[JAHR],
          1,
          [ZEIT MONAT].[Jahreskalender].CurrentMember
       ),
       [Measures].[UMSATZ]
     )
End