How to SSAS Cube Lineage in SQL Server?

• aashifahamed03

  SSC Enthusiast

  Points: 123

  More actions

  December 23, 2016 at 7:20 am

  #401260

  I'm looking for a way to get the metadata lineage information of a SSAS.

  I want to trackback the measure of cube to its physical column . (i.e. Datasourceview column)

  Can anyone help on this?

  I referred the below sites:

  ​https://dataself.com/wiki/Cube_Metadata_MDX_Query

  http://richardlees.blogspot.in/2010/07/querying-analysis-services-for-cube.html

  http://www.ssas-info.com/analysis-services-articles/66-mgmt/2701-ssas--using-dmv-queries-to-get-cube-metadata

  All are giving the details of cube objects , but not the relationship between Datasource view and Cube .