Hi, I don't understand why when I go to load values via smart import into the cube they appear multiplied by 100, except for the 1 which remains the same.
I think I have set up the smart import correctly but when I go to copy and paste from the excel file it gives me these results:
For the sake of completeness I copied the excel values back to the smart import, just to show that the data is copied correctly, however as soon as I validate the smart import the cube fills up incorrectly.
What could be the problem?
If someone could help me I would be really grateful.
Thank you!