Requirement to use different columns in different envirnments

Question

HI,

i have a requirement to use different columns in different envirnments.Anyone suggest me best way to handle it?

EX: in same table i have Column1,Column 2,Column 3.

In dev , i should display Column1, in test i need to display column 2, in prod, i need to display Column 3 In that report

i Can't change any report manually in both test and prod env's.

i Need to handle that with logic.

i Throught of creating variable to display correspond column based on the connection pool data source.

Any one have any other best approach to handle this?

Gianni Ceresa · Answer

The CASE statement is in the column formula or your analysis (or in the BMM if you want to maintain a single column there as well).

And in this CASE statement you use a variable to identify the environment. I think there is a default system variable defining the BI server hostname, so you can use that one, or you can set a repository variable in the RPD and you use the DB to identify the environment.

user12863665 · Answer

thanks Gianni for your response.

you are referring to create dynamic repository variable with case statement ? Anything else?

Gianni Ceresa · Answer

Hi,

Use a CASE WHEN based on the server name (your DEV, TEST, PROD have different hostnames).