Display user name and date in Bex Reports

[Former Member]

I would like to know if there is a way in BEx to show the name of the person who executed the query and at what time.

My users asked me this because if they want to take a report to the CIO , they would like to see this feature.

Thanks

[Former Member]

Hi Christina,

If you want to automate this in BEx Analyzer, here is the code:

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

Run "SAPBEX.XLA!SAPBEXshowTextElements", "C", resultArea

End Sub

With this code in a workbook, any new query that is embedded with automatically display the general text elements.

Other possible parameters for this function are:

Run "SAPBEX.XLA!SAPBEXshowTextElements", "C"

'C gives general text elements

Run "SAPBEX.XLA!SAPBEXshowTextElements", "F"

'F gives filter text elements

Run "SAPBEX.XLA!SAPBEXshowTextElements", "V"

'V gives variable text elements

Run "SAPBEX.XLA!SAPBEXshowTextElements", "*"

'blank or * gives all text elements

- Pete

[Former Member]

Christina,

In BEx analyzer>layout>display text elements-->general

Also you could do it in web using the webitem text elements

http://help.sap.com/saphelp_nw04/helpdata/en/9f/4e9d39d44cd45ee10000000a11402f/frameset.htm

-Doodle

[former_member188325]

Hi,

After executing the Query, click on 'Layout' icon in BEx tool bar( ithink it is 4th from right).

Layout->display text elements->general.

which gives you current user,Last refreshed(execution time)...etc

Pl don't foget to assign points if it helps

Hope this helps

Message was edited by: Murali

Message was edited by: Murali

[Former Member]

Just to add to what Murali said - once you get to the display text elements, you can also display filter and variable values so you can see what options were used to generate the results as well as who and when.