为最终用户提供更简单的 SQL Server 分析服务多维数据集界面
是否有更简单的界面供最终用户在预先存在的 SqlServer Analysis Service 多维数据集上运行“查询”？ 我正在寻找一种方法来部署多维数据集并允许用户通过比 BIDS 更简单的界面来处理数据。 这可能吗？
Is there a simpler interface for end users to run "queries" on pre-existing SqlServer Analysis Service cubes? I'm looking for a way to deploy the cubes and allow the users to work with the data through a simpler interface than BIDS. Is this even possible?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（7）
我也推荐Excel。 无论如何，这是一个用户熟悉的环境，他们将能够执行额外的分析（总计等），而无需学习任何新界面。
但是，我建议不要将数据透视表作为将数据导入 Excel 的方法。 我曾经参与过一个使用数据透视表的项目，那是一场肮脏的噩梦。 Office 的最新版本有一个稍微不同的工具，称为“Microsoft Office Excel Add-in for SQL Server Analysis Services”，它可以将 OLAP 数据导入 Excel。 我下载了 XLAddinSetup.msi Excel 2002/3 或者您可以使用此方法用于 Excel 2007< /a>.
I would recommend Excel too. It is an environment that your users are familiar with anyway, and they will be able to perform additional analysis (totals etc) without learning any new interfaces.
However, I would advise against pivot tables as a method of getting the data into Excel. I once worked on a project using pivot tables, and it was a filthy nightmare. The more recent versions of Office have a slightly different tool called "Microsoft Office Excel Add-in for SQL Server Analysis Services" which can get OLAP data into Excel. I downloaded XLAddinSetup.msi for Excel 2002/3 or you can use this method for Excel 2007.
您可以使用带有数据透视表的 Excel，根本不需要编写任何查询，它们可以深入到所需的所有数据
You can use Excel with pivot tables for that, no need to write any queries at all, they can drill down to all the data they need
有一些最终用户报告工具。
我们的工具 - RSinteract 非常便宜且有效。 它使用 AJAXy Web 界面，因此无需在客户端上安装，并且具有与其他工具类似的拖放功能。 它还具有 30 天的评估。
There's a couple of End User Reporting Tools around.
Our tool - RSinteract, is quite cheap and effective. It uses an AJAXy web interface so no need to install on the client and has drag and drop functionality similar to the other tools. It also has a 30 day evaluation.
有很多很多的工具。 不完整的概述可以在这里找到：http://www.ssas- info.com/analysis-services-client-tools-frontend
There are many, many tools. An incomplete overview can be found here: http://www.ssas-info.com/analysis-services-client-tools-frontend
Dundas 有一组工具，可让您拖放维度/层次结构/度量来创建图表和/或网格等可视化效果。 产品名称为 Dundas Chart for ASP.NET Enterprise Edition，并且有免费演示。
ProClarity 还有一套工具。 不知道如何再获得这些工具，但我认为它们现在已成为 MSDN 的一部分。
Dundas has a set of tools that let you drag and drop dimensions/hierarchies/measures to create visualizations like charts and/or grids. The product name is Dundas Chart for ASP.NET Enterprise Edition, and it has a free demo.
ProClarity also had a suite of tools. Not sure how you get those tools any longer, but I think they are part of MSDN now.
正如 Jay 所说，您可以使用多种客户端工具来查询多维数据集，这些工具使最终用户能够拖放维度以进行即席查询。
ProClarity 已被 Microsoft 收购，大部分功能已合并到 PerformancePoint
Panorama Software（分析服务的原始开发人员）中，也提供对其 NovaView 产品的访问
As stated by Jay, there are several client tools you can use to query the cubes that give the end user the ability to drag and drop dimensions for ad-hoc querying.
ProClarity has been acquired by Microsoft, and most of the functionality is being incorporated into PerformancePoint
Panorama Software (original developers of Analysis Services) also provide access with their NovaView products
另一个选项是报表生成器，它随 SQL Server 免费提供。
尽管 SQL Server 2005 版本有点古怪，但 SQL Server 2008 的新版本似乎工作得更好。
虽然它在即席查询方面不如 Excel 灵活，但对于某些场景来说它非常方便。
Another option is Report Builder, that comes for free with SQL Server.
Though the SQL Server 2005 version is a bit cranky, the new release with SQL Server 2008 seems to work much better.
Although it isn't as flexible as excel for ad-hoc queries,it comes very handy for some scenarios.