マネージャー・ディメンジョン - 日本語キャプション付き

avt_emp_dim_with_caption.sql

create or replace attribute dimension avt_emp_dim
    /* ALL_ATTRIBUTE_DIM_CLASS */
    classification caption value 'Manager Dimension'
    classification caption value 'マネージャー・ディメンジョン' language 'JAPANESE'
using avt_employees
attributes(
    /* ALL_ATTRIBUTE_DIM_ATTR_CLASS  - ALL_ANALYTIC_VIEW_ATTR_CLASS */
    row_wid
    , empno
        classification caption value 'Employee'
        classification caption value '従業員' language 'JAPANESE'
    , lvl1_mgr
        classification caption value 'Level 1'
        classification caption value '社長' language 'JAPANESE'
    , lvl2_mgr
        classification caption value 'Level 2'
        classification caption value '部長' language 'JAPANESE'
    , lvl3_mgr
        classification caption value 'Level 3'
        classification caption value '課長' language 'JAPANESE'
)
/* ALL_ATTRIBUTE_DIM_LVL_CLASS - ALL_ANALYTIC_VIEW_LEVEL_CLASS */
level emp
    classification caption value 'Employee Level'
    classification caption value '従業員レベル' language 'JAPANESE'
    key row_wid  member name to_char(empno) order by empno    determines(lvl3_mgr)
level lvl3_mgr
    classification caption value 'Level 3 Manager Level'
    classification caption value '課長レベル' language 'JAPANESE'
    key lvl3_mgr member name lvl3_mgr       order by lvl3_mgr determines(lvl2_mgr)
level lvl2_mgr 
    classification caption value 'Level 2 Manager Level'
    classification caption value '部長ベル' language 'JAPANESE'
    key lvl2_mgr member name lvl2_mgr       order by lvl2_mgr determines(lvl1_mgr)
level lvl1_mgr 
    classification caption value 'Level 1 Manager Level'
    classification caption value '社長レベル' language 'JAPANESE'
    key lvl1_mgr member name lvl1_mgr       order by lvl1_mgr
all member name 'Total'
;