Categories
- All Categories
- 151 Oracle Analytics News
- 28 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
How To Restrict Values In OTBI Dashboard Prompt Based On Security

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):
Answers
-
You may review:
How To Restrict Values In OTBI Dashboard Prompt Based On Security (Doc ID 2041756.1)
0 -
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.
0