Oracle Analytics Cloud and Server

Products Banner

BIP Report Permissions - Admin vs Consumer

Received Response
70
Views
8
Comments

Summary

BIP Report Permissions - Admin vs Consumer

Content

Hello

 

I have a BIP report embedded in an OBIEE dashboard. The report runs fine when one is logged in as the Admin. When the user is logged in as BI Author / BI Consumer the  following error shows;

 

Error detail.JPG

Answers

  • 3601907
    3601907 ✭✭✭✭

    On Thu, Mar 29, 2018 at 10:45 AM, community-admin <

  • YGUTTIKONDA
    YGUTTIKONDA ✭✭✭✭✭

    Check the bipublisher.log file for the detailed error message

  • 3601907
    3601907 ✭✭✭✭

    The DataSource is correct and the same for all the LOVs . I tested the

    connection and it connects successfully. I checked both objects

    datamodel/report and Consumer has permissions.

    Not sure where to look next

    On Thu, Mar 29, 2018 at 9:11 AM, community-admin <

  • YGUTTIKONDA
    YGUTTIKONDA ✭✭✭✭✭

    please open the report as the Admin user and check what the DataSource if for the LOV for the P_BUSINESS_UNIT (especially if you migrated the report from one env to the other).
    Also verify in the JDBC connections , open the relevant datasource and make sure the BI Author / BI Consumer has access to the connection.

    Hope this helps.

    --YG

  • YGUTTIKONDA
    YGUTTIKONDA ✭✭✭✭✭

    Can you check the connection details in the BI Publisher DataSoruce level ??

  • 3601907
    3601907 ✭✭✭✭

    We OUD and Active Directory (AD). The Security area of the JDBC connection

    has no role to choose from to grant the access. Do I have to manually type

    in the roles and then grant them access? Shouldn't there be a list I can

    choose who to grant access to? As you can tell I am a BIP novice and trying

    to soak it all in. Thank you for your help with this issue.

    On Fri, Mar 30, 2018 at 7:20 AM, community-admin <

  • 3601907
    3601907 ✭✭✭✭

    I checked the DataSource and tested the connection. That's working just

    fine. Connects successfully

    On Fri, Mar 30, 2018 at 7:17 AM, community-admin <

  • YGUTTIKONDA
    YGUTTIKONDA ✭✭✭✭✭

    As when you create a JDBC datasource you would give permissions to various roles based on your security setup. So my assumption is the BI Author and BI Consumer are missing this ..