Dynamic Instance Link In OTBI

Pulkit Kumar Jain

Description

In OTBI Analytics, How to find the Dynamic Instance lInk.?

Please find the below Example for Detail Case.

Use Case and Business Need

For example, I am using one invoice deep link in my 20 OTBI Analysis, (Deep link: when I click on invoice number in OTBI analytics it will redirect me to Manage Invoice Home Page with invoice details). Now suppose I need to move all 20 Analysis from one instance to another instance (XXX-TEST to XXX-DEV3). then again I need to edit all the deep links and change the instance URL.

Example :

Test Instance Deep link: https://XXX-test.fa.us2.oraclecloud.com/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId=Invoice_id

New Dev3 Instance Deep Link: https://XXX-Dev3.fa.us2.oraclecloud.com/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId=Invoice_id

More details

In BI Publisher we can fetch the Instance link using the below SQL.

SELECT external_virtual_host pod_url FROM ask_deployed_domains WHERE deployed_domain_name = 'FADomain'

But in OTBI we Don't have the option to find the Instance link

I have one solution developed by myself but it's very tricky to use.

https://jpulkit.wordpress.com/2021/07/26/oracle-fusion-how-to-add-dynamic-deep-link-in-otbi-analysis-dashboard/

 

Original Idea Number: f15849b82c

Chris Pfeifer

Hi Pulkit,

Your request is very similar to this one:

https://community.oracle.com/products/oracleanalytics/discussion/18326/enable-obiee-location-alias-with-action-navigate-to-a-web-page

Please upvote it. There is now an active enhancement bug being worked on by Oracle Development.

Chris