How To Restrict Values In OTBI Dashboard Prompt Based On Security

vjsalve

Summary:Want to Restrict Values in OTBI Dashboard Prompt based on Security

Content (required):You have a role that has access to an OTBI Dashboard, and the data in the report reflects the security of the role. However in the dashboard prompt, we have a ledger name List of Value, and on the drop down all of the values are listed even the ones that the user is not supposed to see. Is there any way that the values in the dropdown of this dashboard prompt can be restricted based on the user's data security?

General Ledger – Journals Real Time

Version (include the version you are using, if applicable):22C 

Code Snippet (add any code snippets that support your topic, if applicable):

Raghavan p-Oracle

You may review:

How To Restrict Values In OTBI Dashboard Prompt Based On Security (Doc ID 2041756.1)

Amrita Gupta-Oracle

Hi @vjsalve

The security in the role restricts the data in the fact. To enforce the same restrictions in the prompts created using dimensions, refer to the fact through a metric. This can be done with the help of a logical sql which uses selects both the dimension column(ledger in your case), and, a column from the fact(e.g. Balance Amount for GL SA). Then the user would be able to see data for the specific ledgers he has access to.