Oracle Transactional Business Intelligence Idea Lab

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

OTBI Reports Cannot Be Restricted by Data Access

573
Views
8
Comments

Organization Name

Prospect Medial Group

Description

OTBI reports do not take into account data access when displaying results. We need data security to extend into OTBI reports.

Referenced previously in :Bug.: Bug 30046426 - PAYABLES INVOICES - TRANSACTIONS REAL TIME NOT RESTRICTING BUSINESS UNIT

 

Use Case and Business Need

OTBI reports are unusable for this customer since they need all data secured by the corresponding data access.

Original Idea Number: 4a5336c5d7

Tagged:
8
8 votes

Submitted · Last Updated

Comments

  • Donna Curtis
    Donna Curtis Rank 3 - Community Apprentice

    This is a very interesting idea.  I am not sure I am following you though.  Can you provide more detail as to what you are seeing in OTBI?  The bug mentioned is associated to seeing all of the Business Units in the prompt or List of values in the report, not the fact that the user sees Data associated to the Business Units they do not have data access for..  Are you actually seeing data associated to Business units that the user does not have data access assigned for?  

  • Mattieu Bastiaanse
    Mattieu Bastiaanse Rank 1 - Community Starter

    With multiple countries (set up as Business Units) live on Oracle, we are now quickly having the problem of BI reports that are not restricted in data access.
    We need some kind of data access restriction, so that users from 1 country (business unit) cannot see data fro other countries (business units).
    This goes across modules, not only AP, also AR.
    Example: AR Specialists of 1 country should not be able to see Aged Debt Reports from other countries, with certain customer data (or person) information.

  • User_EA2PD
    User_EA2PD Rank 1 - Community Starter

    Good Idea!

  • Sampath Kota-Oracle
    Sampath Kota-Oracle Rank 3 - Community Apprentice

    Restrict access to OTBI based on data access set. Implement data access security on OTBI reports.

  • Ahmed Maher K.
    Ahmed Maher K. Rank 6 - Analytics Lead

    Good idea. Would like to see it implemented.

  • Sinem Ozmen -Oracle
    Sinem Ozmen -Oracle Rank 2 - Community Beginner

    Hello,

    Can you please let me know if data access is implemented for BI reports ? As explained above, users who have access to the report should not see the data of all BUs.

    Thanks.

    Regards,

    Sinem

  • LaurentDup
    LaurentDup Rank 1 - Community Starter

    Hi, ADEO-Leroy Merlin which have 1000 Financials End Users, needs that OTBI Reports are Restricted by Data Access sets

  • Tanveer Kaur Bawa
    Tanveer Kaur Bawa Rank 1 - Community Starter

    how about Person Security Profile already in place. but why it is not working for an OTBI report where the report is capturing salary and assignment history?

    Example there are 4 LEs - LE1, LE2, LE3, LE4.

    and 'LE1' users ( General Manager, HR ) when log in should see LE1 data only and 'LE2' users should have access to see LE2 data. where LE is Legal Employer.

    but when General Manager, HR logs in - she is able to see all LE data which is not right.

    Any help ?