Oracle Analytics and AI

Partha P Pramanik

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.

Steve F-2

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.