Failed loading from PSA into Cube
I tried to load data from flat file into a cube. I defined the processing as PSA only in Infopackage, the loading was OK, but when I loaded data from PSA to cube, it failed. I checked the PSA, the Status indicator was red, this record is the first record in flat file. The detail error message as follow:
Message: Value "01.02.20" of characteristic 0Date is not a number with spaces
One record in flat file as this:
the corresponded infoobjects:
Material;material group;customer;calend day;fiscal year;fiscal year variant;quantity
I was confused much on the error message, I checked flat file, infosource, transfer and update rules,cube and so on. Could you please help me to solve the problem? thanks advaned!
Beat Stoller replied
0DATE has to be available in internal date fomat to book into the infocube. you have the following options:
-Change the 0DATE-column in your flatfile to the format YYYYMMDD.
-In the transfer structure, choose a conversion routine to convert the external date format to internal date format.