- Microsoft Analysis Services Tutorial
- Starting the Analysis Manager in Analysis Services
- Create Database for Analysis Services
- Create ODBC DSN for Analysis Services
- Create Data Source for Analysis Services
- Create a Data Cube in Microsoft Analysis Services
- Select Fact Table and Choose Measures in Analysis Services
- Select Dimensions in Microsoft Analysis Services
- Create Time Dimension in Microsoft Analysis Services
- Create Time Dimension in Microsoft Analysis Services – Continued
- Create Product Dimension in Microsoft Analysis Services
- Create Customer Dimension in Analysis Services
- Create Store Dimension in Microsoft Analysis Services
- Finish Building the Cube – Microsoft Analysis Services
- Cube Editor – Microsoft Analysis Services
- Design Storage and Process the Cube in Microsoft Analysis Services
- Browse the Cube Data in Microsoft Analysis Services
- Browse Cube Data – Change the Dimensions in the Grid
Create Database for Analysis Services
In the Analysis Manager, Right click on your computer name and choose ‘New Database’ . A dialog box will appear asking for the Database name and description.
In this input screen, type name and description of the database as shown below.
Click OK and you will see a new node under your computer name in the left panel called “Tutorial”
Expand the Tutorial node and you will see Data Sources, Cubes, Shared Dimensions, Mining Tools and Database Roles.
In the next section, we will learn how to create a Data source.