Assisted Ms. Dyan Duazo on the generation issue of Consolidated Sales Report on Pentaho Fused. Upon checking there is an option of "Extended Class" on the consolidated sales report when you generate a specific sub- brand. I advised Mark regarding this and as per him there is a possible item created with 0 extended class/ After that he advised me to try generating the report. This is now okay.