KnowledgeHills Logo RDBMS, Data Warehouse, Data Mining Tutorials

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

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

Next>>



Post your Job for Free and get resumes emailed to you instantly. A new FREE service from KnowledgeHills.com

Do you provide IT/Business  related services or products? Submit your  whitepapers for free and reach our 20,000 plus registered members. You may also like to list your available jobs list your company or list your product for FREE.