2.3.9.1 Import data into DAT03 Historic Volumes module

Options
gunjanrawat
gunjanrawat Member, ALL USERS Posts: 3 New Contributor
in Extensibility

Hi,

Can someone help me out with this issue of running 9 Import Data Hub:

gunjanrawat_0-1646563159909.png

gunjanrawat_1-1646563195851.png

 

 

Tagged:

Comments

  • Ankur.Sonthalia
    Ankur.Sonthalia Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Contributor

    Can you please share mapping screenshot as well as the target module view.

     

    Regards,

    Ankur Sonthalia

  • gunjanrawat
    gunjanrawat Member, ALL USERS Posts: 3 New Contributor
    Thank you! Just got it mapped.
  • emiram
    emiram Member, ALL USERS Posts: 3 New Contributor

    Could you explain how you troubleshoot it? I had the same error but data was imported. I'm not sure if I sure disregard error. 

  • schulze
    schulze Member, ALL USERS, Employee, Certified Model Builder Posts: 5 Contributor

    @TimWard70's advice is good.

     

    "Invalid line item identifier" would mean that Anaplan is having a hard time matching the line item "identifier", which means the column heading in this case, with the module definition.  I'd check that they match exactly.  Without seeing the import mapping itself as @Ankur.Sonthalia suggests, it's hard to be sure.

     

    PS.  Sometimes when you save the failure log, it is easier to read than it is on the screen in Anaplan.

  • emiram
    emiram Member, ALL USERS Posts: 3 New Contributor

    My mapping is as followed. I think the issue is that the "Filter" dimension in the source model is not in the target module. However, I think this is redundant, because if there is no inventory, it will show as zero. I might be wrong, but here is the module after the import. 

     

    emiram_0-1651727366737.png

    emiram_2-1651727402504.png

     

    emiram_3-1651727542566.png

     

     

  • schulze
    schulze Member, ALL USERS, Employee, Certified Model Builder Posts: 5 Contributor

    I just ran my own "9.2 Import Opening Stock".  I do not get this error.  One issue here: your export view from the data hub should use line item "Filter" as a filter, but you shouldn't show that line item in the view.  Note that my copy of Level 2 course is quite old, so it may have evolved since I created my models.

     

    PS.  The subset names ARE unusual here; as Tim Ward points out, a "?" normally means boolean; I'd argue we should not use it in the name of a subset, even if that's what the course asks of us.

  • emiram
    emiram Member, ALL USERS Posts: 3 New Contributor

    That resolved my  issue! I wasn't importing with the saved view. Thank you!

Categories