OACS Essbase Security Filters

Setting up security filters manually and using Maxl script in OAC Essbase and assigning it to Users and Groups.

As you know security is most important thing in any field likewise in OACS also. So in this blog I will show you how to create security filter’s in OAC Essbase and restrict the user to see the data. I will be doing in two ways.

• 1      Manually
• 2      Using MaxL

So, let’s get started.

First let’s have a brief discussion about the Filter’s.

Filter are used to control security access over the cube data. It can be assigned to a user or group. Depending on the security role of a user determines whether you can create, assign, edit, copy, rename, or delete a filter.

Filters have two important things – Access and Member specification.

Access – Access are of four types in OAC Essbase

1.     None - No data can be retrieved or updated

2.     Read - Data can be retrieved but not updated

3.     Write - Data can be retrieved and updated

4.     MetaRead - Metadata (dimension and member names) can be retrieved and updated.

Member specification - Specify dimension or member names, alias names, member combinations, member sets that are defined by functions, or substitution variable names, which are preceded by an ampersand (&). Separate multiple entries with commas.

If you want to know more about the Filter’s, please go through Oracle documentation.

So let's create some filters.

·         First method is the manual method. So open up your OACS environment. Go to Application Tab

Then go to your Application->Database and Inspect.

·         After that go to Filter Tab.

·     Click to Add button  +   in the right corner. A window will be opened. Write your filter name at Textbox down the Filter Editor. Here I took “F1JanAct”.

·        



Here comes the interesting part assigning the Access to the members in the cube. In the right corner click the + Add button.

·     As you see the above image None row has been added. Now select the Access and the member specification. And Save it and Validate it. If some syntax or any other error is there, then it will be shown on the same window.

·         Now to assign this Filter to User or Groups. Click on Permissions.

·         Now Click at the right corner Add button   

·        In the Search bar type the User or Group name and select it. Assign it to the Filter. Close the window. Volla! Your filter is ready to use.

 Now let's jump to the second method i.e; Maxl script.

·        So first go to your OACS Essbase interface.

·        Go to your application database. Here its “RPTSBD22”. And click the Action button. And go to Inspect.

·        After clicking Inspect you will navigate to this page.

·       Now click the Add button at the left corner. You will be navigated to below page. Now enter the Filter name below the Script Editor. Here its “FilterCreate”. At the blank area enter your Maxl script. Now click Save and Close.

·       Here you can see FilterCreate Maxl has been created.

·       Similarly create one more Maxl to assign the filter to user. Here I named it “AssignFilter”.

·       Now to run the Maxl, we need to navigate to JOBS tab(See below image). Click “New Job” at the left corner. And click “Run Maxl”.

·       Now select the Application, Database and the filter. Click “OK”.

·       Note: First run the “FilterCreate” Maxl then after the “AssignFilter”.

If Job is successfully executed, the status of the job would be green. 

Congratulation you have successfully created and assigned Filters both manually and using Maxl.