Call Us: 1-800-497-0151


Creating a List Box Parameter to Display Different Lists Based on Security

  • , Sr. Consultant

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”.

Create XFBR

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”.

oracle epm automate

3. Create List Box and Assign the Parameter: The parameter that was created above is assigned as the Bound Parameter.

oracle epm automate

4. Results: What users will see in their respective List Box.

oracle epm automate

Contact MindStream Analytics

Want to know more about OneStream Software? Please complete the form below and we'll get back to you shortly.

Partner SpotLight

OneStream Diamond Partner

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.

OneStream Profile