list_metadata
Retrieve the exact bracketed unique names of SSAS cubes and dimensions to use in MDX/DAX queries. Pass a dimension to list its hierarchies and levels.
Instructions
List the queryable metadata of an SSAS cube or tabular model.
Returns the exact bracketed unique names to use in MDX/DAX - call this before writing queries so names aren't guessed. Without a dimension, the overview lists measures (with measure group and display folder), dimension names, and multi-level user hierarchies. Pass a dimension to drill into that dimension's full set of attribute hierarchies and levels.
Args: cube_name: Cube (multidimensional) or model (tabular, usually 'Model') to describe. If omitted, uses the SSAS_DEFAULT_CUBE environment variable; if that is unset too, returns the list of available cubes/models so one can be chosen. dimension: Optional dimension unique name (e.g. '[Dim Event]') to list every hierarchy and level in that dimension.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cube_name | No | ||
| dimension | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |