Database Reference
In-Depth Information
eXerCISe 11-1. CreatING a CUBe
in this exercise, you create a basic cube using the Cube Wizard.
Note:
open Visual Studio by clicking the Start button and navigating to All Programs ➤ Visual Studio 2010.
Right-click this menu item, select Run as Administrator, and then answer Yes to close the UAC. if you did not
complete the project in the previous chapter, you can find our completed version in the
C:\_BookFiles\Chapter10Files\Chapter10_Complete\PublicationsIndustries
folder.
1.
Right-click the Cubes folder in Solution Explorer, and select New Cube from the
context menu. The Cube Wizard launches, as shown in Figure
11-1
.
2.
Click Next to advance to the Select Creation Method dialog window, and verify that
the “Use existing tables” radio button is checked, as shown in Figure
11-2
.
3.
Click Next to advance to the Select Measure groups Tables dialog window. Select
the Fact Sales and FactTitleAuthors check boxes, as shown in Figure
11-3
.
4.
Click Next to advance to the Select Measures dialog window. Verify that all measures
are selected, as shown in Figure
11-4
.
5.
Click Next to advance to the Select Existing Dimensions dialog window. Verify that all
five of your existing dimensions are selected, as shown in Figure
11-5
.
6.
Click next to advance to the Completing the Wizard dialog window, and rename the
cube to
DWPubsSalesVer1
(Figure
11-7
).
7.
Click Finish to exit the wizard.
in this exercise, you created a basic cube. Next, we review the cube and make any required configurations.
We begin by processing the cube and examining its contents. Let's delve into this topic now!
Processing the Cube
Like dimensions, you must build, deploy, and process a cube before it can be browsed. Also like dimensions, the
act of building adds the XML code you have just created using the wizard to the master
.asdatabase
XML file.
Deploying uploads this master XML file to the SSAS server, and processing copies data from the fact tables in
your data warehouse to the SSAS folders.
The easiest way to process your cube is to right-click the cube in Solution Explorer and select Process
from the context menu. Once you do this, Visual Studio gives a warning indicating that the SSAS server is not
synchronized with the changes to your project and offers to build and deploy it for you (Figure
11-9
). If you want
to process your data with the new cube, you have to click Yes to continue.
