Checked the issue reported by Nerie Sanvictores that there were sales not included in the Pentaho sales report. As per checking the data was only in Layer 1, and Layer 2 and was not processed to Layer 3. Run sales refresh for the dates with variance. This is now ok.