September 28, 2015 at 4:05 pm
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
September 29, 2015 at 5:36 am
You can use SSAS DMVs to get this information: https://msdn.microsoft.com/en-us/library/hh230820.aspx
September 29, 2015 at 9:50 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply