locked
The simplest way to integrate PrevMember into cube? RRS feed

  • Question

  • Hi guys.

    Little help plz.

    I would like to browse count of rows (a measure) for year 2008 and also see the count of rows for 2007- previous period. What would be the simplest way to achieve that? PrevMember MDX?

    Thanks a lot,
    Kaarel.

    Tuesday, November 10, 2009 2:55 PM

Answers

  • For me ParellelPeriod() did the trick.

    In my cube:

    (ParallelPeriod( [Date].[Current-vs-PrevP].[Year]  , 1 , [Date].[Current-vs-PrevP].CurrentMember), [Measures].[Registered vehicles])
    • Marked as answer by kaarelcool Monday, November 16, 2009 12:42 PM
    Monday, November 16, 2009 12:42 PM

All replies

  • PrevMember based calculaiton will work but if you simply want to browse, you could as well put time dimension on columns and count of rows measure in data field... right?
    ..hegde
    • Proposed as answer by Raymond-Lee Thursday, November 12, 2009 3:43 AM
    Tuesday, November 10, 2009 6:43 PM
  • For me ParellelPeriod() did the trick.

    In my cube:

    (ParallelPeriod( [Date].[Current-vs-PrevP].[Year]  , 1 , [Date].[Current-vs-PrevP].CurrentMember), [Measures].[Registered vehicles])
    • Marked as answer by kaarelcool Monday, November 16, 2009 12:42 PM
    Monday, November 16, 2009 12:42 PM