Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

The :xdo_user_roles issue in BIP 11.1.1.9.0

Received Response
121
Views
8
Comments
Xiaochun Jin
Xiaochun Jin Rank 5 - Community Champion
in Oracle Analytics Forum

Summary

The :xdo_user_roles issue in BIP 11.1.1.9.0

Content

Hi

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.

12c.png

11.1.1.7.1g.png

Would you please help look at this issue?

Thank you very much!

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics & AI Coach

    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.

    select :xdo_user_roles from dual.

    please check and post if you have any issues. Thanks

  • Gang W Wang
    Gang W Wang Rank 2 - Community Beginner

    ​ Please help.

  • Xiaochun Jin
    Xiaochun Jin Rank 5 - Community Champion

    Hi

    Would you please help look at this issue?

    Thank you very much!

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics & AI Coach

    what is the browser you are using ?  internet explorer,chrome or Firefox ,please try in Mozilla or chrome.Thanks

  • Xiaochun Jin
    Xiaochun Jin Rank 5 - Community Champion

    Hi,

    The user is weblogic, and the My Account Popup is blank.

    What the cause is do you think?

    Thanks.

    11.1.1.9.0g_1.png

  • Xiaochun Jin
    Xiaochun Jin Rank 5 - Community Champion

    Hi

    I just tried internet explorer,chrome and Firefox, all Popups were blank.

    Do you think if there is any Hotfix for this issue?

    Thanks.

    IE.png

    chrome.png

    firefox.png

  • Gang W Wang
    Gang W Wang Rank 2 - Community Beginner

    Please help.

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics & AI Coach

    please disable any firewalls. Thanks