How to get a column list from a tabular model?

• SQL Guy 1

  SSCoach

  Points: 15979

  More actions

  September 28, 2015 at 4:05 pm

  #321509

  I have inherited a tabular cube (model) with about 200 columns, and I need to make some changes to calculated columns. I can access it in SSMS and VS.

  I need to create a list of fields, not in alphabetical order but in their actual order. Is there a way to do it? What I also would like to select is whether it is a column or a calculation.

  Thanks

• PB_BI

  SSCoach

  Points: 17463

  More actions

  September 29, 2015 at 5:36 am

  #1830103

  You can use SSAS DMVs to get this information: https://msdn.microsoft.com/en-us/library/hh230820.aspx

  ---

  I'm on LinkedIn

• SQL Guy 1

  SSCoach

  Points: 15979

  More actions

  September 29, 2015 at 9:50 am

  #1830200

  Thank you. They have catalog views for databases, tables, columns , but they don't show whether a column is calculated. But anyway, it's good. I did not know that SSAS also has such views.

• PB_BI

  SSCoach

  Points: 17463

  More actions

  September 29, 2015 at 10:29 am

  #1830209

  OBJECT_TYPE in the DISCOVER_CALC_DEPENDENCY DMV shows what type of column (including calculated) it is.

  ---

  I'm on LinkedIn