SSAS Cube MDX Metadata formatting

[GLWY]

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

[Anonymous · Accepted solution]

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.