Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Load Data from CSV File

I just loaded a CSV file and It said it was successful but I don't see all the data at the appropriate intersections. 

I set it up to overwrite records with matching key and to aggregated the data before load.

When reviewing the log file below I noticed that the aggregate count was 19503,  when I pivot the data the aggregate count comes to 47777 when I exclude data that was already in the cube i come up with aggregate records of 46384.    I am hoping that someone can help me understand why it says all records were accepted and the package ran successfully yet the data is not where I would expect it.


Thank you in advance for you patience.

/CPMB/MODIFY completed in 0 seconds

/CPMB/CONVERT completed in 5 seconds

/CPMB/LOAD completed in 20 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

FILE = \ROOT\WEBFOLDERS\SFG_EXP\EXPENSE\DATAMANAGER\DATAFILES\EXPENSE00006.csv

TRANSFORMATION = \ROOT\WEBFOLDERS\SFG_EXP\EXPENSE\DATAMANAGER\TRANSFORMATIONFILES\EXPENSE_TRX LOAD3.xls

TARGETMODE = Yes

PREPROCESSMODE = No

RUNLOGIC = Yes

CHECKLCK = Yes

[Message]

--------------------------------------------------------------

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 48494

Skip count: 0

Accept count: 48494

Task name LOAD:

Aggregate count: 19503

Submit count: 28991

Reject count: 0

Former Member
Not what you were looking for? View more on this topic or Ask a question