Hi everyone, I have been trying to build a solution, but i can't seem to get the data reader configured properly. Everytime i run the data reader, the file name just disappears and the contents do not populate, else, the valid rec. shows 0 and the Disc. Rec. shows the entity numbers. What could be the issue? i am attaching all the reference images below. Regards.
Hello,
Concerning the file name, I believe that it's a common behavior because I have the same thing on my side… but this not causing the issu you faced for my point of view.
To see why the data is not populated in the datareaders cube, you can enable the log option on the datareader here:
and see in the log file why data is rejected
Maybe the code for the Month is not correct and maybe the code is YYYYMM (202601 for Jan.26) or the code fot country is not correct.
Thank you
I confirm your observation:
the issue is the Month. It prevents the datareader to work properly.
Board requires to load the code of the Month entity, so the source Excel file must be changed so that the Month column shows 202501 instead of Jan. 25.
