Hi All,
I am facing an issue with Alternate hierarchy.
In my following example:
G1 A1 S1 11
G1 A1 S2 22
K1 A1 S1 33
When A1 is under G1 then it has S1 & S2 as a child.
When A1 is under K1 then it only has S1 (This kind of data is possible in our project)
So Now I am getting 2 problems while loading such kind of data in TM1:
1) When I create a dimension in TM1 then S1 & S2 both are coming under G1 & K1 hierarchy (K1 should only contain S1 as per the example)
2) When I load this data in Cube then out of 2 values of S1 ( 11 & 33) TM1 is taking only one value randomly.
Please see attachment for both the issue.
I am able to resolve these issue by adding parent name also with Child name like G1.A1.S1 , G1.A1.S2 and K1.A1.S1 but in order to show proper hierarchy structure to users, I have to hide such name with some Alias & again Alias cannot be duplicate.
Does TM1 provide Use Value & Display value kind of logic?
Can anyone help me to resolve both the issue?
Thanks in advance.