日付階層 - 日本語キャプション付き

avt_calendar_hier_with_caption.sql

create or replace hierarchy avt_calendar_hier
    /* ALL_HIER_CLASS */
    classification caption value 'Date Dimension'
    classification caption value '日付ディメンジョン' language 'JAPANESE'
using avt_date_dim (
    cal_day child of
    cal_month child of
    cal_qtr child of
    cal_year
)
/* ALL_HIER_HIER_ATTR_CLASS */
hierarchical attributes (
    member_name 
        classification caption value 'Member Name'
        classification caption value 'メンバー名' language 'JAPANESE'
    , member_unique_name
        classification caption value 'Member Unique Name'
        classification caption value 'メンバー一意名' language 'JAPANESE'
    , member_caption
        classification caption value 'Member Caption'
        classification caption value 'メンバーの説明' language 'JAPANESE'
    , member_description
        classification caption value 'Member Description'
        classification caption value 'メンバーの詳細' language 'JAPANESE'
    , level_name
        classification caption value 'Level Name'
        classification caption value 'レベル名' language 'JAPANESE'
    , hier_order
        classification caption value 'Hier Order'
        classification caption value '階層の順序' language 'JAPANESE'
    , depth
        classification caption value 'Depth'
        classification caption value '深さ' language 'JAPANESE'
    , is_leaf
        classification caption value 'Is Leaf'
        classification caption value '末端' language 'JAPANESE'
    , parent_level_name
        classification caption value 'Parent Level Name'
        classification caption value '親レベル名' language 'JAPANESE'
    , parent_unique_name
        classification caption value 'Parent Unique Name'
        classification caption value '親一意名' language 'JAPANESE'
)
;