Checked the error of Consolidated Sales Report by SKU, and the report is working in Pentaho Designer, I found that no stored SP_Consolidated_Sales_Report_by_SKU procs are available in 1.171. I used the backup query and also changed the parameters query