How can I add the name/URL of the environment to my OTBI reports in a Fusion SaaS solution?

Question

There is a requirement, that an OTBI-report run from 'Reports and Analytics' in Fusion always will show information about the environment, in which it was run.

Basically:

When I run the report in PROD then the report should have the text 'PROD' (or an equivalent value) in the upper left corner.

When I run the report in TEST then the report should have the text 'TEST' (or an equivalent value) in the upper left corner.

Obviously I would not want to add this information as constant values, since I would have to overwrite the value in all my reports, when I clone my PROD environment to TEST.

An approach for financial reports of course could be to have a column like 'Ledger description' in all my reports, and then I could update the ledger description from 'XXX' to 'XXX-Test' each time after cloning to TEST.

But I wonder if there is a smarter and more general way to achieve the same without manual intervention.

Sandeep19rm · Accepted Answer

hello Reinhard

Are your referring OTBI or BIP report ?

For BIP you can refer below table to confirm if its PROD or NON PROD -

SELECT Count(1)

FROM fusion.ask_deployed_domains

WHERE

deployed_domain_name='FADomain'

and EXTERNAL_VIRTUAL_HOST = <PROD POD>

Regards

Sandeep