0

How to Get All the Dimension Structure and Data from a Cube

This is great for getting all the a dimension, measure columns and keys without having access to the dev project of the cube/model.

This works with both OLAP and Tabular.

Here's an example query for the "Adventure Works" cube:

EVALUATE
SUMMARIZE(
                        'Internet Sales'

                        , 'Customer' [Customer.Key0]
                        , 'Customer' [Customer]
                        , 'Customer' [Education]
                        , 'Customer' [Gender]

                        , 'Product' [Category.Key0]
                        , 'Product' [Category]

                        , 'Promotion' [Promotion.Key0]
                        , 'Promotion' [Promotion]

                        , "Internet Sales Amount",
                          'Internet Sales'[Internet Sales Amount]
                        )
ORDER BY 'Customer'[Customer]

 

For more information and examples on this, please refer to these links:

 

http://www.sbrickey.com/Tech/Blog/Post/Querying_OLAP_Cubes_with_DAX

https://www.simple-talk.com/sql/reporting-services/using-dax-to-retrieve-tabular-data/

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 yrs agoLast active
  • 613Views
  • 1 Following