Production to Stage for BIP Reports

Prudence K

Summary

Easiest way to copy BIP reports from Production to Stage environments

Content

Hi all - we have two ways that we use BIP reports on our dashboards:

1) Embedded Content - input the website address of the report into the dashboard

2) Drag from Catalog to Dashboard Section

When our team refreshes our Staging environments from our Production environments, #2 moves without any issue and our customers can use the report without a problem.  However, #1 copies the Production address and when our users access the report from Stage, it points to the Production report and not the Stage report.  We have tried to use #2 for some of the reports following the #1 process, however we have found that we need to create separate prompts that the report would look at (vs using the ones automatically in the report).  Hoping the attached picture gives an idea of what I am referring to.

I have many reports that would need to be updated if we keep using #1, however I have probably the same amount of reports that would need prompts built if we switch to #2.  Ultimately, we just do not want to have to go into every report and change our report links to point to the stage environments.

Any recommendations of how we can proceed with this?  Thank you in advance!

Christopher Maurio

Hi Prudence,

You'll want to use relative links.

Below is a generic article on the concept:

https://www.coffeecup.com/help/articles/absolute-vs-relative-pathslinks/

Example Before:

https://yourpod-test.bi.us2.oraclecloud.com/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=/Cloud Reporting/Core HR/Element Entries.xdo&path=/shared/Cloud Reporting/Core HR/Element Entries.xdo

After:

/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCloud%20Reporting%2FCore%20HR%2FElement%20Entries.xdo&path=%2Fshared%2FCloud%20Reporting%2FCore%20HR%2FElement%20Entries.xdo

In regards to Oracle documentation, I couldn't find anything on MOS about it other than note doc: 1660704.1 which is not specific to HCM.

Hope this helps!

Prudence K

Amazing - cannot even tell you how much time/stress you've just saved us.  Such a great win!!

Vicki Parker

Do you just change the action link by removing the environment at the beginning? Would I change our OTBI reports to just be "/analytics/…." rather than pointing to the environment it's in?

Please let me know how this resolved. We are currently having to touch over 500 report links in each of 5 test environments after each refresh. Surely there must be a better solution.

Thank you so much for any advice or help you may have.