Skip to Content

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

Nov 06, 2017 at 03:55 PM


avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters 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

10 |10000 characters needed characters left characters exceeded