OneStream Security
Clients frequently request limiting what users can see in OneStream based on security. These requests can vary greatly, but the following example can be used in a similar fashion in order to restrict, or grant access to “something” based on security, to fill the client’s requirement.
The example is going to show how to utilize security to display different lists in a List Box dashboard component.
How to execute the security-based list for your List Box Component?
1. Create an XFBR for the Parameter with a Security Group Boolean check: In this simple example, we are checking to see whether the user is in the “SalaryAcctGroup” security group. If the user is IN the group, then it will bring back a list that INCLUDES “A#SalaryAccounts”. If the user is NOT in the group, then it will bring back the same list EXCLUDING “A#SalaryAccounts”.
2. Create a parameter to assign the XFBR to the Member Filter: With the parameter set up properly, it will return the appropriate member filter based on whether the user is in the “SalaryAcctGroup”.
3. Create List Box and Assign the Parameter: The parameter that was created above is assigned as the Bound Parameter.
4. Results: What users will see in their respective List Box.
Contact
MindStream Analytics
Want to learn more about OneStream Software? Please complete the form below and we’ll get back to you shortly.

