Checking the cause of no data in the generated Per Location Sales Report, as per checking the casue is from the null value of Season Code. I modified the stored proc that insert to PRODUCT_DIM then add the condition if season code is null then reflect 0