Create Data Source for Analysis Services
- In this section will create a new Microsoft Analysis Services Data Source from the ODBC DSN that we created in the last section.
- Right click on the Data Sources (under your computer name/Tutorial ) in the left panel and select New Data Source
- In the next box, choose ‘Microsoft OLE DB Provider for ODBC Drivers
- Click on Next and choose MSTUTORIAL DSN that we created in the previous step from the drop down list.
- Click on OK and you have successfully created a Microsoft Analysis Services data Source.
- You will create Cube based on this Data Source in the next section