Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Requirement to use different columns in different envirnments

Received Response
1
Views
3
Comments
user12863665
user12863665 Rank 6 - Analytics Lead
edited Aug 13, 2024 7:00PM in Oracle Analytics Cloud and Server

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?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

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

  • user12863665
    user12863665 Rank 6 - Analytics Lead

    thanks Gianni for your response.

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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.