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

OLAP Datasource

  • In the next box, choose ‘Microsoft OLE DB Provider for ODBC Drivers

Data Link properties

  • Click on Next  and choose MSTUTORIAL DSN that we created in the previous step from the drop down list.

Data Link properties

  • 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
<<< Create ODBC DSN for Analysis ServicesCreate a Data Cube in Microsoft Analysis Services >>>
Copyright 2005-2016 KnowledgeHills. Privacy Policy. Contact .