Creating Securities and Filters

           Essbase provides a system for managing access to applications, databases, and other artifacts within Essbase. Using the Essbase native security system provides protection and the security available through our local system.
           Essbase native security addresses a wide variety of database security needs with a multilayered approach to enable us to develop the best plan for our environment. Various levels of permission can be granted to users and groups or defined at the system, application, or database level.

To create a new user and assign some provisions we need to follow the steps below:

•  Go to shared services-> right click on “users” and create a new user:

• Click next and save.
• Then right click on “Groups” create a new group and then save. So now “new_user” and “new_group” are created. Now we need to provide some Provisions to the user.

• Now we need to provide access to the user. So need to right click on User name and provisions, then provide server access as shown.

• Later need to provide Write/Read access to new_user.

• Then to add filter right click on the server and provide “Assign Access control” to server:

• Now to assign a filter to the particular user group as follows:

• After provisioning filter to the user save it. If the provisions provided are with no errors then it shows as successful.
• Then open an excel sheet and log in with the user defined. Then as per the filter requirement the data will be visible.