cancel
Showing results for 
Search instead for 
Did you mean: 

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

cschwer
Explorer
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

kohesco
Active Contributor
0 Kudos

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