查詢模型中所有Measure定義（DAX）

hai503發表於2022-09-28
模型


查詢模型中所有Measure定義（DAX）：


在DaxStudio中執行查詢（匯出）:


SELECT MEASURE_NAME, EXPRESSION

  FROM $SYSTEM.MDSCHEMA_MEASURES

 WHERE MEASURE_AGGREGATOR = 0

 ORDER BY MEASUREGROUP_NAME

Ref.

Explore the model with   Dynamic Management Views (DMVs)


select *  from $SYSTEM. MDSCHEMA_MEASURES
select *  from $SYSTEM. TMSCHEMA_MEASURES


  1. MDSCHEMA: Multi-dimensional (MD); provides information from the model how it is understood from MDX (XML information).

  2. TMSCHEMA: Tabular model (TM); provides information from the tabular model (TMSL information).


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12707874/viewspace-2916598/，如需轉載，請註明出處，否則將追究法律責任。

相關文章