[Home] [Help]
View: FPA_AW_QUARTER_ATTS_V
View Text
SELECT CAL_HIER
, QUARTER
, QUARTER_PARENT
, QUARTER_NUMBER
, START_DATE
FROM TABLE ( OLAP_TABLE(FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_QUARTER_TBL'
, 'CALL LMT_YEAR_PRG(''QUARTER'')'
, 'DIMENSION CAL_HIER
FROM CAL_PERIOD_TYPE_D DIMENSION QUARTER
FROM TIME_D WITH HIERARCHY QUARTER_PARENT
FROM CALENDAR_HIERARCHY_H ATTRIBUTE QUARTER_NUMBER
FROM TIME_TIME_IDENTIFIER_R ATTRIBUTE START_DATE
FROM START_DATE_QUARTER_R'))
Columns
Name |
CAL_HIER |
QUARTER |
QUARTER_PARENT |
QUARTER_NUMBER |
START_DATE |