Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want data level restriction in object for particular sheet to particular user.
As in my application there is multiple sheets..out of which only for last sheet objects want to restrict data..?
how to achieve it..?
Thus for objects in sheet1 want to restrict data for CIF_REGION,IA_REGION and Region
Please do needfull..
In the Excel instert also the 3 columns (CIF_REGION,IA_REGION and Region) with the restricted values for every user.
Then you can use this expression to show the restricted values for every Dimension.
=If(upper(OSUser())= USERID, Region)
=If(upper(OSUser())= USERID, CIF_REGION)
=If(upper(OSUser())= USERID, IA_REGION)