Import Fail - Invalid Date or Time Scale Error

Dev_08 · 2023-08-31T12:24:21+00:00

There was an error rendering this rich post.

Hi Team,

In Level 3, I have imported activity 4.6.1 Historic Revenue by Product. I'm facing issue with the Time Dimension even though I used the Time Range concept

Any ideas on why this is 'Failing'? Is this because of the Model Time scale as a "Week" SS

Data 05 Module.JPG

Import Error_Time Mapping Issue.JPG

Thanks

Devika

Accepted answers

TristanS

@Dev_08 Column B in your input file is in Quarters so I would recommend you update the Time Scale in DAT05 to Quarters as well. This should hopefully address your problem

KirillKuznetsov

@TristanS is right. You always have to make sure that the granularity in the source file and in your target module match. If you need to get the data on a weekly level you can use MONTHVALUE() formula in a separate line item.

All comments

KirillKuznetsov

Hi @Dev_08

Could you share the file screenshot?

Dev_08

Hi https://community.anaplan.com/profile/KirillKuznetsov ,

Requested snap attached

Actual sales file_Fy19.JPG

Thanks

Devika

TristanS

@Dev_08 Column B in your input file is in Quarters so I would recommend you update the Time Scale in DAT05 to Quarters as well. This should hopefully address your problem

KirillKuznetsov

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…