I use an MDX Query to get a list of Databases from a SQL Analysis Service session, but I don't know how to write MDX queries.
How would I do something like the following :-
select * from $system.DBSCHEMA_CATALOGS
where CATALOG_NAME like '%_15%'
Note the first line works, but when I add the where clause it doesn't.
PS: I don't expect to need to write any other MDX queries in the future, so am not really looking to learn how to write MDX queries, via tutorials, etc. I am just looking for a solution to this one query.
FYI, the first part of the query returns data like the following (the middle 2 fields are empty) :-
select * from $system.DBSCHEMA_CATALOGS
CATALOG_NAME DESCRIPTION ROLES DATE_MODIFIED
Australia_DB_F1_Daily_Gap_FX_Base_151207090409 12/06/2015 22:04
What I have tried:
select * from $system.DBSCHEMA_CATALOGS
where CATALOG_NAME like '%_15%'