none
Join result of two MDX queries RRS feed

  • Question

  • Hi,

     I would like to join two MDX queries, how can I do that?

    query 1:

    SELECT [Measures].[Internet Sales Amount] ON 0,
    FILTER([Date].[Date].[Date].MEMBERS , [Measures].[Internet Sales Amount]>10000) ON 1
    FROM [MyCube]


    query 2:
    SELECT NON EMPTY {[Measures].[Internet Sales Amount]} ON COLUMNS,
    NON EMPTY { ([GRD0TEMP].[Time].[Int Month].&[2012]&[7]:[GRD0TEMP].[Tempo].[Int Month].&[2013]&[8]) } ON ROWS
    FROM ( SELECT ( { [PJD0ENTI].[Division].[Fcod Division].&[1]&[148], [PJD0ENTI].[Divisão].[Fcod Division].&[2]&[148] } ) ON COLUMNS
    FROM ( SELECT ( { [GRD0TEMP].[Time].[All] } ) ON COLUMNS
    FROM ( SELECT ( { [PJD0ENTI].[entidy].[Fcod entidy].&[1] } ) ON COLUMNS
    FROM [MyCube])))

    Tuesday, August 19, 2014 11:18 AM

Answers

All replies