SAPGetSourceInfo displays different information in Analysis for Office reports

[stefan_rottwinkel]

I provided some AO 2.5. reports to our chinese Sales Org. Some of the local key users want to use the Information which user is logged on in a VBA procedure. I recommended them to use the function SAPGetSourceInfo (LogonUser), which works fine when I run the report.

When a colleague opens the report, the function shows different Information. The system and clients are displayed as well, making it difficult to use the content of cell C2 in VBA.

Is there a way to influence the output of the function, to make sure that only the user-id is displayed or is there a smarter way to use the user ID in a VBA procedure?

Thank you in advance

[gcybill]

Enhance AO function using advanced Excel formula

=RIGHT( SAPGetSourceInfo("DS_1";"LogonUser") ,LEN( SAPGetSourceInfo("DS_1";"LogonUser") )-FIND("/", SAPGetSourceInfo("DS_1";"LogonUser") ))

The idea is to remove domain information prior to the "/" delimiter.

Reference: https://www.extendoffice.com/documents/excel/1783-excel-remove-text-before-character.html

[RafkeMagic]

Hi there,

we're on 2.7 SP02 and don't have this issue, but we would actually like to get the client somewhere.

Normally the systemid should only appear for SAPGetSourceInfo("DS_1"; "System"). Maybe you can try this with a higher version of AFO? In our workbooks we actually display System & User next to each other via:

"System: "&SAPGetSourceInfo("DS_1";"System")&" - User: "&SAPGetSourceInfo("DS_1";"LogonUser")

Since you're endusers see the concatenation now, that may be an option to try (and see whether the system is smart enough to see the system is already shown separately).

Kind regards,

Raf