Oracle Analytics Cloud and Server

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

Has anyone done parameterized dashboards on OAC DV UI?

Accepted answer
35
Views
1
Comments
Partha P Pramanik
Partha P Pramanik Rank 2 - Community Beginner

Hi

We are looking to build individual dashboards on Oracle Analytics Cloud Data Visualization platform that can take username/role/account number as an input parameter and display the data accordingly. We would like to access this dashboard from a on-prem Apex application.

Is it something anyone has done before?

If yes, any guidance will help.

Thanks in advance.

Best Regards

Partha.

Best Answer

  • SteveF-Oracle
    edited Jul 9, 2025 6:41PM Answer ✓

    Hi Partha,

    You can embed Oracle Analytics Cloud in APEX, here is a fantastic blog on the topic.

    Embed Oracle Analytics into an APEX app using any login mechanism

    You can pass parameters
    Examples here:
    https://medium.com/oracledevs/how-to-pass-values-from-embedded-oracle-analytics-to-oracle-apex-8d71b6aea00c

    https://medium.com/oracledevs/embedding-oracle-analytics-into-oracle-apex-task-approvals-db717f86ffab

    Not sure about your use case for "username" you wouldn't want to expose anything in a URL,etc., but OAC can filter data based on user roles.

    Other comments, weclcomed.