Hello friends,
i have to ask here again, my BI colleague build up a new Structure of a Cube to calculate the costs of our employees, now i have to write the rule for this.
I have a issue with one Dimension and the logic behind the Input fields, let me show you the structure:
The Elements i marked Yellow, are the one that should be a input field, the others should be calculated, now i dont find a way to ask in the rule if the element is under "Nicht Dienst überlassene rMA" or under "Dienstüberlassene rMA".
I mean i could change the Hierarchy of the Dimension, but i think it should be also possible with this structure, cause my colleague is here since many years.
Thanks for your help!
Have a nice Day
BR
Input field - How to define input and calculated fields
-
- Posts: 117
- Joined: Fri Aug 09, 2019 10:11 am
- OLAP Product: TM1 / TM1 Web / Perspectives
- Version: Planning Analytics V2.0.9
- Excel Version: Office 365
Input field - How to define input and calculated fields
Last edited by HighKeys on Tue Sep 24, 2019 11:55 am, edited 1 time in total.
-
- MVP
- Posts: 2831
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Input field - How to define input and calculated fields
Research the rule functions ELPAR and ELISANC. Either of these will work. BTW, collage is a type of art.
-
- Posts: 117
- Joined: Fri Aug 09, 2019 10:11 am
- OLAP Product: TM1 / TM1 Web / Perspectives
- Version: Planning Analytics V2.0.9
- Excel Version: Office 365