Rule to find Leaf Level of all dimensions in cube

Post Reply
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Rule to find Leaf Level of all dimensions in cube

Post by mnasra »

Hi Experts,

is there a 1 rule that help find the leaf level of all dimensions in a cube.
I know ELLEV will do each dimension. I can nest the Ifs.
But I am looking for a shortcut. (I have 10 dimensions in the cube).
Thanks.
Thanks
Micheline
daniel.havassy
Posts: 30
Joined: Wed Sep 14, 2016 9:26 am
OLAP Product: Planning Analytics Local
Version: 2.0.4
Excel Version: 2016

Re: Rule to find Leaf Level of all dimensions in cube

Post by daniel.havassy »

Try ISLEAF
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: Rule to find Leaf Level of all dimensions in cube

Post by paulsimon »

Hi

The leaf level is always level 0. Do you actually mean the maximum number of levels in each dimension? Please bear in mind that dimensions don't necessarily have the same number of levels in each leg of the hierarchy

Regards

Paul Simon
bgregs
Posts: 77
Joined: Wed Sep 12, 2018 11:19 am
OLAP Product: TM1 / Planning Analytics
Version: 2.0
Excel Version: 2016

Re: Rule to find Leaf Level of all dimensions in cube

Post by bgregs »

Both ELLEV and ISLEAF will work. The key is how you structure the left side of your rule. Use the open brackets ( [] ) to test every cell.
Post Reply