how to retrieve the structure of an OLAP cube

Question

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.

Which OLAP solution are you using on top of you MySQL DB : icCube, MSAS, Mondrian ? — Marc Polizzi, Jun 04 '12 at 23:46
I am not the OLAP provider, I am just a consumer. The mysql queries were only examples of the metadata queries that I wanted to do in order to get the OLAP structure (which I do not know). — Elzo Valugi, Jun 05 '12 at 06:24

score 4 · Answer 1 · answered Jun 04 '12 at 12:33

4

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.

answered Jun 04 '12 at 12:33

cairnz

3,917
1
18
21

I am doing all this from PHP so I cannot install extra stuff, but I think you gave me a good direction. Thanks – Elzo Valugi Jun 04 '12 at 12:37

score 2 · Answer 2 · edited May 23 '17 at 12:20

2

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.

edited May 23 '17 at 12:20

Community

1
1

answered Jun 04 '12 at 12:29

Preet Sangha

64,563
18
145
216

how to retrieve the structure of an OLAP cube

2 Answers2