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
Ok! We're almost there.
Just change your Data Hub list. YOu have your ITEM and CODE reversed.
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.
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?
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?
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.
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!
