How can I get all cube and all dimensions and all measures in one DataBase in SSAS

1
votes

I use sql server 2008 r2.

I use SSAS service and i have one database that named GAC.

in my database exist 10 cube and in each cube exist several measures and dimensions

I need get all cubes, measure and dimensions with one select.

how can I do this?

in other hands, i need access to data definitions table or structure like sys.tables and sys.columns and sys.type and etc.

i need one select that it can query all data from SSAS database.

2
sql-server-2008mdxolapcubessas-2008

2 Answers

2
votes

Use MDSCHEMA_DIMENSIONS schema request without restricting cube or dimension.

1
votes

i finded this :

select 
    cube_name,
    measuregroup_name,
    measure_name,
    expression
from $system.dbschema_measures