how to join two columns side by side in MDX in SSAS

Asked Jan 08 '16 at 05:15

Active Feb 24 '16 at 19:53

Viewed 476 times

I have a query where it will give Schema Columns of the table.

Select level_caption from $system.MDSchema_levels
Where [Cube_name] = 'Quote' 
AND [Dimension_Unique_name]= [QUOTE TABLE NAME] AND NOT[LEVEL_IS_VISIBLE]

Select level_caption from $system.MDSchema_levels
Where [Cube_name] = 'Quote' 
AND [Dimension_Unique_name]= [QUOTE TABLE NAME] AND [LEVEL_IS_VISIBLE]

Here I'm going to get Visible and Non Visible Columns

how I can put Visible and NON-Visible Columns side by side OUTPUT :

Visible  Non-Visible
col1      col2
col3      col4
col5      col7
col6

edited Feb 24 '16 at 19:53

Tab Alleman

31,483
7
36
52

asked Jan 08 '16 at 05:15

mohan111

8,633
4
28
55

No in SSAS only @SouravA – mohan111 Jan 08 '16 at 09:34
I don't think it's possible to achieve this as DMX(language of DMV's) do not support SQL keywords such as `CASE`, `JOIN`. Try handling it in the reporting tool. – SouravA Jan 08 '16 at 10:26
This isn't MDX. In MDX you would just put the `LEVEL_IS_VISIBLE` dimension on columns. – Tab Alleman Jan 11 '16 at 21:32

how to join two columns side by side in MDX in SSAS

0 Answers0