Not sure the way i handled this scenario right or wrong, would like to have your thoughts on this ..
Since the Supply chain model, dem03 final demand forecast dimensioned by Accounts, Product SKU's. However, my assumption is FP&A, No way related to accounts(we didn't added any lists for account during the FP&A model built). I ignored the accounts and included the location dimension in the model. Attached is the view
The Target model is dimensioned with P3 SKU, location. I have modeled the same in the source module. added location and Sum by location…refer the screen.
Loaded the same on FP&A DAT02 SKU Volumes. Attached is the reference
Thoughts on this..Thank you