Input field - How to define input and calculated fields

Post Reply
HighKeys
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

Post by HighKeys »

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:
Eingabe logik.PNG
Eingabe logik.PNG (13.68 KiB) Viewed 1662 times
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
Last edited by HighKeys on Tue Sep 24, 2019 11:55 am, edited 1 time in total.
tomok
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

Post by tomok »

HighKeys wrote: Tue Sep 24, 2019 10:38 am 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".
Research the rule functions ELPAR and ELISANC. Either of these will work. BTW, collage is a type of art.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
HighKeys
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

Re: Input field - How to define input and calculated fields

Post by HighKeys »

tomok wrote: Tue Sep 24, 2019 11:04 am
HighKeys wrote: Tue Sep 24, 2019 10:38 am 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".
Research the rule functions ELPAR and ELISANC. Either of these will work. BTW, collage is a type of art.
Hola tomok!

corrected my post, i was very hungry :lol:


Thanks for this function, i will check them :)

BR
Post Reply