Step by step sqlserverbi-multi-dimensional database creation

Next we go to the previous section of "step by step to learn sqlserver BI--ETL design", now our game transaction data analysis system data warehouse has been built, and has data, let's start our OLAP process.
In this section, we will explain in detail how to use sqlserver2005 Analysis Service to establish a multi-dimensional database.
First, create an analysis services project. After the project is created, we will see the project structure shown in our solution Resource Manager.

Next, we will create a new data source, and then follow the wizard step by step. After the Wizard is complete, a connection string to the Data Warehouse is actually established.

Then create a data source view, which is almost step by step following the Wizard. In fact, we select the table we need from the data source to our data source view.





Now let's start to create a multi-dimensional dataset, which is also the focus of today's section.

Select a time dimension table.

Finally, we release our multi-dimensional database to our sqlserver2005 Analysis Service server.
Right-click Project Properties and set the target server (for example) to be deployed ). After setting, click the deployment button on the toolbar to deploy the multi-dimensional database to our server.

After the deployment is complete, you can right-click the multi-dimensional dataset to browse the data.

Because the process is relatively simple, no text is used in the above process. So far, our multi-dimensional database has been established. Of course, if you want to apply it to a specific project, you need to modify many attributes of the multi-dimensional database.

In the next section, I will describe in detail how to use adomd. Net to develop applications built on this multi-dimensional database.