Databases Reference
In-Depth Information
A cube in Analysis Services 2005 consists of one or more measure groups
from a fact table (typically you will have one measure group per fact table)
and one or more dimensions (such as Product and Time) from the dimension
tables. Measure groups consist of one or more measures (for example, sales,
cost, count of objects sold). When you build a cube, you need to specify the
fact and dimension tables you want to use. Each cube must contain at least
one fact table, which determines the contents of the cube. The facts stored in
the fact table are mapped as measures in a cube. Typically, measures from
the same fact table are grouped together to form an object called measure
group. If a cube is built from multiple fact tables, the cube typically contains
multiple measure groups. Before building the cube the dimensions need to be
created from the dimension tables. The cube wizard packages all the steps
involved in creating a cube into a simple sequential process:
1. Launch the Cube Wizard by right-clicking the Cube folder in the
Solution Explorer and selecting New Cube.
2. Click the Next button in the welcome page.
3. You are now asked to select the method to build the cube. Choose
the default value and then click the Next button (see Figure 2-25 ).
Note you are using the Cube Wizard.
 
 
Search WWH ::




Custom Search