Creating Cube In SQL Server Analysis Services 2008

In today's article you will learn about how to create cube in SQL Server Analysis Services 2008.
  • 1831

In today's article you will learn about how to create cube in SQL Server Analysis Services 2008. An OLAP (Online analytical processing) cube is a data structure that allows fast analysis of data. It can also be defined as the capability of manipulating and analyzing data from multiple perspectives. The arrangement of data into cubes overcomes some limitations of relational databases.

Steps in creating a Cube

  • Creating Analysis Services Project
  • Define Data Source
  • Creating Data Source View
  • Creating Cube And Dimensions
  • Process the Cube

Follow Given steps to create your first cube.

Step 1

Creating Analysis Services Project

Open SQL Server Business Intelligence Development Studio. Start --> All Programs --> Microsoft SQL Server 2008 --> SQL Server Business Intelligence Development Studio.

OLAPCube01.jpg

Click File --> New --> Project. Select the Analysis Services Project from the Visual Studio installed templates category of the New Project dialog, then type the name of the project in the Name text box, and click OK.

OLAPCube02.jpg

Step 2

Define Data Source

To add a data source, In Solution Explorer, right-click the Data Sources folder and click New Data Source.

OLAPCube03.jpg

Click Next In the Data Source Wizard. On the Select how to define the connection page, click New to set up a new connection.

OLAPCube04.jpg

Define Connection Type, name of server, select database and Click Test Connection to check the connection. Click OK.

OLAPCube05.jpg

When you're back in the Data Source Wizard, click Next.

Step 3

Creating Data Source View

In Solution Explorer, right-click on the Data Source Views folder and then click New Data Source Views. Click Next on the Welcome page.

OLAPCube06.jpg

Select the data source from the Select a Data Source page and click Next. On the Select Tables and Views wizard page, select tables and views from the list of objects that are available from the selected data source. Then click finish.

Step 4

Creating Cube And Dimensions

In Solution Explorer, right-click on the Cubes folder and then click New Cube. On the Select Creation Method page, keep the default option Use existing tables and click Next button. Then select the objects that needs to participate in the CUBE development. If you are not sure then click on the suggest button.

OLAPCube07.jpg

Click Next Button to open the Select New Dimension page and select dimensions. Click Next to continue.

OLAPCube08.jpg

In Completing Wizard, enter the valid cube name and click Finish to close the wizard.

OLAPCube09.jpg

Cube layout is shown below.

OLAPCube10.jpg

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.