将Pentaho Reporting Web前端与自定义Java/JSF应用程序集成

问题描述

我有以下情况:

包含数据的OTLP数据库架构.数据库过程将数据泵入具有已定义维和事实表的非规范化星型架构.目标是构建Web应用程序，该应用程序可以对定义的数据结构进行汇总和下钻.

我可以构建自定义的Web界面，但是我希望将现有工具用于报告部分.最终的应用程序必须用Java编写，并与基于JSF的现有解决方案集成，Pentaho看起来可以完成任务，但是我找不到任何地方，如何解决这个问题，或者是否有可能. >

谢谢

解决方案

正如亚当所说，如果您拥有OLAP，则可以使用Jpivot-或更好地使用Saiku. Saiku使其易于开发自己的前端，并且全部基于REST.它确实带有一个UI，但是由于服务器是分开的，因此您不必使用它.

I have the following situation:

OTLP database schema with data. Database procedures pump data into denormalized, star-schema with defined dimensions and fact tables. The goal is to build web application, which can do summary and drill-down on those defined data structures.

I can build custom web interface, but I would prefer to use existing tools for the reporting part. The resulting application must be written in java and integrated with existing solution based on JSF and Pentaho looks like it's up to the task, but I can't find anywhere, how one would go about this, or whether is this even possible.

Thank you

解决方案

As Adam says if you have OLAP you can use Jpivot - or better use Saiku. Saiku makes it ridiculously easy to develop your own front end, and is all REST based. It does come with a UI but you dont have to use it as the server is separated.

这篇关于将Pentaho Reporting Web前端与自定义Java/JSF应用程序集成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！