SQL Server Analysis Services (SSAS) Multidimensional - Automatic Data Lineage

Michał Trybulec - Dataedo Team Michał Trybulec 3rd June, 2024

What to Expect

Dataedo imports automatically:

  1. Sources, Dimensions and Cubes
  2. Column-level lineage from Data Source Views to Dimension
  3. Column-level lineage from Source (for example SQL Server) to Data Source Views

SQL Server -> SQL Server Analysis Services Multidimensional

Image title

Troubleshooting

Lineage is created based on a matched Linked Source, check the Dataedo desktop to make sure it is matched properly. Image title