I have followed the How To paper for the above, but I have a problem, my scenario is that my text file contains various characteristics called Size, eg 1030,1040,1050 each with a value eg 10,20,30. I have created the planning package so that characteristic is a range from 1030 to 1050. So, I was expecting the file to load each of these Sizes as it;s own row in the cube.However, it seems to be loading one row, which is the first size in the range eg 1030 and adding up all the values eg 60.
Looking at the instructions in the How To paper it looks like this should be possible, could you please advise me,
thanks and regards,
David
First lets clear up the question, I don't think you really mean you have multiple characterisitcs - I think what you mean is you multiple records with different values for the (single) characteristic 'Size', each record also has a key figure value, maybe 0amount or 0qty. So your records would look something like
(Char) ZSize, (KF) 0AMT
1030 10
1040 20
1050 30
The package definition should be fine as a range, I would suspect that the file itself has the wrong number of fieds defined or you do not have the size characteristic mapped correctly, have you tried loading with no restriction on size in your planning package?
Add a comment