Importing between Models - Mapping

CommunityMember113484
CommunityMember113484
in Integrations and extensibility

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

 

Tagged:

Best Answer

  • nathan_rudman
    nathan_rudman
    Answer ✓
    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)

Answers

  • naushad786
    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
    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

    CommunityMember113484_0-1591112586950.png

    CommunityMember113484_1-1591112645300.png

     

     

     

     

  • naushad786
    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
    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
    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

  • CommunityMember113484
    CommunityMember113484
    Got it. Thanks for all your help!

Categories