Page 108 - DCAP606_BUSINESS_INTELLIGENCE
P. 108
Unit 7: Creating Cube
A Cube acts as an OLAP database to the subscribers who need to query data from an OLAP data Notes
store. A Cube is the main object of a SSAS solution where the majority of fine tuning, calculations,
aggregation design etc. Now, we will create a cube using our dimension and fact tables. We will
use SQL Server 2008 here.
7.1.1 Explanation
Right click the Cube folder and select “New Cube”, and it will invoke the Cube Wizard. In the
first screen select one of the methods of creating a Cube. We assume our dimensions are ready,
and schema is already designed to contain dimension and fact tables. So we will select the option
of “Use existing tables”.
Figure 7.1: Select Creation Method
Source: http://www.mssqltips.com/tutorialimages/2008_Cube_Wizard_Step_1.jpg
In the next screen, we need to select the tables which will be used to create measure groups. We
again assume we have a DSV which has fact tables in the schema. So we will use this as shown in
the Figure 7.2.
LOVELY PROFESSIONAL UNIVERSITY 103
