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

Sinem Ozmen -Oracle

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

Gayatri Chappalli-Oracle

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

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 :

Report:

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

Hi,

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

Sinem Ozmen -Oracle

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

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

Thanks Gayatri,

We'll check and come back to you.

Regards,

Sinem

Clare Murtagh - new

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

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

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.