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.
Rule to find Leaf Level of all dimensions in cube
-
- 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
Thanks
Micheline
Micheline
-
- Posts: 30
- Joined: Wed Sep 14, 2016 9:26 am
- OLAP Product: Planning Analytics Local
- Version: 2.0.4
- Excel Version: 2016
- 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
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
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
-
- 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
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.