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
Matrix Data Load Basics
I have a matrix data load question. I get the concept of how the matrix data load works. I haven't done too many of them, so I want to make sure I'm not missing the basics.
The file I have has the year on one of the first lines in column 9. The next row contains the headers with periods in 12 separate columns.
Is there an easy way to get the year from the first line (without a lot of code)? Or should I get year based on the POV? Then I am guessing a complex expression in the time columns to build the OS time key? I know I can do all of this in code, but I don't want to skip over any out of the box functionality or best practices.
Any good guides on some of the best approaches with the Matrix load?
Thanks,
Scott
You can set up a complex expression as shown below where you pull the year from the WF POV and then the months are your 12 columns:
Otherwise, at the bottom of the matrix load you can specificy a header row if you want to read the year from the first row:
5 Replies
- T_Kress
OneStream Employee
You can set up a complex expression as shown below where you pull the year from the WF POV and then the months are your 12 columns:
Otherwise, at the bottom of the matrix load you can specificy a header row if you want to read the year from the first row:
Thanks Teresa,
That is what I had in mind, but I didn't want to over complicate it if I didn't have to.
Scott
I have a load with similar data source setup. When I run the load through the Import step, it processed with no error, but nothing is returned after the import job completed. Can you recommend what to look for?
(And thank you Teresa for responding to my question on another post)
- T_Kress
Maybe try to look at the log file to see if there is any information in that:
