The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
How to Load a Data File having multiple columns of data
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 st...
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.
JackLacava
OneStream Employee
OneStream EmployeeFrom 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.
- JackLacava
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.
Hi JackLacava,
I did set up these values in all Time Dimensions. I then had to play a little bit with the transformation rules and it seems it's importing now but the problem is that it's not bringing the attribute dimensions like Project, Client, and Spare. Can you help if I'm missing something here?
1. CUbe Integration settings you have to enable the Attributes.
2. Add the Attributes if it is not listed in the Data Sources if exists then map the attribute column.
Also, how can I map the Amount column here?
