首页 > 大数据 > 可视化 > 查询模型中所有Measure定义(DAX)
查询模型中所有Measure定义(DAX):
在DaxStudio中执行查询(导出):
SELECT MEASURE_NAME, EXPRESSION
FROM $SYSTEM.MDSCHEMA_MEASURES
WHERE MEASURE_AGGREGATOR = 0
AND CUBE_NAME = 'Model' // [Fix: 遇到有DisplayFolder的Measure,导出会double]
ORDER BY MEASUREGROUP_NAME
Ref.
Explore the model with Dynamic Management Views (DMVs)
select *
from$SYSTEM.
MDSCHEMA_MEASURES
select *
from$SYSTEM.
TMSCHEMA_MEASURES
MDSCHEMA: Multi-dimensional (MD); provides information from the model how it is understood from MDX (XML information).
TMSCHEMA: Tabular model (TM); provides information from the tabular model (TMSL information).
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12707874/viewspace-2916598/ ,如需转载,请注明出处,否则将追究法律责任。