CODEWITHSUNDEEP
mdxolap
Elzo Valugi
Elzo Valugi

Reputation: 27866

how to retrieve the structure of an OLAP cube

I have access to an OLAP catalog, but I am not familiar with MDX. I am looking for the MDX equivalent of SQL:

SHOW DATABASES; 
SHOW TABLES;

I was looking at MDX language reference, but I could not find a way of getting the schema, the cube metadata. Thanks for helping.

Upvotes: 1

Views: 3238

Answers (2)

cairnz
cairnz

Reputation: 3957

You can use the $SYSTEM database to query your objects.

Use SELECT * FROM $SYSTEM.DISCOVER_SCHEMA_ROWSETS to get a list of things you can query. In your case it would most likely be DBSCHEMA_CATALOG, DBSCHEMA_TABLES and MDSCHEMA_CUBES.

This is very rough information, and using stuff like Preet suggests might be favorable in the end.

Upvotes: 4

Preet Sangha
Preet Sangha

Reputation: 65496

There is answer List dimension members with MDX query to show how list dimensions.

This open source project (TSSASM) shows how to query access the cube structure from a TSQL database.

However I think you may need XMLA commands to see what you need.

Upvotes: 2

Related Questions