Strategy ONE
Translating Dimensions to Strategy
| Analysis Services 2012/2014/2016/2017/2019/Azure ---> | XMLA ---> | Strategy |
|
Dimension |
Dimension |
Dimension |
-
Analysis Services 2012/2014/2016/2017/2019/Azure: Dimension
In Analysis Services 2012/2014/2016/2017/2019/Azure, a dimension is defined from one or more data source tables. A data source does not always map directly to the tables in a relational database. All columns in the tables are eligible to become attributes of the dimension. Each attribute is used to define a hierarchy within the dimension and multi-level hierarchies can be defined as well.
An Analysis Services 2012/2014/2016/2017/2019/Azure dimension appears as a Strategy dimension for Strategy users. Each dimension represented in Strategy can have one or more Strategy hierarchies.
-
XMLA: Dimension
A dimension in XMLA defines a logical category of analysis. For example, Time and Geography are dimensions along which you can slice data.
Measures (metrics) are stored in a special measure dimension. In this way, measures are yet another dimension of a cube.
Measures in XMLA are the members of the Measures dimension in Analysis Services 2012/2014/2016/2017/2019/Azure. These can be columns in the data source table or calculated members represented by formulas with associated aggregation rules.
-
Strategy: Dimension
A dimension object in Strategy is similar to an XMLA dimension. It is used to group attributes and relate them to each other by defining parent-child relationships.
