I have a requirement to implement user security based on Company Code in my dashboard. I have scenarios where some user should be able to see all company code but some user should have specific company code access. So I have created two different DL for the same and restricted user with specifc company code(user security table). i am writing calculation like
if ISMEMBEROF('group1') then true
ELSEif ISMEMBEROF('group2') AND [username]=ATTR([User Security].[Sso]) then true
else false end
but this works only if i add company code on my view otherwise it is not working and user able to see all data. Is there any solution for it?
Thanks for posting! I would check out the following blog on applying the user filter to the extract itself.
Hope these help!