Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Production to Stage for BIP Reports
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!

Answers
-
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:
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!
0 -
Amazing - cannot even tell you how much time/stress you've just saved us. Such a great win!!
0 -
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.
0