If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Problem with Alternate hierarchy

Started by shrivas1, 01 Nov 2010 10:53:16 PM

Previous topic - Next topic

shrivas1

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.