L2 Sprint 1 G1 Import from saved view in SYS05 Region

I have been trying to import the saved view in SYS05 Region and I keep getting errors and I don't know why.  It seems like there is a disconnect between what is in my G1 list and SYS05 Region file. 

 

Thank you for your help.

LStinsa_0-1614792974987.png

LStinsa_2-1614793051106.png

LStinsa_3-1614793077097.png

 

LStinsa_1-1614793009152.png

 

Best Answer

Answers

  • @LStinsa 

    Your super close to the answer. In your data hub you'll want to create a saved view that has one line item, CODE. Then use that saved view in your import to your spoke application. When you try to import the saved view there will be two columns to choose from. ITEM and CODE. The Region should use the ITEM and the CODE should use the CODE.

    So in your example all you need to change the mapping. Region should be column1 and Code should be column 2.

    See if that helps!

  • Thank you for your help.  I must have an issue with my saved view. When I created the saved view in the Data Hub I highlighted the code line item and clicked on show selection.  But it doesn't get rid of the region dimension.  

    LStinsa_0-1614794992011.png

     

  • @LStinsa 

     

    Re-pivot the view and save it.  Also, instead of Show, use Show All and then resave again, if needed.

  • @JaredDolich 

     

    Thank you for your help. I changed the mapping. I pivoted the saved view and highlighted code to show and then resaved it. But, I'm still getting the same error.  

     

    I don't understand why it won't import the data. Any suggestions?

     

    LStinsa_0-1614802745739.png

     

    LStinsa_1-1614802786376.png

     

    LStinsa_2-1614802820089.png

     

     

  • @JaredDolich 

     

    I think I might know what the issue is.  In SYS05 my codes are Americas, Europe, Asia Pacific.  I just deleted everything in my Region flat list.  I am going to remap the download.  Is this the correct way to import the flat file?

     

    LStinsa_0-1614807574273.png

     

  • @LStinsa 

    Check "Code Only" as a good practice. Wont' change anything here but in the future you should always strive to import on the code if available.

    Nice job! You got this.

  • Thank you! That fixed my issue. I appreciate your help.