获取SSAS多维数据集最后处理时间 [英] Get SSAS cube last process time

问题描述

在Excel中，我创建一个Analysis Services连接到一个数据多维数据集。我想通过在最后一个立方体处理时间发生时向他们显示数据的最新状态。在SQL Server Management Studio（SSMS）中对多维数据集进行分析服务连接，我可以右键单击多维数据集，并查看存在最后一个多维数据集处理时间的属性。我也可以按如下方式创建MDX查询，以返回上一个处理时间：

In Excel I make an Analysis Services connection to a data cube. I would like to be able to show a user how current the data is by showing them when the last cube processing time occurred. Making an analysis services connection to the cube in SQL Server Management Studio (SSMS), I can right click on the cube and see the property of the last cube processing time exists. I can also create an MDX query as follows to return the last process time:

SELECT LAST_DATA_UPDATE FROM $system.mdschema_cubes

我想能够在Excel中检索相同的信息，无论是通过VBA还是其他一些方法因为它可以在没有一些外部工具的Excel中完成。

I would like to be able to retrieve this same information in Excel whether it is via VBA or some other method as long as it can be done in Excel without some external tool.

推荐答案

我实际上在Excel中找到了一种方法，而无需创造任何观点或新措施。在Excel 2013中， PowerPivot 允许您针对多维数据集创建自己的自定义MDX查询。您可以打开PowerPivot，连接到您的多维数据集，粘贴到我在SSMS中使用的MDX查询返回多维数据集处理时间。

I actually found a way to do it in Excel without having to create any views or new measures. In Excel 2013, PowerPivot allows you to create your own custom MDX queries against a cube. You can open PowerPivot, make the connection to your cube, paste in the MDX query I used in SSMS to return the cube process time,

SELECT LAST_DATA_UPDATE FROM $system.mdschema_cubes

然后将其导出到数据透视表。我不需要修改Excel之外的任何东西。以下是文件一步一步的程序。

and then export this to a pivot table. I did not need to modify anything outside of Excel. Here is a document with step by step procedures.

这篇关于获取SSAS多维数据集最后处理时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！