TM1 Forum

Hello,

I am trying to apply a rule only to the Leaf of a particlaur item in the hierarchy. The cube has 6 dimensions and one dimension has 6 levels.

Eg.if this is the hierarchy I would like to apply the formula to Leaf of A1 i.e. A11, A121, A122, A13 and A14

Thanks...

A
-A1
--A11
--A12
---A121
---A122
--A13
--A14
-A2
B
C

At least three ways occur to me:

a put n: on the right hand side of the rule eg
['Value'] = n: ['Cost'] * ['Price'];

b Test the level of the element - 0 is the lowest
['X'] = if(ellev('Product',!Product) = 0, ['Y'],
#else
stet);
c Use ISLEAF

Using n: is the best approach, indeed I would assert that this should be on the vast majority of rule lines. Use <blank> for 'KPI' rules eg
['Gross Profit %'] = ['Gross Profit'] \ ['Revenue'];
and c: only rules are generally bad news as they interfere with the consolidation logic. (NB I said _generally_.)

Use ellev if you need to apply the rule to parents in other dimensions, but to base levels in this one.

I don't think I've worked out whether ISLEAF is useful, but it's there for completeness.
HTH

You will have to use the ELLEV() function within your rule.

So your rule will look something like this:

[Area]=IF(ELLEV('Dimension',!Element)=0,'True', 'False');

You can also use N: in your rule. Depends upon what you are trying to achieve.

Thanks for the input.

The formula has to apply to a specific item in the hierarchy, so it has to apply to Leafs of A1, but Not the leafs of A2 or B or C, Just leafs of A1.

Do you have access to the RTMF?

You can use ELISANC() function in your rule

[Area]=IF((ELLEV('Product',!Product)=0) & ELISANC('Product', 'A1', !Product)=1),'True', 'False');

Hope this helps!

Thanks Kaif, it worked, but instead of ELLEV I just used N:, do you think its ok.

What is RTMF?

Yes that should be fine. You can use N: instead of using ELLEV() - but depends what you are trying to do. But I assume in your case it should be fine.

RTFM is referred to the Manual. Please dont ask me what RTFM stands for

Kaif, which Manual is RTFM, I don't think I have it, can you please attach it with this thread?

Thanks

RTFM is an acronym that suggests that you will find what you are looking for in the manual. It is not name of the manual itself.

Martin

Darn, a simple Google search told me what it is.. Read the ****** Manual...

tryinghard wrote:Kaif, which Manual is RTFM, I don't think I have it

Wow...that is so funny. According to the experts all the Manuals are RTFM and every one have got them