add environment instance to report

Question

Hello all,

Have a client that would like to display the environment instance and/or server name on each report created in BI Answers. How do I add this information. For example , they would like to see if report was generated from test instance or dev instance, etc.

[Deleted User] · Answer

@deahayes I think you can close this thread. You won't get any other answer.

[Deleted User] · Answer

Creating a static RPD variable which contains the host name or environment literally takes 5 seconds to do. Why insist on non-standard things?

deahayes · Answer

No, I don't believe in unicorns. After reading further I now know more about the function. I am looking for a simple sql statement that can pull server name  into a variable at the report level. Thanks.