Check the null Location column from the Sales and Inventory, the cause of null value reflects on the report is the location was no enrolled on the fused server. Insert the location code 777 on the LOCATION_DIM from layer 3
