Load data from One model/module to another via SQL or in any other automatical way

Malinopa
New Contributor

Load data from One model/module to another via SQL or in any other automatical way

Dear all

Having various Models and Modules, is there any automatical way to copy at lowest level of Country (~100 country codes) and Product lines (~300 items) data from one module to another module? Imagine that we are doing P&L Forecast for the future Quarters, and we want our Q4 to be equal to our Budget, is there any way using e.g. SQL to do simple copy paste of budget into Forecast for Q4 for all countries or only selected, or in anaplan everyone needs to upload data manually either via excel add in, or via importing CSV manually?

3 REPLIES 3
ArunManickam
Master Anaplanner/Community Boss

Re: Load data from One model/module to another via SQL or in any other automatical way

Hello @Malinopa ,

 

There should not be any redundant data uploads.

 

You can do model to model import, it is like copying data from one model to another model.

 

Thanks

Arun

Malinopa
New Contributor

Re: Load data from One model/module to another via SQL or in any other automatical way

Thanks, are there any instructions how to set it up, again we aim on avoiding manual download upload of data, but on setting up action button that will copy paste using selective filters

 

Thanks

ArunManickam
Master Anaplanner/Community Boss

Re: Load data from One model/module to another via SQL or in any other automatical way

You can use this link

 

Thanks

Arun