error in loading data to infocube from dso - request goes red
i need help with this issue experts:
i installed a couple of infocubes from the ones in BI Content and loaded the data to my dso's succesfully through a DTP
now i have the same issue with both my infocubes when i load the data from the dso to the cube and the request goes red:
one of the fields that are coming from the dso is 0UNIT and apparently it contains no data, i checked my datasources in rsa3 in my source system and the specific column is empty there as well,
however once the dso is populated and i move the data to the cube i get the error: key figure <> 0 not allowed for UNIT ''
and the long text is 'the unit/currency 'source unit 0unit' with the value 'space' is aasigned to the key figure '0hc_actqty' with the value 4.000'
any suggestions on what the best way to handle this is?
preferably without loading the data all over again but handle it between dso and infocube