Import from a module with multiple list members

xin
Contributor

Import from a module with multiple list members

Hi,

 

I am trying to import from a source module applying to a scenario list, to a target module that is independent of this list. Can I select which scenario to import from? I know that if it is the opposite, i.e. importing from a module without the scenario list to a module with scenario list, it can be set as "ask which scenario to import to each time". But can it be set to ask which scenario (list member) to import from? Currently I can not set up anything about this list as it is not applied in the target module. It simply add up the figures from all the scenarios in the source module

 

Thanks,

Xin

1 ACCEPTED SOLUTION

Accepted Solutions
TonyViGrand
Occasional Contributor

Re: Import from a module with multiple list members

@xin 

 

Yes , It can be done. I have created a sample below to show how it can be done.

 

First step, Create a line item "Scenario to be Imported" with no dimensions and the line item format should be the scenario list.

Second, Create another line item "Filter Scenario" with scenario list as dimension and boolean as format and put formula as Item(Scenario)=Scenario to be Imported.

TonyViGrand_5-1616183209671.png

 

Third step, In the source view for the import, Select the Filter and in the scenario tab, use the "Filter Scenario" line item from the filter module for filtering only the scenario you wanted and save the view. 

 

TonyViGrand_1-1616182354781.png

Now in "Scenario to be Imported" line item of the Filter Module, Select the Scenario which you wanted to import and using the view you created in third step as source ,you will be able to import to the target module only the data from the scenario you wanted from the source module(In this case its Scenario 2)

TonyViGrand_3-1616182754032.png

TonyViGrand_4-1616183083370.png

 

 

Tony Grand

 

 

 

 

View solution in original post

5 REPLIES 5
Misbah
Moderator

Re: Import from a module with multiple list members

@xin 

 

Yes you can do that. Check out this article and scroll down to Case II

 

Case II: When Source Module has N+n dimensions and target has N dimensions

 

Importing With Varied Dimensions - Anaplan Community

 

Misbah

xin
Contributor

Re: Import from a module with multiple list members

Hi Misbah,
Thanks for prompt reply. As I understand, in the case II, it is the sum of all region that is imported to the target module, instead of a specific region. I would like to for example, select Asia to import to the target line item. Although in my case, figures are mostly the same across scenarios.
Thanks,
Xin
Misbah
Moderator

Re: Import from a module with multiple list members

@xin  I don’t think you can control it in Import action. You will have to filter it and create a saved view for that scenario just the way @TonyViGrand explained.

 

Misbah

TonyViGrand
Occasional Contributor

Re: Import from a module with multiple list members

@xin 

 

Yes , It can be done. I have created a sample below to show how it can be done.

 

First step, Create a line item "Scenario to be Imported" with no dimensions and the line item format should be the scenario list.

Second, Create another line item "Filter Scenario" with scenario list as dimension and boolean as format and put formula as Item(Scenario)=Scenario to be Imported.

TonyViGrand_5-1616183209671.png

 

Third step, In the source view for the import, Select the Filter and in the scenario tab, use the "Filter Scenario" line item from the filter module for filtering only the scenario you wanted and save the view. 

 

TonyViGrand_1-1616182354781.png

Now in "Scenario to be Imported" line item of the Filter Module, Select the Scenario which you wanted to import and using the view you created in third step as source ,you will be able to import to the target module only the data from the scenario you wanted from the source module(In this case its Scenario 2)

TonyViGrand_3-1616182754032.png

TonyViGrand_4-1616183083370.png

 

 

Tony Grand

 

 

 

 

View solution in original post

xin
Contributor

Re: Import from a module with multiple list members

Thank you! It is very helpful!