Forum Discussion

THENDRICKSON's avatar
THENDRICKSON
Contributor
10 months ago
Solved

Data is not getting imported into the correct quarter

I'm having trouble getting my data files to import into the correct quarter of the workflow. Whenever I load the data into the Q2 import of the workflow, it removes the Q1 data and adds the Q2 data t...
Import
Workflow
  • THENDRICKSON's avatar
    THENDRICKSON
    9 months ago

    I figured out what my issue was. Under Application Properties, I had the "Enforce Global POV" set to True and the Global POV was set at Q1 of 2024. Once I changed that setting to False, my data started loading into the correct quarters. 

    Thank you for your help! 

JoakimK's avatar
JoakimK
Contributor
9 months ago

You answered earlier in the thread that your datasource was setup to use "Current DataKey Time" for the time dimension? If this is the case, no time information in your file should be evaluated for the time information, instead it should use the Workflow time you are running the import in. This means that in your time transformation rule you might have to say: 2024Q2 = 2024Q2 (and same for all the other quarters as well.)

In your import step, all the values you see in the Time column should also say: "(Current)", if you are using the setting explained above.

Joakim

THENDRICKSON's avatar
THENDRICKSON
Contributor
9 months ago

Originally, I did have the DataSource set to use "Current DataKey Time" but I have since changed it. I changed it because I have two columns in the data that indicates what quarterly period the data should be loaded to. I have a column for Pay Period and then a separate column for the Year. If the Pay period is 21-27 and the Year is 2023, then it should be imported into Q1 of 2024. If the Pay period is 1-6 and the Year is 2024, then it should be imported into Q2 of 2024....and so on. 

In my Data Source, I added two additional Time Source Dimensions to have a total of 3. The first Time Source Dimension references the Pay Period Column. The second Time Source Dimension inputs an underscore and the third Time Source Dimensions references the Year column. 

Then I set the Transformation rules to map those values "PayPeriod_Year" to the correct quarterly period. 

 

 

  • JoakimK's avatar
    JoakimK
    Contributor
    9 months ago

    Then I would suggest you go to the import step of your workflow where you see the data, select any row, then right click and select "View Transformation Rules" then you can troubleshoot which transformation rule it has used for the time dimension and see if you can via that find out the issue. I believe it will be due to transformation rules not setup correctly.

    • THENDRICKSON's avatar
      THENDRICKSON
      Contributor
      9 months ago

      I figured out what my issue was. Under Application Properties, I had the "Enforce Global POV" set to True and the Global POV was set at Q1 of 2024. Once I changed that setting to False, my data started loading into the correct quarters. 

      Thank you for your help!