Import Process

Hi All,

I have an import process in my model from module to module. The process is taking about 20 mins to get executed so are there any possible ways which can be used so that the import process time can be reduced.

Thanks in advance!

Accepted answers

AWhitworth

Are you updating the Subset as part of the import? If you are this can definitely take a long time to process depending on how large the list and model are. Other than that I would suggest trying to slim down your source export view as much as possible to anything that doesn't need to be included in the import.

All comments

ArunManickam

Hello ,

You need to provide more information so that the community can help. What are the dimensions in your source & target, how many line items are you importing, are the all numbers, how many cells you are updating?, What are the calculations running off from the target module, as you import data, these dependent calculations fire a recalculate in memory.

In your source module saved view,

1. Filter only the relevent records, hide the summary rows

2. Hide the line items which are not used in the process

3. Map all the rows and columns.

Thanks

Arun

Sampriti.Anand

Hi Arun,

Thanks for your response.

Both the source and the target modules have the same dimensions except the source has one subset of a List and the target has another subset of the same list. To elaborate on this the source has Work In progress list item whereas Target has Final list item. So, the values of one particular line item which are user input in the source are going to the target. There are other 4 line items which are both formula calculated in source as well as target.

AWhitworth

Sampriti.Anand

HI,

Thanks for your reply.

Can we use some data integration technique here to get the time reduced? Not sure on how import processes time can be reduced using such methods. I'll be really thankful if you could help me understand about this in little detail.

ben_speight

If you can get the target subset membership loaded into the source model such that you can define a filter on the view to only include those items, then you will reduce the quantity of data retrieved.

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…