You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real- time and that Average Quantity On Hand measure is updated hourly
You need to configure the Employees roles so that users can query only sales orders for their respective sales territory