sql-server-2008mdxolapcubessas-2008

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.

Solution

  • Use MDSCHEMA_DIMENSIONS schema request without restricting cube or dimension.