Creating a complete cube model using the Design Studio
To create a complete cube model, you first a cube model in your database model based on a single facts
table, then add a facts object, dimensions, hierarchies, and levels
for each dimension in that cube model. Cube models define the relationships
between the relational data in your star schema or snowflake schema
so that you can optimize queries to your relational data.
After you complete the cube model, you can create cube
objects that can contain all or a subset of the cube model objects'
properties.
To create a complete cube model, complete the following
tasks:
Creating a cube model in the Design Studio You can create a cube model in your database
model base on a single facts table. If you have constraints defined
on your facts and dimension tables, the Cube Model wizard will be
able to generate a complete cube model with dimensions, hierarchies
and cubes.
Creating a facts object using the Design Studio A default facts object is created when you
add a cube model. You can define a facts object only as part of an
existing cube model as the center of a star schema or snowflake schema.
A facts object groups related measures that are interesting to a given
application. You can create simple and calculated measures.
Creating an attribute using the Design Studio
You can create an attribute by using the Design Studio.
An attribute maps either to a single column in a table or to an expression
that is a combination of a set of columns or other attributes.