Adding two if loops to a statement
Posted: Tue Mar 05, 2024 7:58 am
I have two custom cubes to lock dimensions:
and the cube so_securitykhslperio:
with following dimension:
kh_jahr
kh_slperio
kh_versi
and }Groups (a "control object" for companies)
in so_security_kh_versio
with following dimension:
kh_jahr
kh_perio
kh_versi
and }Groups (a "control object" for companies)
I would like to use those two in an if statement to cancel a TI process if the comibination is not empty,
I was guessing something like that might work:
Aenderung=CellGetS('so_security_kh_versi',kh_jahr,kh_perio,kh_versi,}Groups);
if(Aenderung@<>'');
But there seems to be a problem with the "control objects".
Maybe someone of you can help me on that.
In addition it would be great to get a decent error message for the user, which period is locked if the process cancels. It could simply say: periode is locked.
Thank you for your help,
BR Simon
and the cube so_securitykhslperio:
with following dimension:
kh_jahr
kh_slperio
kh_versi
and }Groups (a "control object" for companies)
in so_security_kh_versio
with following dimension:
kh_jahr
kh_perio
kh_versi
and }Groups (a "control object" for companies)
I would like to use those two in an if statement to cancel a TI process if the comibination is not empty,
I was guessing something like that might work:
Aenderung=CellGetS('so_security_kh_versi',kh_jahr,kh_perio,kh_versi,}Groups);
if(Aenderung@<>'');
But there seems to be a problem with the "control objects".
Maybe someone of you can help me on that.
In addition it would be great to get a decent error message for the user, which period is locked if the process cancels. It could simply say: periode is locked.
Thank you for your help,
BR Simon