Skip to main content

Posts

Showing posts from August, 2019

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