Working with Main and Subtemplate in OTAP

Question

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.

User_0OG2P · Answer

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 if environment B use

Riyaz Ali-Oracle · Answer

Instead of referencing subtemplates via full URLs, upload them to the BI Publisher Catalog and reference them by Catalog path, like this: 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.