Display spaces instead of 'NA' in BEX query report

[Former Member]

Hello,

I am running into an issue to display spaces for missing attribute values instead of 'NA' in BEX query report.

Is there any quick way of achieving this or is it only to be resolved by creating some backend default values with spaces as description ?

thanks,

Neeraj

[former_member188975]

Hi Neeraj,

may be you could do a simple macro taht searched for NA and blanks it out.

Hope this helps...

[Former Member]

Hi Bhanu,

Link please.

Also since we dont currently use workbooks, is there a way in BEX query for this too ?

thanks,

Neeraj

[former_member188975]

Hi Neeraj,

This link should help you as a reference:

Also, it does not matter is you do not use workbooks. Even if you run the quereis directly (in Bex) then you can use this code and it will format according to your needs.

Hope this helps...

[Former Member]

Hi Bhanu,

Thanks for the link.

I do not understand your point about using macro in BEX query. If my user executes the Bex Query how is this macro going to execute ? I thought I need to provide a workbook instead of BEX Query to my users if I need to force the execution of the macro always. Isn't it so or am I missing something ?

thanks,

Neeraj

[Former Member]

Hi,

if you want to replace '#' with '' in BW Webreporting,

you could use the table interface for it.

Use method 'DATA_CELL' and replace '#' if

C_CELL_CONTENT = '#'.

Kind Regards,

Alican