Checked  the Children's category with additional characters. As per Ms. Sally there are still details in the pentaho that were incorrect. Run the product_dim update in Pentaho to update the master file, after the update I checked the SKU's with wrong details then tried generating the Consolidated Sales Report.