Hi All,


I'm currently stuck in some performance issue for my Dashboard.

I've created a dashboard in Pentaho Community edition 4.8. For my charts, using the SQL and MDX (Mondrian) queries.


My Problem is that, When I first time open my dashboards after clearing cda and Mondrian cache. It take 50 secs to load. But next time it took less then 10 secs.


I know the method to clear CDA and Mondrain cache automatically.


How to reload the CDA and Mondrian schema cache from back-end (with out opening the dashboard.)?


Please suggest. I'm really getting stuck with that point.


Cheers Guys,