Extract DAX expressions from Powerpivot / Tabular SSAS RRS feed

  • Question

  • Is it possible to extract the DAX expressions from a Powerpivot model or tabular model in SSAS (for documenting purposes for example)? Are there any DMV's that can be used?
    Wednesday, July 20, 2011 5:01 PM


All replies

  • select * from $SYSTEM.DISCOVER_CALC_DEPENDENCY looks promising :-) I believe this DMV is new in Denali?
    Wednesday, July 20, 2011 10:11 PM
  • Yes, that is correct. Does it meet your needs?

    Thursday, July 21, 2011 7:24 AM
  • Yep, works great.
    Monday, September 19, 2011 8:33 PM