There are several steps to create a new cube. You can change design decisions after creating the cube, but the initial steps must be taken in the following order:
- Create a blank schema.
- Define the fact tables and dimension tables for the cube.
- Define the relationships between the fact tables and dimension tables.
See Defining Relationships Between Fact Tables and Dimension Tables.
- Define a dimension for the cube. .
A dimension can be used by any cube in the schema. See Creating a Dimension
- Define a hierarchy with at least one level in your dimension.
- Create at least one measure group. .
- Create a cube which includes one or more measure groups.
See Creating a New Cube.
- Validate and publish the cube.