OLAP 的报告工具，*不是* OLTP！
我正在寻找一个可以放在现有 OLAP 星型模式之上的控件，以允许用户定义自己的“查询”并生成报告。现在，我在多维数据集之上构建了一些预定义的报告，但我希望允许用户根据我创建的多维数据集定义自己的标准。我发现很多产品可以让您像处理 OLAP 多维数据集一样处理事务表，但没有专门针对预先存在的多维数据集的产品。
编辑：让我说清楚，我知道有无数的报告工具声称可以报告 OLAP 多维数据集。问题是他们都假设自己正在查看事务数据并尝试创建自己的多维数据集。我的表包含数十甚至数亿条记录。大多数工具在处理这么多数据时都会崩溃，而其他工具则运行得非常缓慢。我不想要一个针对商务人士的工具。
我想要一个能够理解星形和雪花模式是什么的工具。我希望能够告诉它什么是事实表以及什么是维度表，然后在它们之上创建一个 UI。对于工具供应商来说，这是一个更容易解决的问题，因为我用勺子给他们喂立方体。我想依赖立方体是标准化模式这一事实，并且我想要一个能够利用这一事实的工具。我想要一个针对开发人员的工具，并首先假设我实际上知道如何管理我的数据，它只需要为我构建漂亮的报告，而不是在我的数据的重压下崩溃。
I'm looking for a control that I can put on top of an already existing OLAP star schema to allow the user to define their own "queries" and generate reports. Right now I have some predefined reports built on top of the cubes, but I'd like to allow the user to define their own criteria based on the cubes that I've created. I've found lots of products that will allow you to treat a transactional table like an OLAP cube, but nothing specifically for pre-existing cubes.
EDIT: Let me be clear, I know there are countless reporting tools out there that claim to report on OLAP cubes. The problem is they all assume they are looking at transactional data and try to create their own cubes. I have tables that contain tens, if not hundreds of millions of records. Most tools crash when handling this much data, the others just run incredible slowly. I don't want a tool that is targeting the business people.
I want a tool that understands what a star and snowflake schema is. I want to be able to tell it what the fact tables are and what the dimension tables are, and then creates a UI on top of them. This is an easier problem to solve for the tool vendor because I am spoon feeding them the cubes. I want to rely on the fact that cubes are a standardized pattern and I want a tool that takes advantage of this fact. I want a tool that targets developers and starts with the assumption that I actually know how to manage my data, it just needs to build pretty reports for me and not crumble under the weight of my data.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（9）
SQL Server 的 SSRS 设计为与多维数据集一起使用（我们一直用它来查询数据仓库），但这是供应商特定的实现，如果您没有 SQL Server，则无法使用它与 SQL Server。您可以编写 MDX 查询，而不仅仅是直接的 t-sql。我知道您可以在查询中引用其他数据库，但我从未尝试过引用不同供应商的表，因为我们的数据仓库位于 SQL Server 数据仓库中。
Well SSRS for SQL Server is designed to be used with cubes (we query our data warehouses with this all the time), but that is a vendor specific implementation and if you don't have SQL server you can't use it as it comes with SQL Server. You can write MDX queries and not just straight t-sql. I know you can reference other databases in queries, but I have never tried to reference a different vendors' tables becasue our data warehous in a SQL Server data warehouse.
我使用过各种报告工具，但到目前为止，最终用户最熟悉的是 MS Excel 数据透视表。请点击此链接了解更多信息。
I've used various reporting tools, but by far the most familiar to the end users is MS Excel Pivot Tables. Please follow this link to further information.
如果您想要一个完整的企业级软件，您正在寻找像 Cognos(IBM) 报告套件。他们的工具有一个查询框架，可以根据关系源和 OLAP 源进行报告，具体取决于您的建模方式。这意味着如果建模正确，您可以使用相同的工具针对 SQL Server 和 MSAS 进行多维报告。他们支持自己的多维数据集、TM1、ORacle、Microsoft、SAPBW 等...您还可以使用一个 SDK 来编写自己的前端工具。不便宜，但没有企业那么便宜。
这个领域的竞争对手（我没有使用过）是Business Objects(SAP ) 和 Hyperion(Oracle)。也许还有 JasperSoft （开源）。
另请查看此问题的答案。他提到了 BO 和 Microsoft 解决方案。
If you want a full enterprise-level software, you're looking for a tool like the Cognos(IBM) reporting suite. Their tools have a single query framework for reporting against both relational and OLAP sources, depending on how you model it. That means you can do multidimensional reporting against SQL server and MSAS with the same tool if it's modeled properly. They support their own cubes, TM1, ORacle, Microsoft, SAPBW, etc... There's an sdk you can use to write your own front-end tool as well. Not cheap, but nothing enterprise is.
Competitors in this field (I haven't used) are Business Objects(SAP) and Hyperion(Oracle). And maybe JasperSoft (open source).
Also check out the answer to this question. He mentions BO and a Microsoft solution.
Stefan，如果您的最终目标是报告，我会建议使用 Tableau 这样的工具。对于普通用户来说学习起来非常简单，并且允许他们使用界面即时生成报告或针对数据库键入自定义查询。如果您正在寻找更先进的东西，我会建议像 CockPit 这样的产品（我知道......），由一家德国公司开发，它也非常简洁，并且正在开始腾飞。
Stefan, if your end-goal is for reporting I would suggest a tool like Tableau. It is very simply to learn for the average user and it allows them to make reports on the fly using the interface or type custom queries against the database. If you are looking for something more advanced I would suggest a product like CockPit (I know...) developed by a German based company that is also really neat and starting to take off.
您可以尝试 Dundas 解决方案，该解决方案允许最终用户根据多维数据集中创建的维度和度量创建自己的报告。
You could try Dundas solution which allows end users to create their own reports based on dimensions and measures created in the cube.
您是否在寻找类似 Mondrian 的东西？我们在之前的项目中使用过它，我记得它的 OLAP 报告相当不错。但不记得它是否有图形用户界面；那不是我的领域。我只是搞乱了配置文件......
Are you after something like Mondrian? We used it on a previous project, and I seem to recall its OLAP reporting was pretty good. Can't remember if it had a gui, though; that wasn't my area. I only ever messed with the config files...
您好，您可以使用 SSRS，其中用户只需浏览多维数据集即可构建报告，或者您可以使用 OLAP 优势编写自定义 mdx 查询。
您可以使用 SQL Server 报表生成器
最后，Microsoft Excel 2007 具有良好的多维数据集浏览功能
您甚至可以通过 Microsoft Excel services 2007 在 SharePoint 中公开您的多维数据集
Hi you can use SSRS where user can build reports just browsing the cube or u can write custom mdx queries using the OLAP advantage.
You can use SQL Server Report Builder
And last not least Microsoft Excel 2007 has good capability of browsing a cube
You can even expose your cube in SharePoint via Microsoft excel services 2007
我举起双手，坦率地承认我不是这个领域的专家，但你可以看看 信息光明。我知道它仍然会关闭并索引您现有的数据（我不确定它是否形成自己的多维数据集），但我相信它可以快速处理大量数据。
还有社区版和商业版。我从未使用过该软件，但从我之前读到的有关它的内容来看，它似乎令人印象深刻。
I hold my hands up and freely-admit that I'm not an expert in this domain, but you could have a look at InfoBright. I understand it will still go off and index your existing data (I'm not sure if it forms its own cubes), but I'm led to believe it can handle massive amounts of data quickly.
There's a community edition and a commercial edition too. I've never used the software, but from what I've read about it before, it seems impressive.
您可以尝试一下 Web 数据透视表，它是一个基于 Web 的报告工具，可以连接到 CSV 文件和 OLAP 多维数据集，就像Excel 数据透视表。这是 演示 和 文档。
您可以连接到多个源数据（例如，多个 OLAP 多维数据集），创建多个数据透视表和数据透视图，然后根据这些数据透视表和数据透视图的任意组合创建多个报表。
You could give Web Pivot Table a try and it is a web based reporting tool which connect to both CSV files and OLAP cubes just like excel pivot table. Here is demo and documents.
You can connect to multiple source data (for example, multiple OLAP cubes), create multiple pivot tables and pivot charts and then create multiple reports based on any combination of these pivot tables and pivot charts.