In Data Management, we will face below errors frequently. Check the errors, and find the solutions to check to trace the error and resolve the same. We may have different solutions, which I found is the below:
Data Management Issues:
BLANK:
Is log file mentioned as BLANK, check Import format File Type and Delimited. Check file and set as per file.
Amount=NN
Is log file mentioned as Amount=NN, NN - stands for Non-Numeric
check Import Format - File Type. Depends on file we can change this option form Numeric, All data type, Multi-column data etc.
If log file mentioned as Error: 3303, If so, member mentioined is not there in outline or might be mentioned in Mapping.
Unmapped Dimensions in the file
Check the Workbench tab for validation error where you can find which members mapping is not correct.
Error Invalid Period:
Check the period mapping in file and data mapping, import format and also if period name in file is different than application, we need to check period mapping.
If the period is not picking up from POV, we need to setup file with period and year, depends on period format we can select explicit option to pick the period mapping with same format of file from Period Mapping - Source Mapping.
No comments:
Post a Comment