# in report when null in the cube

[Former Member]

Hi All

I am looking for a way to replace the "#" with "-" in the query when there is null in the cube.

Thanks

Dror Golani

[Former Member]

I’m not sure if there is a direct way to do this in the infoCube level.

Alternatively, you can do this in the query level using table API to replace “#” with “–“ or any other character. This would work only if you are using your query in a web template.

Here are the steps involved:

1. Create ABAP class that extends class CL_RSR_WWW_MODIFY_TABLE (TC SE24)

2. Redefine method CHARACTERISTIC_CELL and put in it below ABAP code:

  IF I_CHAVL EQ '#'.
*uncomment below line if you want to show blank instead of #
*   clear c_cell_content.	
    replace '#' with '-' into c_cell_content.
    replace '#</a>' with '-</a>' into c_cell_content.
  ENDIF.

3. Activate the method and the class.

4. Link your template with the class that you have created. This can be done by opening the template and entering the class name in the table interface class field under table properties.

[edwin_harpino]

hi,

take a look this thread