Skip to Content
avatar image
Former Member

# in report when null in the cube

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 26, 2005 at 09:02 AM

    hi,

    take a look this thread

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2005 at 10:21 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded