Page 1 of 1

Input field - How to define input and calculated fields

Posted: Tue Sep 24, 2019 10:38 am
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 1960 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

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

Posted: Tue Sep 24, 2019 11:04 am
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.

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

Posted: Tue Sep 24, 2019 11:56 am
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