Some BEx Requirements

[Former Member]

Hi Experts,

I have some couple of requirements and i need some suggestions from you.

1. Need to suppress # that is displayed for characteristics which doesn't have a value. I need to display it as blank.

2. Need to display a summary line after displaying the actual report.

For Eg: "Number of Invoices: xxxxx"

"Total invoice Value: xxxx.xxx"

Thanks,

Raja

[Former Member · Accepted solution]

To suppress the #, try following the below steps.

1) In excel menu Tools->macro

2) Enter the macro name SAPBEXonRefresh

3) select 'create', this will take you to visual basic editor

4) To display '#' as '', paste the code that is shown below.

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

Dim c As Range

For Each c In resultArea.Cells

If c.Value = "#" Then c.Value = ""

Next c

End Sub

5) Close the editor and click on refresh again.

Not clear on your second point, can't this requirement me met just by using the standard results rows?

[Former Member · Accepted solution]

Hi Stuart,

For the first issue can u explain me in detail because i tried with that but still it is not working. And for the second one i need the summary in a separate line apart from the result row.

Thanks,

Raja

[Former Member]

hi,

right now there is no possible setting to remove # from the query only thing we can do is excluding '#' at filter level.

in wad level we can remove # using java script

just write a java script in onload funtion and execute the report

[ArnaudJ]

Hi Saravan,

for your first issue, in the master data of characteristics you are dealing with, maintain the text for the first value (i.e. the blank one which comes as # 😞 try to put Space or - or _ (you need to maintain this text in all languages...)

This should replace # if you choose to display Text for your characteristics...

Hope this helps

[Former Member]

Hi,

You have to use WAD. Create three queries, one for your actual report, one for Number of invoice report and third for Total invoice value report. Then Show them on the single page. I am not sure how # can be remove.

Thanks.