UNION ALL of 2 MDX queries (within data cube)

Question

I'm mdx rookie.. A box of gold for whoever can tell how to do UNION ALL of these two MDX queries:

SELECT
{
[Measures].[P Count]
}
ON COLUMNS,
{
(
[Dim P View].[Person Key].[Person Key].ALLMEMBERS *
[Dim P View].[Is Sensitive Data A].[Is Sensitive Data A].ALLMEMBERS *
[Dim P View].[Is Sensitive Data B].[Is Sensitive Data B].ALLMEMBERS *
[Dim P View].[Is Person Imp X].[Is Person Imp X].ALLMEMBERS 
)
}
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS FROM ( SELECT ( { [Dim P View].[Is Person Imp X].&[True] } )
ON COLUMNS FROM [BI_CUBE])


***UNION ALL***


SELECT
{
[Measures].[P Count]
}
ON COLUMNS,
{
(
[Dim P View].[Person Key].[Person Key].ALLMEMBERS *
[Dim P View].[Is Sensitive Data A].[Is Sensitive Data A].ALLMEMBERS *
[Dim P View].[Is Sensitive Data B].[Is Sensitive Data B].ALLMEMBERS *
[Dim P View].[Is Person Imp Y].[Is Person Imp Y].ALLMEMBERS 
)
}
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS FROM ( SELECT ( { [Dim P View].[Is Person Imp Y].&[True] } )
ON COLUMNS FROM [BI_CUBE])

I tried to append queries via Power Pivot / Power BI - which succeeded but this is main requirement to have it in one query.

score 0 · Accepted Answer · answered Dec 10 '22 at 01:19

Try this:


SELECT
{
[Measures].[P Count]
}
ON COLUMNS,
{
(
[Dim P View].[Person Key].[Person Key].ALLMEMBERS *
[Dim P View].[Is Sensitive Data A].[Is Sensitive Data A].ALLMEMBERS *
[Dim P View].[Is Sensitive Data B].[Is Sensitive Data B].ALLMEMBERS *
{
 ([Dim P View].[Is Person Imp X].&[True], [Dim P View].[Is Person Imp Y].[All]),
   ([Dim P View].[Is Person Imp X].[All], [Dim P View].[Is Person Imp Y].&[True])
}
)
}
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS FROM [BI_CUBE]

THANK YOU Greg, that is exactly what I tried to achive. – bishch Dec 12 '22 at 12:30 — bishch, Dec 12 '22 at 12:30

UNION ALL of 2 MDX queries (within data cube)

1 Answers1