Database Reference
In-Depth Information
4.
Expand the cubes folder in Solution Explorer and locate the DwweatherTracker.cube
file within the cube file. Double-click this file to bring up a cube designer window.
5.
This window is divided into the Measures and Dimensions pane on the left side of
the screen. Click the small expansion + symbol on each of the objects on the left of
your screen to expand each treeview.
6.
with the treeview expanded, note that the measures and dimensional attributes are
displayed. This indicates which measures and dimensional attributes are parts of the
cube.
7.
in Solution Explorer, expand the Dimensions folder and note that the DimTime
dimension and the DimEvents dimension have their own program files.
8.
Leave open or close the windows you just reviewed if you want, but do not close
visual Studio yet.
Deploy the Cube and Dimensions
From here, we proceed to building, deploying, and processing the cube and dimensions. Although there
should not be any problems at this time, if there are errors, an Error List window will appear. Try your best
to read any error message that may occur, resolve the error and build it again until the build succeeds. The
most common errors involve an incorrect name or password used for impersonation (Figure
2-56
).
1.
Locate visual Studio's Build menu and select the Build weatherTrackerCubes option
(Figure
2-57
). visual Studio will build all the files in this project into a deployment file
and present a “Build succeeded” message at the bottom of visual Studio's window.
Figure 2-57.
Building the SSAS project
