We have multiple locations and oneworld setup in our account, and are using advanced item location configuration settings.
In suiteanalytics workbook, I'm told that there is normally a join from the item record to the 'locations' record, where one can find on hand/on order etc balances per location.
This join is not available to us given our setup. Is there any other way to access location on hand data through SuiteAnalytics?