Display BW system name on Webi Report using BEx query

[Former Member]

Dear Experts,

I have requirements to display BW system name on my webi report as a standard alone cell, we have using BEx query as sematic layer. We have object to display source system where BW perople pull data but I want BW system name.

Please help me to how we will get BW system name?

Platform: BI4.1

Regards

Karuppiah N

[Former Member · Accepted solution]

a helpful blog:

http://scn.sap.com/docs/DOC-48514

[Former Member · Accepted solution]

Hi All,

I got it using CurrentUser() function, this function will give BW system name, Client and Username. So I have used substr to get the BW system name.

Thanks for your reply.

Regards

KaruppiahN

[IngoH · Accepted solution]

Hello Karuppiah,

that only works under the assumption that the system from the user matches the connection.

This does not work in case you BI Server handles several connections with a single authentication.

for example User A is able to create reports against BW1, BW2, BW3.

regards

Ingo Hilgefort, SAP

[Former Member · Accepted solution]

Hi Ingo,

Yes you are correct, but my requirements are based on single BW system.

Thanks

Regards

Karuppiah N

[gleo_SRAM]

Hi Karuppiah,

If you have only the one BW system, can you just add it as Text in a cell.

The other alternative is to write a BEx query on one of the statistical cubes that gives you the system name as a characteristic.  The query should have no prompts and be written to always return data. You can add this query to your Webi document and display that characteristic then.

The query will have no relationship at all with the other query in your webi document.

With regards

Gill