|
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.
|
