Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

How to ensure the relevant BU Data Access for OTBI reports?

Received Response
733
Views
9
Comments
Sinem Ozmen -Oracle
Sinem Ozmen -Oracle Rank 2 - Community Beginner
edited February 21 in Oracle Transactional Business Intelligence

Hello,

I assigned the Employee role to a user in order to give access to the reports in Reports and Analytics tab. However, when the user runs the report, all data from all BUs are listed. For example, the user does not have any access to SolarEdge TW BU, but the user can see the transactions of SolarEdge TW BU in the report.

Is it possible in OTBI to consider the BU data access ?

Thanks.

Regards,

Sinem

Tagged:

Answers

  • Gayatri Chappalli-Oracle
    Gayatri Chappalli-Oracle Rank 3 - Community Apprentice

    Hi,


    OTBI Shows Secured Data based on Data Access provided for a heirarchy to the Logged In User through Manage Data Access for Users Task. If User has been assigned a Single BU Data access, then logged in user will not be able to view data of other BU's from OTBI Subject area.


    Please go through My Support Oracle Note for more information


    Is Data Access Set Security Enforced in OTBI Reports For The GL Related Subject Area? (Doc ID 1512211.1)

  • Sinem Ozmen -Oracle
    Sinem Ozmen -Oracle Rank 2 - Community Beginner
    edited July 2023

    Hello,

    This user does not have access to SolarEdge TW BU.However, when i run the report, the user can see the transactions that are created against to SolarEdge TW BU...

    Data Access :

    image.png

    Report:

    image.png


    Regarding this document (Is Data Access Set Security Enforced in OTBI Reports For The GL Related Subject Area? (Doc ID 1512211.1)), could you please also let me know how data access sets can be created ?

    There is an idea in cloud customer connect: OTBI Reports Cannot Be Restricted by Data Access — oracle-products (Idea Number: 4a5336c5d7). But I'm not sure if the idea is implemented or not as the status is "Submitted"

    Thanks.

    Regards,

    Sinem

  • Gayatri Chappalli-Oracle
    Gayatri Chappalli-Oracle Rank 3 - Community Apprentice

    Hi,


    Is the Output in Screen shot from OTBI Subject Area. Can you please provide which Subject Area you are using.

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

    Hi,

    It's the custom BIP report. Is it possible to restrict the data access for custom BIP reports ?

    Thanks.

    Regards,

    Sinem

  • Gayatri Chappalli-Oracle
    Gayatri Chappalli-Oracle Rank 3 - Community Apprentice

    Hi,


    Embed this below piece of code in BIP report :

    This Code will pull Business Units associated with Logged in User based on Data access provided.

    In BIP Report, we can restrict using this:

    select * from fun_all_business_units_v fabv

    where fabv.STATUS = 'A'

          AND fabv.bu_id in (select distinct role.org_id

    from

    fusion.FUN_USER_ROLE_DATA_ASGNMNTS role

    ,fusion.per_users pu

    ,fusion.per_roles_dn_vl pr

    WHERE 1=1

    AND pu.USER_GUID = role.USER_GUID

    AND pr.ROLE_COMMON_NAME = role.ROLE_NAME

    and role.ACTIVE_FLAG ='Y'

    and pu.username = :XDO_USER_NAME)

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

    Thanks Gayatri,

    We'll check and come back to you.

    Regards,

    Sinem

  • Clare Murtagh - new
    Clare Murtagh - new Rank 5 - Community Champion

    Hi @Gayatri Chappalli-Oracle - is there a similar method we can apply to OTBI? I have posted something similar in another thread. The employee will see the same data as their HR access report, despite this report being added as an app on their 'Me' tab.

  • Gayatri Chappalli-Oracle
    Gayatri Chappalli-Oracle Rank 3 - Community Apprentice

    Hi ,

    OTBI Analysis always works based on data access only.

    This feature or functionality is already in place with OTBI.

    If you can provide more details or the thread which you are referring to, i can review details and respond.

    Thanks

    Gayatri

  • Arya Rajan
    Arya Rajan Rank 1 - Community Starter

    I have a similar requirement in OTBI for creating a dashboard and for me also all the BU records are showing even if I have access only to 1 BU. Any specific setups required to restrict the data based on the data access granted to the user in OTBI.