ELPAR with multiple hierarchy

[appleglaze28]

I have a question I have 1 cube with the dimension category: 1. Hardware, 2. Software & 3. Others. I formed a cube with this dimension to input rates.

I have a cube that has my products and its 2nd top Product Category is 4, Hardware, Software, Others & Services. I need to load the rates from my first cube to the 2nd cube using their parent as basis to transfer the rates. I wrote the rule ['Rate']=IF ELPAR('base_product',!base_product,6)@='Software', 1,STET); etc... but it doesn't seem to work.

For the product I have 2 hierarchy one is per brand which is has 2 level of consolidation Total & Brand Name, the other hierarchy has 7, the top being Total & the 2nd top being hardware, software, etc...

Does having 2 hierarchy cause problem with making the rule work?

[John Hobson]

Yes it will cause problems

Use an attribute instead (See multiple threads in this topic by searching for "attribute" and "elpar")

[Steve Rowe]

Appleglaze28,
You can do it using rules too but it will be 'slow' (slow for TM1 anyway).
The best approach (IMO) is to write a rule in the attibute cube to calculate the parent and then use a TI to copy it into a string attribute, this means that your test is fast (since we are not doing the hierarchy test many times and the value we are testing against is an input so we don't have any caching issues).

Your rule would be something like this where TopParent is the top of the hierarchy we are interested in.

['RuledParent']= S:
If ( ElIsAnc( 'base_product' ,'TopParent',ELPAR('base_product',!base_product,1))=1, ELPAR('base_product',!base_product,1),
If ( ElIsAnc( 'base_product' ,'TopParent',ELPAR('base_product',!base_product,2))=1, ELPAR('base_product',!base_product,2),
#not the increase in the index on the Elpar, you need as many of these as there are possible parents in the hierachy.
...
'not found').....);

TI the result of this into another string attribute and then test against it in the rules, you do need to make sure you run this TI everytime you update the dimension.
Cheers