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,