Data load for specific time period pulling data from other time periods
Hi all,
I'm having an issue whereby I'm importing profit and loss actual's data via a csv file into one of the data upload workflow steps we have set up.
However some of the data is being loaded into months it shouldn't be, even though on the in the csv file the data is pointing to the correct time period.
So for example in the upload file, data is put against time periods such as 2023M1, 2023M2 etc. Having imported the data, validated it and loaded it to the reporting cube we have, some of the data is being loaded into 2023M1 and also 2023M2, when on the upload file it's only on there once against 2023M1.
I've checked the transformation rules and everything is set up correctly in terms of translating the import file, so I was wondering if anyone has come across this type of issue before or if anyone has any advice as to where I could look next?
I'm pretty new to OneStream so any help would be much appreciated.
Thanks,
Ged