BIP Report Permissions - Admin vs Consumer

3601907

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;

 

3601907

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

YGUTTIKONDA

Check the bipublisher.log file for the detailed error message

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

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

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

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

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

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 ..