Hi Evan,
Thanks for the detailed info.
I was able to create the Saved view exactly as you showed.
However, when I try to import into FP&A, SKU Code and Location Code columns show up as blank.
Appreciate any inputs.
Thanks,
Hiren
HI @hpatel
I believe this is because you are looking at "All Regions" in the L3 Location list in your import view, which shouldn't cause a problem with your import. When you run the import it should still import your demand values.
However, if you want to make your import more efficient, I would remove all summary levels from your saved view. In your saved view, I would pivot your L3 locations down to your rows, and in "Select Levels to Show" I would uncheck all levels except the L3 Location Level. Then Pivot it back up to be a page selector and resave the view. You should then hopefully see the location and SKU codes in your import view.