Check the reason why the total quantity was bloated. First, i check the PRPT, i think the cause is from the grouping then second i try to check the stored proc and check every table that joined in the query and i so that the table PER BRAND LOCATION DIM need to add brand_code on the joining field