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.

Thanks for your help,
Belinda

Accepted answers

nathan_rudman

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)

All comments

naushad786

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

CommunityMember113484

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

naushad786

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

CommunityMember113484

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

naushad786

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

nathan_rudman

CommunityMember113484

Got it. Thanks for all your help!

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
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.…