Question:
Our query developers would like to be able to see the BW System ID (i.e. BWD for DEV system, BWT for Test system, BWP for Prod system) in the actual query output in BEx workbooks.
There does not appear to be a Text Element to insert in workbooks to identify the BW system from which the workbook data was generated.
Has anyone else in the forum been asked to provide this information in a workbook? If you were asked, and if you were able to do this, how were you able to display the BW system ID in a BEx workbook?
Answer:
you can add a nav attribute to the cube, which has the system in it.
this can be filled when loading master data using a customer exit.
a lot of infosources have an attribute "source system" eg wbs element.
this also may be used to identify what system you are in (eg if you extract data from DEV400 and your bw system is DEV you can add another attribute that created a substring of DEV440 into DEV)
hope this helps
Answer:
Thanks Trev.
I will pass this idea on to the persons who could potentially implement it.