Hi,
We would like to apply a restriction on a group, the restricted group will see the balances as 0, other groups will see all the balances.
Is there any way to implement the restriction on the data level.
I created the object with the following query but whenever the new user added to the BOE, I need to update all the objects in the universe.
SUM(CASE WHEN @VARIABLE('BOUSER') IN ('00212','00864','00129') AND MIS_TRANSACTION.RESTRICTED="YES" THEN 0 ELSE MIS_TRANSACTION.AVAILABLE_LC_BALANCE END)
Could you please guide me if there is any option to implement the security at the group level.
Regards,
Sadiq.