Can I Have A Shower Straight After Ive Waxed

And you ... Already a member to Hacksol?

This post has
item Steps to create cubes in SQL Server OLTP - Business Intelligence



To run the project can download the OLTP database bucket list:
http://www.4shared.com/file/BdWZ09_w/Northwind_OLAP.html
. Unzip in a single location *. bak file, make sure you have installed on the server and client computer Analysis Services and SQL Server Business Intelligence Development Studio. If correct follow the instructions:


Step 1: Connect to Motor

database and restore the database NorthWind_OLAP. Look at the diagram of relationships. In the example, the database has 5 dimensions and Sales_Fact is the central table.











Step 2: Open
SQL Server Business Intelligence Development Studio.
Use the option to create a new database. In "Name the database" Type Northwind_Mart and set the impersonation mode. For example use "Use the credentials of current user"



Done. The basis for the consultations were carried out successfully.

Step 3:
In Visual Studio create a new solution for Bussiness Intelligence and connect to the database Northwind_Mart. Follow the wizard's instructions.

Step 4:
As a result of previous step we obtain a diagram of the database. It is necessary to define the dimensions. In Solution Explorer to find the node dimensions and create a new dimension by using the context menu in the node.



Select the elements or fields that are present in dimensions.

Select the table that will be the center of the combinations or have the measurements. For example select Sales_Fact.




Continue adding dimensions to complete the entire database schema.


Step 5:

After the configuration of dimensions is necessary to process the cube. In the Hub node in Solution Explorer context menu used to start the check.

"Processing Hub" to verify if the configuration database Northwind_OLAP is suitable for cube queries. If an error occurs, reconfigure the hub using the error descriptions listed in the log.

Step 6 Step 6 If successfully completed, there is only connected to the hub for the outcome of the consultation.
In the Browser tab drag the dimensions to the area of \u200b\u200bconsultation and see the result.

The quality of information received depends on the management of the correct size and design of the cube. Good job!