Importing between Models - Mapping

Highlighted
New Contributor

Importing between Models - Mapping

Hi,

I currently have 2 models and I'm trying to pull staff costs from one over to the other.  The module I'm trying to import into is dimensioned by employees and years.  The module I'm trying to import from is dimensioned by employees, years, and versions.

When I connect to the Anaplan model and select the module, the mapping isn't right. 

e.g. Source --> target

Time --> column headers (fine)

Line items --> Line items (fine)

Issue: Employees --> Employees.  There isn't quite employees as a source (it's a dimension?) See attached issue I'm having.  

 

CommunityMember113484_0-1591108925934.png

Thanks for your help,
Belinda

 

7 REPLIES 7
Highlighted
Frequent Contributor

Re: Importing between Models - Mapping

Hi @CommunityMember113484 ,

 

you have to map "Employee code" line item  to Employee list because it is numbered list. for that you need create saved view in the source module by putting line item in column.

 

Hope it will work,

 

 

Thanks,

Naushad

Highlighted
New Contributor

Re: Importing between Models - Mapping

Thanks for your speedy reply but I'm still struggling a bit.  I've created the saved view in the source module and when I try to import, it doesn't seem to map automatically? 


Mapping looking like this now (see below).

Thanks

CommunityMember113484_0-1591112586950.png

CommunityMember113484_1-1591112645300.png

 

 

 

 

Highlighted
Frequent Contributor

Re: Importing between Models - Mapping

Hi @CommunityMember113484 ,

 

you are still mapping Employee Name (ID) instead of mapping of employee code . please map the Employee code  to the employee list.

 

 

Thanks,

Naushad

Highlighted
New Contributor

Re: Importing between Models - Mapping

Ahhh okay, yes, I see, thanks for pointing this out.
So my import worked (kind of). In my source module, if my salary was 100k, it's showing double in the imported module 200k? This is for all years, all employees. Both module timescales are in years too. Not sure why this is causing the salary to change?
Thanks again,
Belinda
Highlighted
Frequent Contributor

Re: Importing between Models - Mapping

Hi @CommunityMember113484 ,

 

It might be because of version if you are using two versions in the source module. that is going to be double value while importing into the target module.for each employee.

 

As you are using version dimension in the source module and not in the target module.

 

Thanks,

Naushad

Highlighted
Community Boss

Re: Importing between Models - Mapping

in your source view you need to display only one version (simply right click on the version and "Show").
The practice when you are doing an import source is to make it as small as possible (remove sub totals, additional dimensions etc)

Nathan Rudman, Anaplan Model Builder
Highlighted
New Contributor

Re: Importing between Models - Mapping

Got it. Thanks for all your help!