Add OTBI analysis to a data model using Security - Roles and Privileges Real Time

Sharon Harper

Organization Name
Bolton Council

Description :
We have built a BI report to bring back the details of roles assigned to users along with other information about the users, such as department, Manager, Email address, purchasing approval limit. This was not achievable using a OTBI report.
However, we now know that some roles cannot be picked using the tables that we are using and we are not allowed to use the the security console tables that start ASE_%.
The intention was to create a data model that would have both queries on them and then we could export is once and then do a lookup between both sets of data, however when we use the query below in the data model, it essentially times out.
SELECT 
   "Role"."Role Name" saw_0,
   "Role"."Role Display Name" saw_1,
   "Role Facts"."Number of Users" saw_2
 FROM "Security - Roles and Privileges Real Time"

We did raise an SR and was told that this is a current limitation as the Security - Roles and Privileges Real Time holds a lot of information to answer a wide range of question of roles directly assigned to users and those that a inherited in roles etc.

Use Case and Business Need (Required):
Remove the time out restriction on this area so that it can be added to a data model.

Enhancement Request / Service Request:
3-36574822941