我想构建一个仪表板，其后端将是 Pentaho 社区版。我正在使用 Mondrian 和 MDX 查询。
我尝试使用 Pentaho CDF 来构建仪表板，但它严重缺乏文档，如果没有适当的文档，就不可能构建仪表板。我面临着很多小事情的问题。
例如，我编写了一个 MDX 查询，该查询返回每个部门的销售额和费用之和。此 MDX 查询在分析视图中运行良好。
在分析视图中，我可以看到销售和费用的不同条形图。然后我在 MDX over MondrianJNDI CDE dahboard 类型的数据源中使用相同的 MDX 查询，并将该数据源附加到 CCC Bar Chart 但 CCC Bar Chart 是仅显示销售额的值。
所以我想知道如何显示与分析视图中相同的条形图？
另外，我想知道如何在 Pentaho CDF 中创建参数化 MDX 查询？如何使用仪表板图表Java API？
我发现使用 Pentaho CDF 很困难，所以我想尝试其他 API 或框架来构建仪表板。在这种情况下还有哪些其他选择？
请各位指教，
先谢谢了！！！
I want to build an dashboard for which back end will be Pentaho community edition. I am using Mondrian and MDX queries.
I have tried to use Pentaho CDF for building dashboard but it seriously lacks documentation and without proper documentation its not possible to build dashboards. I am facing problem with lot of small things.
For example, I wrote one MDX query which returns sum of sales and expenses for each of the department. This MDX query works fine in Analysis view .
In Analysis view I am able to see bar chart different bars for sales and expenses. Then I used same MDX query in datasource of type MDX over MondrianJNDI CDE dahboard type and attached this datasource to CCC Bar Chart but CCC Bar Chart is displaying values for only sales.
So I would like to know how can I display same bar chart as I get in Analysis view?
Also, I would like to know how to create parametrized MDX query in Pentaho CDF? How to use Dashboard Chart Java API?
I am finding it difficult to use Pentaho CDF, so I want to try other API or framework for building dashboards. What are other options available in this kind of scenario?
Please enlighten,
Thanks in Advance !!!
发布评论
评论（2）
（免责声明：我是 CTools 的首席开发人员，特别是 CDF）
您会发现 CDF 确实是 Pentaho 社区中最受欢迎的选择，这反过来意味着社区本身将拥有 CDF最容易帮助你的时间。由于您的问题是文档，我不确定您对已有的内容进行了多少探索。如果您安装了 Pentaho，从 Pentaho 用户控制台头到 BI 开发人员示例解决方案文件夹，在 CDF 下您将找到 CDF 文档。
或者，我建议您尝试一下 CDE（CDE 是一个在 CDF 和 CDA 之上构建仪表板的编辑器）。您可以在此处找到一个很棒的教程。
(disclaimer: I'm the lead developer for the CTools in general, and CDF in particular)
You'll find that CDF is indeed the most popular choice within the Pentaho community, and that in turn means that it's what the community itself will have the easiest time helping you with. Since your issue is documentation, I'm not sure how much you've explored what's already there. If you have Pentaho installed, from the Pentaho User Console head to the BI Developer Examples solution folder, and under CDF you'll find the CDF Documentation.
Alternatively, I suggest you give CDE a try (CDE is an editor that builds dashboards on top of CDF and CDA). You'll find a great tutorial for it here.
（免责声明：我在 icCube 工作）。
如果您热衷于非免费的解决方案，您可以尝试 icCube OLAP 服务器 及其 GVI 库。它处于起步阶段，但如果您想构建自己的解决方案，它会很有趣。您可以在此处查看一些示例。
如果您需要支持，支付一点支持费用是一种节省金钱和时间的解决方案（这适用于您采用的任何解决方案）。社区很好，但人们可以免费帮助他人的时间是有限的。
(disclaimer:I'm working for icCube).
If you're keen going for a no free solution you can try icCube OLAP server and their GVI library. It's on the starting blocks but interesting if you want to build your own solution. You can see some examples here.
If you need support, paying for a little support it's a money and time saving solution (this for any solution you take). Community is nice, but there is a limit on the time people can spend helping other for free.