Skip to Content
avatar image
Former Member

SAP BW 7.4 - How to load blank Vaule to Key Figures

Hello community,

we have the customers requirement to load/write blank or #NV to a keyfigure.

As per SAP BW Standard this gets interpreted as 0 as no text or blank Values are allowed for key figures. Is there any workarround for such a szenario?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 07, 2017 at 08:47 AM

    no update means space, what I mean is:

    if you load customer A value 0 to customer and value you will have in your table/cube: A 0

    if you load just customer A to your cube, you will have A space

    so you will need to create a transformation to your cube without the value mapped. In this way you will have all your data (all customers in your cube, but where there is no value passed, there will be no number represented in the query)

    how to set this up in BW is depending on your dataflow at the moment

    Add comment
    10|10000 characters needed characters exceeded