L2 Sprint 1 G1 Import from saved view in SYS05 Region

LStinsa
Frequent Contributor

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: L2 Sprint 1 G1 Import from saved view in SYS05 Region

@LStinsa 

Ok! We're almost there.

Just change your Data Hub list. YOu have your ITEM and CODE reversed.

BuildRegion001.png


Jared Dolich

View solution in original post

8 REPLIES 8
JaredDolich
Moderator

Re: L2 Sprint 1 G1 Import from saved view in SYS05 Region

@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!


Jared Dolich
LStinsa
Frequent Contributor

Re: L2 Sprint 1 G1 Import from saved view in SYS05 Region

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

 

rob_marshall
Moderator

Re: L2 Sprint 1 G1 Import from saved view in SYS05 Region

@LStinsa 

 

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

LStinsa
Frequent Contributor

Re: L2 Sprint 1 G1 Import from saved view in SYS05 Region

@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
Moderator

Re: L2 Sprint 1 G1 Import from saved view in SYS05 Region

@LStinsa 

Ok! We're almost there.

Just change your Data Hub list. YOu have your ITEM and CODE reversed.

BuildRegion001.png


Jared Dolich

View solution in original post

LStinsa
Frequent Contributor

Re: L2 Sprint 1 G1 Import from saved view in SYS05 Region

@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

 

JaredDolich
Moderator

Re: L2 Sprint 1 G1 Import from saved view in SYS05 Region

@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.


Jared Dolich
LStinsa
Frequent Contributor

Re: L2 Sprint 1 G1 Import from saved view in SYS05 Region

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