nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

The :xdo_user_roles issue in BIP 11.1.1.9.0

Xiaochun Jin

Summary

The :xdo_user_roles issue in BIP 11.1.1.9.0

Content

When I using BIP 11.1.1.9.0, I got an Issue with :xdo_user_roles.

a. I created a new Application Role named ‘PLM4P_SUPER_USER’ in EM, and associated it with the weblogic user.

11.1.1.9.0g_0.png

b. In BIP, I created a new Data Set with following sql:

select 'Roles in 11.1.1.9.0', :xdo_user_roles as Roles from dual where instr('PLM4P_SUPER_USERrrr', 'PLM4P_SUPER_USER') > 0

But the 'PLM4P_SUPER_USER' role did not get displayed.

11.1.1.9.0g.png

When I performed the same steps in BIP 12c or 11.1.1.7.1, They were all working.

11.1.1.7.1g.png

Would you please help look at this issue?

Thank you very much!

Find more posts tagged with

Accepted answers

All comments

Venkat Thota - BIP

who is the user you are trying to run this data model to view roles?

if user is weblogic ,then this user has all permissions,

first login to bi publisher with weblogic user, on top right corner you will find signed in Tab as weblogic user ,then go to my account then view application ,where you will find all the roles associated with this logged user,all these roles must show up when you run below query from data model.