Flexibility when importing .csv file with Time Dimension

Hi!

Does Anaplan have an option to have a flexibility to import .csv files with regards to time?
For example, one user exports a .csv file with Y-M time format (23-Jan, etc.) while other user exports with M-Y format (Jan-23). These files exported from Anaplan will eventually be imported back.

I know these differences are due to settings in their respective Region/Language.

What I would like to do is to import these type of files (whether Y-M or M-Y, regardless of region) to the Anaplan module.

Thanks!

Accepted answers

All comments

HimanshuRaj

Hi @aramaybaral

If they are loaded in different modules and have different actions have been set up for them, then you can set “M-Y” or “Y-M” logic accordingly for each action.

In case, the different month format is required for single import action, then I don't believe there is any feature yet available to accomodate that in Anaplan. Anaplan only takes one time format.

I'd recommend users adjust their settings accordingly in their system so that anaplan export generates only one type of format.

Cheers!

AjayM

Hi @aramaybaral ,

As @Himanshu1998 mentioned, there is no direct way in Anaplan to configure same action to accept two different time formats. However, we can design a workaround to alter the import functionality, IF modifying system settings is difficult.

In my below approach, instead of directly loading the data into target module, I have a number list dimensioned staging module into which I import time values into a text formatted lineitem (and not directly mapped to model's time dimension). I find actual time using this text lineitem, and then create an import action from this staging module to target module. You should club both the import actions into a process.

For demoing, I took same file but with different time formats, though we know these come in different files in your case.

Please note that you would want to flush the previous imported raw records before importing fresh set of data to keep it clean. Hope this helps.

Cheers!

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385