Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Working with Main and Subtemplate in OTAP

Within our organization we use for 2 reports a main template with subtemplates.
We develop in the acceptance environment and then the report goes to the production environment.
At the moment both environments have the same URL for the location of the subtemplates.
In November the database will go to the cloud and also the location of the BIP Server. Unfortunately we will then get a separate URL per environment, which means that a developed report in the acceptance environment will not work in production, because the import and call code refers to an incorrect location.
Can somebody advise me how to make the import code and call code flexible so the report works in both environments.
Answers
-
Instead of referencing subtemplates via full URLs, upload them to the BI Publisher Catalog and reference them by Catalog path, like this:
<?import:xdoxsl:///Shared/Custom/SubTemplates/YourSubTemplate.rtf?>
Try this:-->Upload the subtemplate to a shared folder in both environments (e.g., /Shared/Custom/SubTemplates/).
-->In your main RTF template, use:
xml-->Ensure the template name inside the subtemplate matches the one you're calling.
<?import:xdoxsl:///Shared/Custom/SubTemplates/YourSubTemplate.rtf?><?call-template:YourTemplateName?>
0 -
Thanks for the replay.
I have been investigating this option, and we concluded that working with a shared folder accessible for both environments is not an option. Because environment A is to develop changes and environment B is production. The change that something goes wrong is too big.
We are wondering if there is a code that can be used to determine which importline to use
if environment A use <?import:xdoxsl:///environment_A/SubTemplate/letter.xsb?>
if environment B use <?import:xdoxsl:///environment_B/SubTemplate/letter.xsb?>
<?call-template:letter?>
0