查询模型中所有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).