Conformed Dimension and TM1
-
BariAbdul
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Conformed Dimension and TM1
My client wants new TM1 to be designed along the DWH conformed dimension Model.What i understand is conformed dimension is needed when one dimension table is linked with more than one fact table.How conformed dimension is relevant in TM1,if it is then what is the best practice?Thanks
"You Never Fail Until You Stop Trying......"
-
qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Conformed Dimension and TM1
In TM1 any dimension is by definition a shared dimension, therefore a 'conformed dimension' that can be used in multiple cubes (corresponding to fact tables in a relational DWH).
Kamil Arendt
-
Duncan P
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Conformed Dimension and TM1
There are circumstances where TM1 still needs separate dimensions which conform. Here are two that I can think of.
1. Two cubes hold data at different levels of the same hierarchy, e.g targets at the sales region level and plan at the seller level. In this case there would need to be a dimension for each level.
2. Bill of materials, where the recipe needs to have two dimensions, one for the production components and one for the production outputs. However outputs can be WIP which can be components of subsequent recipes. Here the restriction is that a cube cannot contain the same dimension twice to avoid ambiguity in the rule syntax.
In both of these instances it will be necessary for the dimensions concerned to be built in a coordinated way from common sources.
1. Two cubes hold data at different levels of the same hierarchy, e.g targets at the sales region level and plan at the seller level. In this case there would need to be a dimension for each level.
2. Bill of materials, where the recipe needs to have two dimensions, one for the production components and one for the production outputs. However outputs can be WIP which can be components of subsequent recipes. Here the restriction is that a cube cannot contain the same dimension twice to avoid ambiguity in the rule syntax.
In both of these instances it will be necessary for the dimensions concerned to be built in a coordinated way from common sources.