none
UNION TWO RESULTS QUERY RRS feed

  • Question

  • HEY :)

    I want to merge this two results of two differents queries MDX. Anyone can help me?

    1st query:

    --i make sum of client by DATE-month only (i have created a hierarchy for date (year-month))

    SELECT NON EMPTY { [Measures].[Nbr Client] } ON COLUMNS,
     NON EMPTY { ([Temps].[Date Format].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION,
    MEMBER_UNIQUE_NAME ON ROWS FROM [BDD2] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

    2 query:

    --i make sum of client by date (year-month) and product

    SELECT NON EMPTY { [Measures].[Nbr Client] } ON COLUMNS,
     NON EMPTY { ([Temps].[Date Format].[Date Format].ALLMEMBERS * [Temps].[Dat].[Dat].ALLMEMBERS * [Produits].[Id Produit].[Id Produit].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [BDD2] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

    thank :)

    Vaness ;)



    • Edited by Vaness75 Friday, February 10, 2017 10:26 AM
    Friday, February 10, 2017 10:25 AM

All replies

  • Hi Vaness, 

    Thanks for your question.

    Please try following sample MDX query:

    SELECT { [Measures].[Nbr Client] } ON COLUMNS,
    NON EMPTY { ([Temps].[Date Format].ALLMEMBERS *
    [Temps].[Dat].[Dat].ALLMEMBERS *
    [Produits].[Id Produit].[Id Produit].ALLMEMBERS ) } ON ROWS
    FROM [BDD2]


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, February 13, 2017 2:54 AM
    Moderator