Rule to find Leaf Level of all dimensions in cube

Post Reply
mnasra
Posts: 73
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: TM1
Version: 9.5
Excel Version: EXCEL 2010

Rule to find Leaf Level of all dimensions in cube

Post by mnasra » Thu Oct 18, 2018 7:59 pm

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 » Thu Oct 18, 2018 8:13 pm

Try ISLEAF

User avatar
paulsimon
MVP
Posts: 647
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: 10.1.1 and 10.2.2
Excel Version: 2013

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

Post by paulsimon » Thu Oct 18, 2018 8:29 pm

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: 37
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 » Thu Oct 18, 2018 8:29 pm

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