Databases Reference
In-Depth Information
StrtoSet
(SecurityMemberSet.SecurityMemberSet.getAllowedSet
(USERNAME, "City"))
Test the security restriction using the cube browser and change to one of the
local users and verify the current user is only able to see the locations for
which he has been given access.
The external function approach provides maximum flexibility in terms of
design approaches. Also, you do not have the overhead of processing a
measure group or dimension whenever there are changes to security restric-
tions. Security restrictions are always immediate because they are queried
directly from the relational database each time; hence, you need to make
sure the relational server is up and running all the time. Implementing this in-
volves some amount of coding and proper error handling, but it should be
worth spending the time up front to implement this type of solution.
Search WWH ::
Custom Search