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:
, '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: