Had working session with Mark to resolve the variance on the sales of Tommy Jeans and Tommy Children brand. Analyzed and checked the pentaho layers to determine in which data layer the variance originates. Found that data is correct for Tommy jeans up to the report layer. For the Tommy children, we need to trigger a data refresh as the data from layer 2 already doesn't match with the value from JDA. Generated and re-analyzed the report after the changes and fix on the store reference table joins were applied. Checked and advised the Tommy Merch that the issue is now resolved.