search

keif888 / SQLServerMetadata

SQL Server Metadata Toolkit
Microsoft Public License
83 stars 32 forks source link

SSASEnumerator doesn't find DSV-Tables, that are SQL Server Views #3

Open keif888 opened 7 years ago

keif888 commented 7 years ago

SSASEnumerator assumes that DSV-Tables with TableType "View" are "Named Queries" and only reads their "QueryDefinition". But there are also DSV-Tables with TableType "View", that represent Views from the SQL Server. Those should be treated like DSV-Tables with TableType "Table", so that the Dependency to the SQL Server View can be recorded.

I agree that the relationship should be differentiated for full lineage and transparency. I second that vote. --Steven Neumersky

kaisp84 commented 1 year ago

👍