Creating an Analytic Workspace From Relational Tables, 8 of 8

Column Structure of Fact Views

The AW_CUBE_CREATE_ACCESS procedure generates a separate view for each dimension/hierarchy combination. For example, an analytic workspace cube with the four dimensions shown in Table 9-1, would have four separate fact views, one for each hierarchy combination show in Table 9-3.

Table 9-3 Sample Dimension/Hierarchy Combinations

Geography Dim	Product Dim	Channel Dim	Time Dim
`geography/ standard`	`product/standard`	`channel/standard`	`time/standard`
`geography/ standard`	`product/standard`	`channel/standard`	`time/ytd`
`geography/ consolidated`	`product/standard`	`channel/standard`	`time/standard`
`geography/ consolidated`	`product/standard`	`channel/standard`	`time/ytd`

The fact views are fully solved. They contain embedded totals for all level combinations. Each view has columns for the cube's measures, and key columns that link the fact view with its associated dimension views.

Each fact view contains the columns described in Table 9-4.

Table 9-4 Fact View Columns

Column	Description
ET key for each dimension/hierarchy	The ET key column maps to the ET key column of the associated dimension table.
GID for each dimension/hierarchy	The GID column maps to GID column of the associated dimension table.
measure columns	Columns for each of the cube's measures.
empty columns	100 empty numeric columns and 100 empty text columns. These columns may be used to store custom measures.