No error generated for data loads outside of module time frame

When uploading data (via csv file) into a module, no errors or error logs are generated when data load falls outside of the module time frame?? E.g.: uploading data for Jan 2023, when module time frame extends only from Jan 2021 - Dec 2022.

3-21-23 edit: There must a warning/alert from Anaplan when upload file dates fall outside of module time range; otherwise, there is no way for user to know until a much large problem occurs downstream

Accepted answers

All comments

HimanshuRaj

Hi @zimingzh

Anaplan throws time error when there a proper time format is not adjusted in import definition. It'll ignore the time that is not in Anaplan scope.

Hope, this resolves your issue

zimingzh

@Himanshu1998 , this provides insight into Anaplan's workings, but it absolutely does NOT resolve the issue. Anaplan must have an alert or warning for this kind of mismatch between import data dates and the dates in the module. If no warning, and Anaplan simply “ignores” data, there is no way for users - especially new users - to know something went wrong until a much larger problem occurs downstream.

HimanshuRaj

Hi @zimingzh

Could you share your load import format, as Anaplan data ignore concept also depends on how you've oraganized time in excel.

If your time format is organized in column in excel, Anaplan will throw error as ("Failed").

If it's set across rows, then individual mapping takes place with source time and target time and Anaplan ignores out of range time

Thanks

zimingzh

Data is arranged in columns, with 1 column defining the date. No errors were generated.

HimanshuRaj

Hi @zimingzh

It seems that you're trying to upload “Period end date” column in a time formatted line item in a module.

You should upload this column in a text formatted line item and then use a different “Time period” formatted line item to pull value from text line item using finditem.

If any period falls outside your anaplan model calendar, then you can make a time range (FY22, 23). Anaplan will then automatically identify all the time in that finditem formula.

Cheers!!

Quick Links

Can you help?

Unanswered questions

403 error trying to access Support Portal
Hi - can't access support portal having already registered. Receive the following error message - is this an issue with Anaplan or our internal IT?
Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…