Use a CASE WHEN based on the server name (your DEV, TEST, PROD have different hostnames).
thanks Gianni for your response.
you are referring to create dynamic repository variable with case statement ? Anything else?
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.