Strategy ONE
Translating Dimensions to Strategy
| TM1 ---> | XMLA ---> | Strategy |
|
Dimension |
Dimension |
Dimension |
-
TM1: Dimension
In TM1, a dimension is defined from one or more data source tables. 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.
A TM1 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 TM1. These can be columns in the data source table or calculated members represented by formulas with associated aggregation rules.
If the measures dimension in your TM1 MDX cube source uses a different name other than
[Measures]you can specify the name in your TM1 MDX cube source using the VLDB properties Name of Measure Dimension and MDX Remember Measure Dimension Name. For information on how to use these VLDB properties to specify the measure dimension name, refer to the Supplemental Reference for System Administration. -
Strategy: Dimension
A dimension object in Strategy is similar to an XMLA dimension. It is used to group attributes and to relate them to each other by defining parent-child relationships.