DAX Query Support - Expert Cube Development with SSAS Multidimensional Models - page 356

Mapping Multidimensional objects to Tabular
concepts
The following table shows how all of the major objects found in Analysis Services
Multidimensional and MDX are translated to Tabular objects for the purposes of
writing DAX queries:

Multidimensional Object Tabular Object

Cube Model

Cube Dimension Table

Attribute Keys and Names Columns in Tables

Measure Group Table

Measure not associated with a Measure Group Measure in a Table called "Measures"

Relationship between a Measure Group and a
Cube Dimension

Relationship between two Tables

Perspective Perspective

KPI KPI

User Hierarchy Hierarchy

Parent/Child Hierarchy Hierarchy

The contents of this table can be summarized very easily: when you view a
Multidimensional model through Power View, all measure groups and dimensions
look like tables, measures are measures, and hierarchies are hierarchies.

Unsupported features
Some functionality in Analysis Services Multidimensional is not supported for DAX
queries and Power View, but not much:

• Cell security is not supported at all. If a user is a member of a role that has

cell security applied, they will not be able to connect via Power View or run
DAX queries.