locked
MDX Parallelperiod in Dashboard Designer RRS feed

  • Question

  • Hi,
    I just started to write MDX in Dashboard Designer and I'm not fully understanding the MDX in DD. I would like to add Parallelperiod to my query, how would the code: 
    Parallelperiod([Time].[Monthly].[Year],1,[Time].[Monthly].currentmember) been added to my query?

    Code Snippet

    SUM(
    {
    [Account].[MemberId].&[5007]:[Account].[MemberId].&[5156]}

    , SUM([Scenario].[All Members].[Scenario].&[2],[Measures].[value])

    )


    Cheers,
    Gosi

    Tuesday, October 14, 2008 11:58 AM

Answers

  • Hi Gosi

     

    Perhaps something like this:

     

    Code Snippet

    WITH

    MEMBER [This Year] AS

    SUM(

    {[Account].[MemberId].&[5007]:[Account].[MemberId].&[5156]},

    [Scenario].[All Members].[Scenario].&[2],

    [Measures].[value]

    )

     

    MEMBER [Last Year] AS

    SUM(

    Parallelperiod([Time].[Monthly].[Year],1,[Time].[Monthly].currentmember),

    {[Account].[MemberId].&[5007]:[Account].[MemberId].&[5156]},

    [Scenario].[All Members].[Scenario].&[2],

    [Measures].[value]

    )

     

    SELECT

    NON EMPTY

    [Time].[Monthly].[Year].members

    ON ROWS,

    {

    [This Year],

    [Last Year]

    }

    ON COLUMNS

    FROM

    [Your Cube]

     

     

     

    Wednesday, October 15, 2008 7:56 PM