SQL Server 2017 Integration Services Cookbook

How to do it...

1. In SSDT, add a new analysis services multidimensional and data mining project to the Chapter08 solution and name the project Ch08SSAS.
2. In solution explorer, right-click the Data Sources folder and select New Data Source to create a new data source.
3. In the Data Source Wizard welcome screen, click Next.
4. In the Select how to define the connection screen, create a data source using a connection AdventureWorksDW2014 database. Click Next.
5. In the Impersonation Information screen, you need to define how SSAS will connect to SQL Server to read the data. Use a Windows user that has permission to read the data. Click Next.
6. In the Completing the Wizard screen, accept the default name and click Finish.
7. Create a new data source view based ...