nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to limit the data in an OTBI Purchasing report depending on the person.

Sara González-Gaggero

I am creating a dashboard for Procurement (requests and orders).

However, it is a requirement from the client that the owners can only visualize their own requests/orders, but the managers/directors (that can be also requesters) can see all the information.

I have already limited by requesters using this query on the fields User name: LOCATE(USER(), "- Requisition Requester"."Purchase Requester User Name") and the filter: different from 0.

How can I continue and allow that the managers/directors can see all the information?

Find more posts tagged with

Accepted answers

Sara González-Gaggero

Resolved myself.

All comments

Sara González-Gaggero

Resolved myself.

Shailesh Kumar

Hi,

I have a similar requirement for project time cards and project-based PO, how did you achieve it?

Sara González-Gaggero

Hello @Shailesh Kumar,

I had to create a query where I limited by username (manager) and cost center (obtained from a substring of the charge account) = 1 where 1 is that they can see the information.

Hope it helps!