创建查询后如何从SASS多维数据集导出我的数据？ [英] How can I export my data from a SASS cube after creating a query?

问题描述

我可以在SSAS中创建查询并执行，但是我想将结果导出到excel或.csv文件，以便我进一步分析。

I can create my query in SSAS and execute, but I want to export the result to excel or a .csv file so that I can analyse it further.

似乎没有一个直观的方法来做到这一点，PowerPivot无法提供我想要的。

There doesn't seem to be an intuitive way to do this and PowerPivot is not able to provide what I want.

推荐答案

你可以在Excel中创建直接链接到多维数据集的数据透视表。这显示e。 G。在此视频。基本上，您需要在您的计算机上安装Analysis Services客户端（如果您拥有SSAS开发人员客户端，这将在您的计算机上安装）。然后在Excel中选择Data / Form other sources / From Analysis Services，然后按照向导配置与SSAS多维数据集的连接，并将此信息保存在本地文件中，然后选择单元格，其中的数据透视表将被定位。

You can create a pivot table in Excel that is linked directly to your cube. This is shown e. g. in this video. Basically, you need to install the Analysis Services client on your computer (which will already be done in case you have the SSAS developer client). Then you select "Data/Form other sources/From Analysis Services" in Excel, and follow the Wizard to configure the connection to your SSAS cube, and to save this information in a llocal file, and then select the cell, where the pivot table will be located.

另一种方法是使用多维数据集公式，如 CUBEMEMBER 和 CUBEVALUE 在Excel单元格中，允许您直接从多维数据集获取信息到单元格。您可以在Excel帮助中找到他们的文档，或这里。您甚至可以通过选择选项/工具/ OLAP工具/转换为公式将数据透视表转换为这些公式如这里所述的Excel 2007 ，但是没有办法。

Another approach would be to use cube formulas like CUBEMEMBER and CUBEVALUE in Excel cells which allow you to directly get information from a cube to a cell. You can find their documentation somewhere in the Excel help or here. You can even convert a Pivot table to these formulas by selecting "Options/Tools/OLAP Tools/Convert to Formulas" as described here for Excel 2007, but there is no way back.

这篇关于创建查询后如何从SASS多维数据集导出我的数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！