SELECT cal_hier, period , period_parent, period_number, start_date , end_date from table ( olap_table(fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_period_tbl', 'CALL LMT_PERIOD_PRG(''PERIOD'')', 'DIMENSION cal_hier from CAL_PERIOD_TYPE_D DIMENSION period from time_d WITH HIERARCHY period_parent from CALENDAR_HIERARCHY_H ATTRIBUTE period_number from time_time_identifier_r ATTRIBUTE start_date from start_date_period_r ATTRIBUTE end_date from end_date_period_r'))
SELECT CAL_HIER
, PERIOD
, PERIOD_PARENT
, PERIOD_NUMBER
, START_DATE
, END_DATE
FROM TABLE ( OLAP_TABLE(FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PERIOD_TBL'
, 'CALL LMT_PERIOD_PRG(''PERIOD'')'
, 'DIMENSION CAL_HIER
FROM CAL_PERIOD_TYPE_D DIMENSION PERIOD
FROM TIME_D WITH HIERARCHY PERIOD_PARENT
FROM CALENDAR_HIERARCHY_H ATTRIBUTE PERIOD_NUMBER
FROM TIME_TIME_IDENTIFIER_R ATTRIBUTE START_DATE
FROM START_DATE_PERIOD_R ATTRIBUTE END_DATE
FROM END_DATE_PERIOD_R'))
|
|
|