Skip to Content
0
Former Member
Jun 06, 2011 at 10:52 AM

error in loading data to infocube from dso - request goes red

92 Views

hi everyone

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

thanks