To dynamically embed parameterized Oracle analytics graphs on-demand inside Oracle digital assistant

Ankan Chanda

Summary:

Content (required):

Hi team,

As we are able to establish static graphs of Oracle analytics cloud inside Oracle digital assistant (ODA) through a web hosting app, now we are looking forward to on-demand dynamic graphs in ODA. So for eg., if a user asks what is the number of female employees and again asks what is the number of male employees to the chatbot, then ODA should be able to fetch graphs according to the user's on-demand questions, not by fetching readily made graphs but through use of any sorts of API or Web Services.

So we are currently using HTTP API Data action in which it says to take a REST API (URL) and anchor the variables that we want to pass on. So do we need to pass the webhosting app's URL or we need to pass REST API of those particular questions. For eg. in this project we are using APEX APIs for textual answers. So which URL to pass through? As we earlier passed APEX REST static API, it is saying invalid domain name (while adding the API in OAC Safe Domain).

We tried with this article : https://blogs.oracle.com/analytics/post/embedding-oracle-analytics-dynamically-part-i , where it says to create filter objects to embed the graphs dynamically onto external applications, but the graphs aren't visible in the web portal after executing the exact scripts from the blog.

We also tried with part 2 of the article i.e. https://blogs.oracle.com/analytics/post/embedding-oracle-analytics-dynamically-part-ii , where it is saying at the starting of the event type, "Subscribe to the publish event called 'oracle.bitech.dataaction' ". how to subscribe to the said event?

Please suggest if any other data actions we could try with apart from using HTTP API data action method.

Thanks and regards

Ankan

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

6.3

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