Skip to Content
0
Jun 04, 2018 at 08:17 AM

Maintaining Security in WEBI

103 Views

Hi All,

I have a WEBI report requirement where I am showing details for every department. For this, I need to maintain security.

Logic used for security is as follows:

  • First, when a user executes the report, the system checks which role the user belongs to and based on it finds out whether the user has access to the report.(Roles maintained at BI level)
  • If the user has access to the report, then the system checks the level of access for the objects i.e, it looks for Org Unit of the user.
  • Find out the list of Exception Reports (These are the reports where there should be no restriction of data i.e. if a user has access to the report, he/she should be able to see all the data).
  • If the report is not part of Exception Report:
  • a)Then, Get the User Name ID.
  • b)Get the Employee Details (Employee Number, Org Unit, Personal Area etc.) from the table EMPLOYEE based on User Name ID.
  • c)Get the Org Unit Hierarchy details based on the Org Unit from Employee Master Data.
  • d)The User data will be restricted to the Org Unit value (and its Hierarchy) which we got above.

My report is on Universe and I got to know that security can be handled in IDT, but can someone please let me know if there is a way to manage security in WEBI report through some coding without doing it in IDT.

Thanks

Poojitha.