Hi, the values are being loaded to the stage, then validated and loaded to a cube. I've tried importing multiple periods, the way we have the stage set up is there's a separate stage for each month, and then in theory once I seed the actuals the values should populate the relevant month.
However as an example in the stage each month has only values relating to that particular month. But when it's loaded to the cube, some of the values are then appearing in 2 months, even though it's only against 1 month,
I've also tried just importing each month separately, but still I'm having the same problem.
If your DataSource is setup to take the period of the data from the file, and the file contains multiple periods, this will cause the issue you are seeing. If your DataSource is setup to use the "Current DataKey Time" it will ignore the file settings and attempt to load all the records in the file to the period you are importing into. Which setting you should use are dependant on many factors and should be considered closely. But as suggested already, log a ticket with our awesome support team and they should be able to advise you on the best approach, or find someone that can.
