This content has been marked as final. Show 2 replies
No you can't apply security at the dimension level.
Have a look at the importsecurity utility and SL_CLEARALL to remove all the security from an application - http://docs.oracle.com/cd/E17236_01/epm.1112/hp_admin/ch03s07.html
What do you think about using batching up the planning app refresh and then adding a maxl script at the tail end to write a filter at the root in Essbase for all provisioned users?
Something like what Cameron Lackpour did with metaread filters here: