Union of two MDX queries with FILTER clause

28 Views Asked by At

I am a MDX beginner and want to union the below 2 MDX queries. I need help with the syntax because I tried using the union(Query 1 ,Query 2) , according to this, but that did not work. Gave me a syntax error. Can someone please help?

Query 1:

WITH  
SET [SET_0] AS FILTER({[4MPGN3SA8-CALYEAR].[LEVEL01].MEMBERS}, [4MPGN3SA8-CALYEAR].[24MPGN3SA8-CALYEAR] = "2023")  
SET [SET_1] AS FILTER({[4MPGN3SA8-MKATEG].[LEVEL01].MEMBERS}, [4MPGN3SA8-MKATEG].[24MPGN3SA8-MKATEG] = "B")  
SET [SET_2] AS FILTER({[4MPGN3SA8-MSALESORG].[LEVEL01].MEMBERS}, [4MPGN3SA8-MSALESORG].[24MPGN3SA8-MSALESORG] = "48")  
SET [SET_3] AS FILTER({[4MPGN3SA8-MUSERID].[LEVEL01].MEMBERS},  NOT 
            (([4MPGN3SA8-MUSERID].[24MPGN3SA8-MUSERID] = "GERSD" OR 
            [4MPGN3SA8-MUSERID].[24MPGN3SA8-MUSERID] = "SEFBJ" OR 
            [4MPGN3SA8-MUSERID].[24MPGN3SA8-MUSERID] = "EWSDR" OR 
            [4MPGN3SA8-MUSERID].[24MPGN3SA8-MUSERID] = "UERDW")) ) 
SELECT 
 [SET_0] * 
 [SET_1] * 
 [4MPGN3SA8-MDATAID].[LEVEL01].MEMBERS * 
[4MPGN3SA8-SBMATH09].[LEVEL01].MEMBERS * 
[4MPGN3SA8-SBCUSTHE].[LEVEL01].MEMBERS * 
[SET_2] * 
[4MPGN3SA8-MYTIMEID].[LEVEL01].MEMBERS * 
[SET_3] DIMENSION PROPERTIES 
[4MPGN3SA8-CALYEAR].[24MPGN3SA8-CALYEAR], 
[4MPGN3SA8-MDATAID].[24MPGN3SA8-MDATAID], 
[4MPGN3SA8-MYTIMEID].[24MPGN3SA8-MYTIMEID], 
[4MPGN3SA8-MUSERID].[24MPGN3SA8-MUSERID] ON ROWS, 
{[Measures].[2ITVVC55PTEG9SLL3FXJQL20C]} ON COLUMNS FROM 
[MPGN3SA8/GMMPA_MPGN3SA8_Q0001]

Query 2:

WITH  
SET [SET_0] AS FILTER({[4MPGN3SA8-CALYEAR].[LEVEL01].MEMBERS}, [4MPGN3SA8-CALYEAR].[24MPGN3SA8-CALYEAR] = "2023")  
SET [SET_1] AS FILTER({[4MPGN3SA8-MKATEG].[LEVEL01].MEMBERS}, [4MPGN3SA8-MKATEG].[24MPGN3SA8-MKATEG] = "B")  
SET [SET_2] AS FILTER({[4MPGN3SA8-MSALESORG].[LEVEL01].MEMBERS}, [4MPGN3SA8-MSALESORG].[24MPGN3SA8-MSALESORG] = "56")  
SET [SET_3] AS FILTER({[4MPGN3SA8-MUSERID].[LEVEL01].MEMBERS},  NOT 
            (([4MPGN3SA8-MUSERID].[24MPGN3SA8-MUSERID] = "GERSD" OR 
            [4MPGN3SA8-MUSERID].[24MPGN3SA8-MUSERID] = "SEFBJ" OR 
            [4MPGN3SA8-MUSERID].[24MPGN3SA8-MUSERID] = "EWSDR" OR 
            [4MPGN3SA8-MUSERID].[24MPGN3SA8-MUSERID] = "UERDW")) ) 
SELECT 
 [SET_0] * 
 [SET_1] * 
 [4MPGN3SA8-MDATAID].[LEVEL01].MEMBERS * 
[4MPGN3SA8-SBMATH09].[LEVEL01].MEMBERS * 
[4MPGN3SA8-SBCUSTHE].[LEVEL01].MEMBERS * 
[SET_2] * 
[4MPGN3SA8-MYTIMEID].[LEVEL01].MEMBERS * 
[SET_3] DIMENSION PROPERTIES 
[4MPGN3SA8-CALYEAR].[24MPGN3SA8-CALYEAR], 
[4MPGN3SA8-MDATAID].[24MPGN3SA8-MDATAID], 
[4MPGN3SA8-MYTIMEID].[24MPGN3SA8-MYTIMEID], 
[4MPGN3SA8-MUSERID].[24MPGN3SA8-MUSERID] ON ROWS, 
{[Measures].[2ITVVC55PTEG9SLL3FXJQL20C]} ON COLUMNS FROM 
[MPGN3SA8/GMMPA_MPGN3SA8_Q0001]
0

There are 0 best solutions below