You can create a cube to specify regions of
your cube model that are significant. You can use a cube to define
a subset of your data for the Cubing Services Cube Server and other
client OLAP tools. The cube is the OLAP object that is served by
the cube server and queried through the MDX query language.
Before you begin
Before
you create a cube, you must create or import a cube model. The cube
model must have a facts object and at least one dimension, and each
dimension must have a hierarchy.
A cube is a precise definition of an OLAP cube that you
can query by using a single MDX statement. A cube is derived from
an existing cube model. The cube facts and list of cube dimensions
are subsets of the facts and dimensions that are in the referenced
cube model.
Cubes are appropriate for tools and applications
that do not use multiple hierarchies because cube dimensions allow
only one cube hierarchy for each cube dimension.
Procedure
- In the Data Project Explorer, expand the OLAP
Objects folder, right-click the cube model that you want
to derive the cube from, and select .
Tip: You can also create a cube by right-clicking
the Cubes folder under the cube model and selecting Add
Cube.
A cube is automatically
added to the cube model. You can rename the cube either by pressing
F2 when the cube is selected, or in the Properties view. Make sure that you can see the Properties view.
If you cannot see the Properties view, click . You might need to select the OLAP object from the
Data Project Explorer again.
- Add hierarchies to the cube.
- Right-click the cube, and select . The Hierarchy Selection Wizard opens.
- Select one or more hierarchies from the list, and click Finish.