In a multi-user environment, is there a way to pass user login information that identifies the current user so our cube MDX code will filter the resulting display based on security of that user?
For example: Manager A, logs in and dynamically the information display is filtered for Manager A to their employees in the hierarchy. Meanwhile Employee B logs in and dynamically the information display is filtered for Employee B to only that employee in the hierarchy.
We're hoping to define groups and roles for security access and pass that information so the MDX can filter based on that security.