本文介绍了DMV MDSCHEMA_CUBES不返回所有事实表和分区的记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试部署在Azure Analysis Service上的表格数据库的最新处理日期。当我在DAX Studio或SSMS中运行以下命令时。它只返回一个多维数据集名称作为模型的记录。我想看看这个多维数据集中的所有维度和
事实表以及它们何时被处理。我认为这个DMV过去常常在那个级别返回细节。我不再看到这些信息,我在这里遗漏了什么。任何帮助都是赞赏的。谢谢!!

I'm trying to the latest process date for a tabular database that is deployed on Azure Analysis Service. When I run the following command in DAX Studio or SSMS. It only returns one record with cube name as model. I would like to see all the dimensions and fact tables that are under in this cube and when they were processed. I think this DMV used to return details at that level before. I don't see that information anymore, Am I missing anything here. Any help is Appreciated. Thanks!!

SELECT *   FROM $ SYSTEM.MDSCHEMA_CUBES

SELECT * FROM$SYSTEM.MDSCHEMA_CUBES

sree

推荐答案


这篇关于DMV MDSCHEMA_CUBES不返回所有事实表和分区的记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

11-02 06:50