time mapping while importing the exported module

Hi all,

I am trying to import data using the export file of the module which has weekly time scale. Every other dimension mapping is ok instead of the time mapping as the exported file has week as time dimension but the target has format of ddmmyyyy to ddmmyyyy.

I am attaching the screenshot of the exported file and the time mapping view.Please suggest how to solve this problem.

module_view_80799.png

Time_mapping_80799.png

Module_export_80799.png

Accepted answers

All comments

rob_marshall

@saurav4ss ,

On the import to Anaplan, make sure the file has a column for date, not a range of dates. This date could be the first day of the period, last day of the period, or the true actual date of the row and Anaplan will automatically understand and map it to the correct week.

Rob

einas.ibrahim

Hello @saurav4ss

The first thing I will ask you to think bout is why export data from the source in weeks while you know your target has months format?

However, this is not the issue you are having, I believe your mapping for the Time is not correct.

Could you please send a screenshot of your mapping tab so we can point out the issue?

JaredDolich

@saurav4ss

You just need to map to a date and use special masks.

saurav4ss

Hi @einas.ibrahim

PFA time mapping screenshot.

I have exported from the same module in which i have to upload so how can the source and target format will be different?

Thank you

Time_mapping_80942.png

Mapping_80942.png

einas.ibrahim

Hi @saurav4ss

Thank you for sending the screenshots.

First regarding your question "I have exported from the same module in which i have to upload so how can the source and target format will be different?"

I believe because you said in your first post "as the exported file has week as time dimension but the target has format of ddmmyyyy to ddmmyyyy." I assumed you are exporting from a source module with weeks time format and you will import in a target module with months time format.

Hope that was clearer.

You need to give Anaplan the correct Time/Date Format so it can match it to the source (with weeks time/date format) in the Time tab.

Review @JaredDolich response, it shows you how you can give Anaplan a Time/date format to match the week format in your source file.
It seems like Anaplan doesn't have a dedicated "week" format, so you can use the "?" to match the W/c part then Use DD-MMM-YY to match the rest of your format.

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…