ElIsAnc function.

Suggest and discuss enhancements for TM1
Post Reply
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

ElIsAnc function.

Post by Steve Rowe »

A small change to the way the ElIsAnc function would be great.

At the moment the ElIsAnc function does not include the parent we are testing as a positive result. Typically when we use ElIsAnc in rules we have to do two if statement checks if we are interested in the results in at the C level
[]=C:IF(ELISANC('Dim','GTPL 100000000000',!Dim)>0 & !Dim@='GTPL 100000000000',STET, 'Blah');

If the parent element of the dimension was included in the positive result set then this would simplfy the use of this function.

I can't really see a downside to this, any views?

Cheers,
Technical Director
www.infocat.co.uk
Post Reply