• 读取BPC维度数据


     1 DATA lo_version_mgr TYPE REF TO if_uja_dim_tdh_version_manager.
     2 DATA g_keydate      TYPE uj_date.
     3 DATA l_dateto       TYPE uj_date.
     4 DATA lo_md_query    TYPE REF TO if_uja_md_query.
     5 DATA ls_sel         TYPE uj0_s_sel.
     6 DATA lt_sel         TYPE uj0_t_sel.
     7 DATA lt_data        TYPE REF TO data.
     8 DATA lo_md_reader   TYPE REF TO if_uja_md_reader.
     9 
    10 
    11 CREATE OBJECT lo_version_mgr TYPE cl_ujaa_dimension_tdh_version
    12   EXPORTING
    13     i_appset_id      = 'ENVIRONMENTSHELL'
    14     i_dimension_name = 'ACCOUNT'.
    15 
    16 lo_version_mgr->get_current_version(
    17     EXPORTING
    18       i_current_date = g_keydate
    19     IMPORTING
    20       e_current_dateto = l_dateto
    21       ).
    22 
    23 " 获取主数据查询实例
    24 CALL METHOD cl_uja_bpc_admin_factory=>get_masterdata_query
    25   EXPORTING
    26     i_appset_id    = 'ENVIRONMENTSHELL'
    27     i_dimension_id = 'ACCOUNT'
    28   RECEIVING
    29     ro_result      = lo_md_query.
    30 
    31 " 查询条件
    32 CLEAR: ls_sel.
    33 ls_sel-dimension = 'ACCOUNT'.
    34 ls_sel-attribute = 'RATETYPE'.
    35 ls_sel-sign      = uj00_cs_range-sign_i.
    36 ls_sel-option    = uj00_cs_range-option_eq.
    37 ls_sel-low       = 'AVG'.
    38 APPEND ls_sel TO lt_sel.
    39 
    40 " 设置查询条件
    41 CALL METHOD lo_md_query->set_sel
    42   EXPORTING
    43     it_sel = lt_sel.
    44 
    45 CREATE OBJECT lo_md_reader TYPE cl_ujam_master_data_reader
    46   EXPORTING
    47     iv_appset    = 'ENVIRONMENTSHELL'
    48     iv_dimension = 'ACCOUNT'.
    49 
    50 " 读取数据
    51 CALL METHOD lo_md_reader->read
    52   EXPORTING
    53     io_read_opt = lo_md_query
    54   IMPORTING
    55     er_data     = lt_data.

    查询结果:

  • 相关阅读:
    android_handler(二)
    android_handler(一)
    java_synchronized 用法
    android surfaView surfaHolder video 播放
    《Java 8 实战》读书笔记
    Java面试宝典——基础部分
    Shell脚本---处理用户输入
    《Spring》(十八)---- 事务管理
    《Spring》(十七)---- JDBC访问数据
    《Spring》(十六)---- 基于Schema的AOP
  • 原文地址:https://www.cnblogs.com/jinyin/p/13329797.html
Copyright © 2020-2023  润新知