Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

Table Structure of Sample TIMES_DIM Dimension Materialized View

The following table identifies the columns of the materialized view for the Times dimension CAL_ROLLUP hierarchy.

Column Name

Datatype

Description

COUNT_STAR

NUMBER

The total number of rows.

GID

NUMBER

The grouping IDs for the remaining level columns. Created by the GROUPING_ID function to identify whether a level has a value that should be included in the aggregation. A zero (0) indicates that the cell contains a value that should be included; a one (1) indicates that it is null or should not be included in the aggregation.

CALENDAR_YEAR_AR

DATE

Calendar year attribute.

END_OF_CAL_YEAR_AR

DATE

End date attribute for year level.

DAYS_IN_CAL_YEAR_AR

NUMBER

Time span attribute for year level.

CALENDAR_QUARTER_DESC_AR

VARCHAR2

Description attribute for quarter level.

END_OF_CAL_QUARTER_AR

DATE

End date attribute for quarter level.

DAYS_IN_CAL_QUARTER_AR

NUMBER

Time span attribute for quarter level.

CALENDAR_QUARTER_NUMBER_AR

NUMBER

Number of quarters.

CALENDAR_MONTH_DESC_AR

VARCHAR2

Description attribute for month level.

END_OF_CAL_MONTH_AR

DATE

End date attribute for month level.

DAYS_IN_CAL_MONTH_AR

NUMBER

Time span attribute for month level.

CALENDAR_MONTH_NAME_AR

VARCHAR2

Name attribute for month level.

CALENDAR_MONTH_NUMBER_AR

NUMBER

Number of months.

DAY_NUMBER_IN_WEEK_AR

NUMBER

Number of days in a week.

CALENDAR_WEEK_NUMBER_AR

NUMBER

Number of weeks.

DAY_NUMBER_IN_MONTH_AR

NUMBER

Number of days in a month.

DAY_NAME_AR

VARCHAR2

Name attribute for day level.

CALENDAR_YEAR

NUMBER

Year level of calendar hierarchy.

CALENDAR_QUARTER_DESC

VARCHAR2

Quarter level of calendar hierarchy.

CALENDAR_MONTH_DESC

VARCHAR2

Month level of calendar hierarchy.

TIME_ID

DATE

The primary key in the dimension table. The "leaf node" in which the lowest level of data is stored.