DMV MDSCHEMA_CUBES不返回所有事实表和分区的记录 [英] DMV MDSCHEMA_CUBES not returning records for all fact tables and partitons
问题描述
我正在尝试部署在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
推荐答案
嗨Sree,
您拥有什么类型的权限?
您应该能够使用此"MDSCHEMA_DIMENSIONS"查看维度。
Hi Sree ,
What kind of permission are you having ?
You should be able to view dimensions using this "MDSCHEMA_DIMENSIONS"
这篇关于DMV MDSCHEMA_CUBES不返回所有事实表和分区的记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!