Click here to Skip to main content
15,906,625 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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%'
Posted
Comments
Member 11712753 12-Apr-16 23:18pm    
Have you ever tried to use SSMS to browse your cube?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900