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.
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.
Want to know more about OneStream Software? Please complete the form below and we'll get back to you shortly.
OneStream CPM
OneStream aligns to your business needs and changes more quickly and easily than any other product by offering one platform and one model for all financial CPM solutions. OneStream employs Guided Workflows, validations and flexible mapping to deliver data quality confidence for all collections and analysis while reducing risk throughout the entire auditable financial process.