CODEWITHSUNDEEP
sql-server-2008mdxolapcubessas-2008
Ardalan Shahgholi
Ardalan Shahgholi

Reputation: 12565

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

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.

Upvotes: 1

Views: 5432

Answers (2)

Ardalan Shahgholi
Ardalan Shahgholi

Reputation: 12565

i finded this :

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

Upvotes: 1

Endokr
Endokr

Reputation: 98

Use MDSCHEMA_DIMENSIONS schema request without restricting cube or dimension.

Upvotes: 2

Related Questions