Microsoft Analysis Services Tutorial

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

Next>>