03-14-2022 08:56 PM - edited 03-14-2022 08:57 PM
How can I import data for multiple time period all in one go? I was told that its possible. But wondering what settings do I need to change in order to do that.
I tried using "Replace All Time" but the Time is set to "Current". I'm uploading a excel base file. Any guidance on this will be appreciated.
Solved! Go to Solution.
03-15-2022 11:07 AM
Here is the solution if anyone finds this posts and curious to know.
I managed to load multiple period data in same workflow. I needed to change my Transformation Rule (Time) and change the Data Source (Time) to Stored Key Value.
Once completed, refresh, and load the file in any empty period for that year. Lastly, Import > Validate > Load Cube
03-14-2022 09:39 PM
Look for matrix load, and that should let you load more than 1 data column
03-15-2022 11:05 AM
I believe you're referencing that within Data Sources?
The dimension I was working with was "Time" so I didn't see within the drop down menu.
03-15-2022 11:10 AM
How about this?
Did you define the data structure type?
03-15-2022 11:17 AM
This is what I'm looking at:
Maybe I'm using a delimited file type.
03-15-2022 11:19 AM
You only need Matrix if your data is present in multiple columns; else, it is not required. Also, Matrix comes when you define the connector as Matrix Data in the Data structure type.
03-16-2022 03:20 PM
Thanks!
03-15-2022 11:07 AM
Here is the solution if anyone finds this posts and curious to know.
I managed to load multiple period data in same workflow. I needed to change my Transformation Rule (Time) and change the Data Source (Time) to Stored Key Value.
Once completed, refresh, and load the file in any empty period for that year. Lastly, Import > Validate > Load Cube
03-15-2022 11:16 AM
Oh, so your file is not going by columns, you have that in rows itself. Keep in mind when you do that, the time period is still dictated by your workflow time. It'll load to other time periods, however, you'll have to go to the next time period to perform a validate->load cube from those ones.