topic Re: SSAS Cube MDX Metadata formatting in DAX Commands and Tips

SSAS Cube MDX Metadata formatting

GLWY — Wed, 21 Aug 2019 09:58:07 GMT

Hi,

I am quite new to MDX but I need to get the following:

select [ID],[Name],[Description],[ModifiedTime] from $system.TMSCHEMA_MODEL

and replace Description with a text if it is NULL.

Can anyone help me with this?

Thanks,

GLWY

Re: SSAS Cube MDX Metadata formatting

Anonymous — Fri, 23 Aug 2019 12:18:51 GMT

Please find the right forum for such questions. This forum deals with DAX only. Not with MDX and not with the retrieval of metadata from models through a subset of SQL...

Best
D.