error Invalid date or timescale identifier

CaroleBPRI

Hi,

I have this message "Invalid date or timescale identifier" when I try to import a data file.

The date format in the file is : 30/06/2020 for example.

Unsuccessfully, I tried to fix whith a "Custom fixed-position pattern" DD/MM/YYYY.

Any idea? Thanks a lot :)

Accepted answers

andrewtye

Hi @CaroleBPRI

It might be to do with the timescales in data file vs the model - more "time" in the file vs the model. Or there's something in the file that Anaplan "thinks" is a date but really isn't. So a column that's a property field for instance but because columns are time it gets a bit confused.

BenjaminNiel

Hi @CaroleBPRI,

I see 3 reasons why you could have this error:

The time range of your source file/module and the target module are different. Ex: you try to load data from 2020 in a module that starts in 2021
The import mapping is not correct. Ex: you map the time dimension with the product one
The timescale in the import action is not correct. Ex: you map DD/MM with MM/DD. Or you map Days while your module is dimensioned with Months

Could you share your import mapping, the timescale you used, and the error file so that we can pin point the cause of this error?

Thanks and I hope this already helps!

All comments

andrewtye

Hi @CaroleBPRI

BenjaminNiel

Hi @CaroleBPRI,

I see 3 reasons why you could have this error:

The time range of your source file/module and the target module are different. Ex: you try to load data from 2020 in a module that starts in 2021
The import mapping is not correct. Ex: you map the time dimension with the product one
The timescale in the import action is not correct. Ex: you map DD/MM with MM/DD. Or you map Days while your module is dimensioned with Months

Could you share your import mapping, the timescale you used, and the error file so that we can pin point the cause of this error?

Thanks and I hope this already helps!

CaroleBPRI

Thanks Benjamin and Andrew; indeed, I try to load data from 2020 in a module that starts in 2021. I forgot that point in my test

andrewtye

@CaroleBPRI - been there, done that, got all the t-shirts! glad that it was something simple.

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!