Hi guys,

I have made few reports which have been deployed on pentaho BI server. The only issue I face is the time taken for validation of parameters. All parameters are drop down options which are query driven. All parameter queries are driven from dimension tables. Reporting tables contain 2.4 million rows whereas dimensions tables have 0.1 million rows. Can you please suggest a solution so that the parameter validation time can be decreased??

Pentaho Report Designer version 3.8.3
Pentaho BI Server 4.1.0 stable


Thanks