OTBI report parameter restriction to a particular user

Question

Hi All,

Good Day.

We have created one custom OTBI report and it has "Business Unit" as of one of the parameter. The related list of values is showing all the business units and we want to restrict it to the user who has the related Business Unit data access set access.

Please let us know how to achieve this in OTBI report.

Bhaskar Konar · Answer

Hi @Shivanand Hugar,

Additionally, I've attached a sample prompt configured using the above approach for reference. This should help illustrate the configuration and make the suggested solution easier to understand.

BU_PMT_Based_on_User.catalog

Hope this help.

Thank you.

Bhaskar Konar · Answer

Hi @Shivanand Hugar,

Welcome to the Oracle AI & Analytics Community!

One possible approach is to configure the Business Unit parameter using 'SQL Results' under 'Choice List Values'.

You can use the logged-in user's session variable (NQ_SESSION."USER") to filter the Business Units associated with the user's worker record.

For Example:

SELECT 

   "Business Unit"."Business Unit Name" saw_0

 FROM "Workforce Management - Worker Assignment Real Time"

 WHERE 

"Worker"."User Name" =  VALUEOF(NQ_SESSION."USER")

This approach retrieves the Business Units associated with the worker record corresponding to the logged-in user.

Please note: If your requirement is specifically to restrict the LOV based on the Business Unit data access granted to the user through their security roles, you should also verify that the query respects the applicable Business Unit data security configuration. The above condition filters based on the user's worker assignment and doesn't independently establish their security-granted Business Unit access.

Hope this help.

Thank you.

MandeepGupta · Answer

Hi,

Welcome to Oracle AI & Analytics community.

Please check if below thread helps:

How to Restrict Business Units based on user access in OTBI parameter lov - Oracle

Thanks.