Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How To Restrict Values In OTBI Dashboard Prompt Based On Security

Received Response
376
Views
2
Comments

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

  • Raghavan p-Oracle
    Raghavan p-Oracle Rank 5 - Community Champion

    You may review:

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

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics Lead

    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.