分析ビュー - 日本語キャプション付き

avt_emp_sales_av_with_caption.sql

create or replace analytic view avt_emp_sales_av
    /* ALL_ANALYTIC_VIEW_CLASS */
    classification caption value 'Sales Analytic View'
    classification caption value '売上分析ビュー' language 'JAPANESE'
using avt_emp_sales
dimension by (
    /* ALL_ANALYTIC_VIEW_DIM_CLASS */
    avt_date_dim
        classification caption value 'Analytic View Date Dimension'
        classification caption value '分析ビュー・日付ディメンジョン' language 'JAPANESE'
        key date_wid references row_wid hierarchies (avt_calendar_hier default)
    , avt_emp_dim
        classification caption value 'Analytic View Manager Dimension'
        classification caption value '分析ビュー・マネージャー・ディメンジョン' language 'JAPANESE'
        key emp_wid  references row_wid hierarchies (avt_employee_hier default)
)
measures (
    /* ALL_ANALYTIC_VIEW_MEAS_CLASS */
    amount fact amount
        classification caption value 'Sum of Amount'
        classification caption value '売上合計' language 'JAPANESE'
    , avg_amount fact amount aggregate by avg
        classification caption value 'Avg of Amount'
        classification caption value '売上平均' language 'JAPANESE'
    , cnt_amount fact amount aggregate by count
        classification caption value 'Count of Amount'
        classification caption value '売上件数' language 'JAPANESE'
    , min_amount fact amount aggregate by min
        classification caption value 'Min of Amount'
        classification caption value '最小売上' language 'JAPANESE'
    , max_amount fact amount aggregate by max
        classification caption value 'Max of Amount'
        classification caption value '最大売上' language 'JAPANESE'
);