I'm trying to load a file that has data in multiple columns like below.
I have created the data source with a Data Type as Matrix DataKey and created source Time Dimensions for 12 months as stated in the screenshot. But when I try to load the data, I get the below error every time. I have already created transformation rules for Scenario and time as below and not sure what else I'm missing here. Can someone please help with this one?
Error Message:
Thanks...!!!
That doesn't look like the configuration is correct. Should look something like this:
datasource properties:
As many Time sources as you have periods:
Note the last property, it's important - it will tell Onestream where to look for the actual period name. That name will have to be mapped in Transformation rules.
From OnePlace, have a look at the log, it will tell you why rows are getting dropped. You'll have to open the generated xfl file in Notepad.
Hi JackLacava,
I see the below error in the log. I'm not sure if I've to create any additional mapping rules for time apart from the one I stated in my original post. Please let me know.
That doesn't look like the configuration is correct. Should look something like this:
datasource properties:
As many Time sources as you have periods:
Note the last property, it's important - it will tell Onestream where to look for the actual period name. That name will have to be mapped in Transformation rules.
