Embedding Links to Oracle Analytics Cloud (Classic UI) in Oracle E-Business Suite

Thanks to Alex Ofenberg and Gali Gil from TAU and my colleague Tovit Leiba that guided me.  

In Oracle documentation here, we can see how to do "Embedding Links to Oracle Business Intelligence in Oracle E-Business Suite" (9.3 in Oracle® Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition). How to do something similar with Oracle Analytics Cloud (OAC)? It is very much the same, just be aware we are talking mostly about classic OAC UI (unlike the Self Sevice / DV UI).

 

To create a form function:

1. In EBS from the Application menu, select Function. The "Form Functions dialog" is displayed.

Each line in the function form is a link to specific analysis or Dashboard. The Function column is your internal Function name.

2. In the Properties tab of the menu, for the relevant function, select SSWA plsql function as Type

3. In  the "Web host" tab use the beginning of the OAC URL. For example "https://youroac-instance.analytics.ocp.oraclecloud.com"

4. In the "Web HTML" tab use the rest of the URL, starting with analytics.

For example my Dashboard URL is (can create this URL by using Dashboard Menu/Crete Prompted link): 

https://youroac-instance.analytics.ocp.oraclecloud.com/ui/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FAll%2F_portal%2Fcsr&Page=page%201&Action=Navigate 

 That is converted to this (%2F = / and %20 = space)

https://youroac-instance.analytics.ocp.oraclecloud.com/ui/analytics/saw.dll?Dashboard&PortalPath=/shared/All/_portal/csr&Page=page%201&Action=Navigate

I use the first part of the URL as Web Host, skip the "/ui/" part and use the rest in Web HTML (HTML call).

In this case: analytics/saw.dll?Dashboard&PortalPath=/shared/All/_portal/csr&Page=page%201&Action=Navigate

 

That is all, except the following: You will probably want to modify the URL so it doesn't bring the OAC menu etc...

2 options:

1. The recommended one is to use PortalPages instead of Dashboard, in our case: 

analytics/saw.dll?PortalPages&PortalPath=/shared/All/_portal/csr&Page=page%201&Action=Navigate

 

 2. The older one of adding syndicate=Siebel to the URL (this is a bit more violent method)

analytics/saw.dll?Dashboard&PortalPath=/shared/All/_portal/csr&Page=page%201&syndicate=Siebel&Action=Navigate

One more thing people often add in the URL is the control of action options, For example Options=rmf

So Finally the Web HTML should be:

For dashboard csr, located at  /shared/All/_portal/csr and page 1 in the dashboard:

 analytics/saw.dll?PortalPages&PortalPath=/shared/All/_portal/csr&Page=page%201&Options=rmf&Action=Navigate

You can read more about the URLs here: http://obieeil.blogspot.com/2013/03/embeding-obiee-portalpages-vs.html

and here: http://obieeil.blogspot.com/2014/10/obiee-go-url-and-filter-parameters-old.html