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.

Related Topics

Relating Objects from Analysis Services to Strategy