TM1 Contributor - approval hierarchy
Posted: Thu Oct 27, 2016 3:35 am
Hi All,
We currently have a dimension that has that 3 levels (level 2,1,0) i.e. Product Dimension:
2 - All Products
1 - Country {USA, Italy, England}
0 - Product {Item A, Item B ..}
This dimension is to be used for the contributor workflow BUT we only want users to select a country, therefore ignoring level 0.
As contributor only allows an approval hierarchy based on 1 top level consolidation and all children, we need to think outside the box. (Yes we could create another dimension in the cube called country, but let’s say we don't want to do this as we already have the country in the products dim).
Any ideas?
Cheers!
We currently have a dimension that has that 3 levels (level 2,1,0) i.e. Product Dimension:
2 - All Products
1 - Country {USA, Italy, England}
0 - Product {Item A, Item B ..}
This dimension is to be used for the contributor workflow BUT we only want users to select a country, therefore ignoring level 0.
As contributor only allows an approval hierarchy based on 1 top level consolidation and all children, we need to think outside the box. (Yes we could create another dimension in the cube called country, but let’s say we don't want to do this as we already have the country in the products dim).
Any ideas?
Cheers!