L2 Model Building Conclusion: Failed Import into Shipping Expenses OTH01 Module

HALY
HALY
in Academy and learning discussions

Hello Anaplan Community,

 

I've been stuck for too long trying to import the shipping costs from my Saved View into OTH01. I've tried numerous saved views but can't seem to resolve the errors. I've deleted all Saved Views and started over because I think I am confusing myself. Below are screenshots of where I am currently at. 

 

Current Saved View: I selected "Shipping Costs" for Select Levels to show vs. hiding the Code line item. Note: I tried moving line items to Page Selectors so I can attempt to load by Code as well as resolve errors I am getting regarding dates but it's not working. 

 

HALY_0-1666290541061.png

 

Below are screenshots of my mapping: 

HALY_1-1666290795311.png

HALY_2-1666290829371.png

HALY_4-1666290865422.png

Note: mapped manually to resolve spelling issues with Montreal and Mumbai. Can't figure out how to load it by Code...I think this might be why I am having issues as the instructions say to load by code. 

 

HALY_5-1666290951792.png

 

Error: 

HALY_6-1666291081739.png

 

 

Any help would be greatly appreciated. 

Thanks,

Heidi

 

 

Tagged:

Comments

  • JaredDolich
    JaredDolich

    @HALY 

    Heidi,

    Looks like your saved view from INV05 needs to be adjusted. Add a subsidiary view to INV05 for location code and add it to your saved view so it looks like this.

    JaredDolich_0-1666291574204.png

    JaredDolich_2-1666291695686.png

    JaredDolich_3-1666291724187.png

     

     

  • ShubhamCh
    ShubhamCh

    @HALY 

    If both objects, source view and target module have the same time dimensions i.e. months, use Match Names option in time mapping. 

    It'll fix the problem.

    Thanks!

    -Shubham

  • HALY
    HALY

    Thanks for your prompt reply Jared. I tried your proposed solution but I don't think it will help me achieve what I need. Please see the load with given the recommended SV. 

     

    SV:

    HALY_0-1666293121982.png

     

    Load:

    HALY_1-1666293227776.pngHALY_2-1666293248254.png

     

     

     

  • HALY
    HALY

    Hi ShubhamCh,

    I had already tried what you suggested with my original SV and it didn't work. I actually got another error (Invalid Line Item Identifier) Please see the screenshot errors. 

     

    I am really stumped on this one. Tried multiple Saved Views with multiple imports but am unable to resolve the errors. It should be straight forward but clearly I am missing something. 

     

    HALY_0-1666293380629.png

    HALY_1-1666293404817.png

    HALY_2-1666293426121.png

    HALY_3-1666293458168.png

    Error: 

    HALY_4-1666293482380.png

     

     

     

     

  • ShubhamCh
    ShubhamCh

    @HALY 

    Try mapping manually and ignore Code line item.

    If error still comes, click on details and share the screenshot. 

     

  • HALY
    HALY

    YAY that worked. Thank you so much! My brain was so fried staring at this for so long, I can't believe I missed that. 

  • ShubhamCh
    ShubhamCh

    Glad it worked.😊

    Next time if error comes and you want to post it on community. Post "Details" screenshot as well. It helps in understanding the error. 

    All the best for your L2 certification.

     

    - Shubham

  • HALY
    HALY

    Will do and thanks again!

Categories