如何在Pentaho CE 4.8中重新加载CDA和Mondrian缓存? [英] How to Reload CDA and Mondrian cache in Pentaho CE 4.8?

问题描述

我目前在仪表板上遇到一些性能问题.

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

我已经在Pentaho Community 4.8版中创建了一个仪表板.对于我的图表，使用SQL和MDX(蒙德里安)查询.

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

我的问题是，当我第一次清除cda和Mondrian缓存后打开仪表板时.加载需要50秒.但是下一次只用了不到10秒的时间.

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.

我知道自动清除CDA和Mondrain缓存的方法.

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

如何在不打开仪表板的情况下从后端重新加载CDA和Mondrian模式缓存?

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.

干杯们，

推荐答案

最好的方法是使用CDA缓存调度程序来调度查询.您可以每天在ETL运行之后清除缓存，并安排查询在之后不久运行.

The best way is to schedule the queries using the CDA cache scheduler. You can clear the caches everyday after your ETL runs and schedule the queries to run shortly after.

从工具"菜单中查看CDA缓存管理器，其中有一个计划查询的选项.您选择CDA文件，查询ID和参数值，它将在指定时间运行查询.一旦运行，它们就会存储在缓存中.

Take a look at the CDA cache manager from the Tools menu, there's an option to schedule queries. You choose your CDA file, query ID and the parameter values and it'll run the queries at the specified time. Once run, they're stored in the cache.

您甚至可以为给定集合的每个值运行参数值.例如，假设您有一个国家(地区)"查询返回不同的国家，并且您希望每个国家的前10名客户.您可以在辅助查询上将country参数设置为FOREACH循环.请参阅CDA文档，我想他们对此有详细说明.

You can even have parameter values running for each value of a given set. For example, say you have a Country query returning various countries and you want the top 10 customers for each country. You can set the country parameter on your secondary query to be a FOREACH loop. See the CDA documentation, I think they have details about that.

这篇关于如何在Pentaho CE 4.8中重新加载CDA和Mondrian缓存?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！