TM1 Forum

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.

Try ISLEAF

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

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.