Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
3 years ago

Importing data for multiple time periods

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. 

 

Data Sources
Import
  • Mustafa_A's avatar
    Mustafa_A
    3 years ago

    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

    • Mustafa_A's avatar
      Mustafa_A
      Contributor II
      3 years ago

      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. 

  • Mustafa_A's avatar
    Mustafa_A
    Contributor II
    3 years ago

    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

    • ckattookaran's avatar
      ckattookaran
      VIP
      3 years ago

      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.