SAP ABAP Class CL_RSR_MDX_FLAT_QUERY (Flat Query)
Hierarchy
SAP_BW (Software Component) SAP Business Warehouse
   BW-BEX-OT (Application Component) OLAP Technology
     RSR_MDX_FLATTENING (Package) MDX: Flattening
Meta Relationship - Using
# Relationship type Using Short Description Created on
1 Inheritance (c INHERITING FROM c_ref)  CL_RSR_MDX_AXIS Axis 20010209
Meta Relationship - Used By
# Relationship type Used by Short Description Created on
1 Inheritance (c INHERITING FROM c_ref)  CL_RSR_MDX_FLATTENING Flattening Services for CL_RSR_MDX_COMMAND 20010227
2 Inheritance (c INHERITING FROM c_ref)  CL_RSR_MDX_FLAT_QUERY_STORED 20020410
Properties
Class CL_RSR_MDX_FLAT_QUERY  
Short Description Flat Query    
Super Class CL_RSR_MDX_AXIS Axis 
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package RSR_MDX_FLATTENING   MDX: Flattening 
Created 20010202   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 RRK0 Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
2 RRK1 Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
3 RRO01 Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
4 RRSI Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
5 RRT1 Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
6 RRX1 Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
7 RS Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
8 RSD Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
9 RSR Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
10 RZD1 Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
Class CL_RSR_MDX_FLAT_QUERY has no interface implemented.
Friends
# Friend Modeled only Created on Description
1 CL_RSR_MDX_COMMAND 20010220 Command Object for MDX Processing
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 C_ATR_KEY Constant Public Type reference (TYPE) BAPI6111SI2-SUBTYPE 'Q' Attribute as Key 20010424
2 C_ATR_TEXT Constant Public Type reference (TYPE) BAPI6111SI2-SUBTYPE 'P' Attribute as Text 20010424
3 C_DIM_KEY Constant Public Type reference (TYPE) BAPI6111SI2-SUBTYPE 'K' Characteristic as Key 20010424
4 C_DIM_TEXT Constant Public Type reference (TYPE) BAPI6111SI2-SUBTYPE 'D' Characteristic as Text 20010424
5 C_JUMP_KEY Constant Public Type reference (TYPE) BAPI6111SI2-SUBTYPE SPACE Technical Key for BBS 20010424
6 C_MES_CURR Constant Public Type reference (TYPE) BAPI6111SI2-SUBTYPE 'C' Currency of Key Figure 20010424
7 C_MES_UNIT Constant Public Type reference (TYPE) BAPI6111SI2-SUBTYPE 'U' Unit of Key Figure 20010424
8 C_MES_VALUE Constant Public Type reference (TYPE) BAPI6111SI2-SUBTYPE 'M' Key Figure Value 20010424
9 N_T_GROUPS Instance attribute Public Type reference (TYPE) RRT_T_STREAM_GROUPS Description of the Data Stream 20010222
10 N_T_SUBGROUPS Instance attribute Public Type reference (TYPE) RRT_T_STREAM_SUBGROUPS Description of the Data Stream 20010222
11 O_NUMOFCHAR Instance attribute Protected Type reference (TYPE) RS_BOOL Boolean 20030514
12 P_C_LAYOUT_TYPE_ATR Constant Private Type reference (TYPE) CHAR1 'A' Single-Character Indicator 20010220
13 P_C_LAYOUT_TYPE_CEL Constant Private Type reference (TYPE) CHAR1 'C' Single-Character Indicator 20010220
14 P_C_LAYOUT_TYPE_DIM Constant Private Type reference (TYPE) CHAR1 'D' Single-Character Indicator 20010220
15 P_INIT_PREQUERY Instance attribute Private Type reference (TYPE) RS_BOOL Boolean 20011026
16 P_LIMIT_PREQUERY Static Attribute Private Type reference (TYPE) RSROA_DF -1 DecFloat 20010220
17 P_R_OLAP Instance attribute Private Object reference (TYPE REF TO) IF_RSR_OLAP Calls for OLAP 20040604
18 P_R_S_SETXX_D Instance attribute Private Object reference (TYPE REF TO) DATA 20010220
19 P_R_S_SETXX_P Instance attribute Private Object reference (TYPE REF TO) DATA 20010220
20 P_R_TH_SETXX Instance attribute Private Object reference (TYPE REF TO) DATA 20020219
21 P_R_T_SETXX_D Instance attribute Private Object reference (TYPE REF TO) DATA 20010220
22 P_R_T_SETXX_P Instance attribute Private Object reference (TYPE REF TO) DATA 20010220
23 P_SETXX_TYPE Instance attribute Private Type reference (TYPE) RRK1_SETXX_TYPE 20010220
24 P_SX_REQ_KIDS Instance attribute Private Type reference (TYPE) RRK0_SX_KID_SELECTION 20010220
25 P_TABIX_D Instance attribute Private Type reference (TYPE) I 20010220
26 P_TABIX_P Instance attribute Private Type reference (TYPE) I 20010220
27 P_THX_FLAT_HIER Instance attribute Private Type reference (TYPE) TP_THX_FLAT_HIER 20010510
28 P_THX_SLICER Instance attribute Private Type reference (TYPE) RRK0_THX_SLICER 20010220
29 P_TH_CEL_INT Instance attribute Private Type reference (TYPE) RRX1_TH_CEL_INT 20010509
30 P_TH_DAT_N Instance attribute Private Type reference (TYPE) RRX1_TH_DAT_N Dat_n 20010222
31 P_TH_IOBJ_SORT Instance attribute Private Type reference (TYPE) TP_TH_IOBJ_SORT 20010220
32 P_TH_TEXTE Instance attribute Private Type reference (TYPE) RRO01_TH_TEXTE 20010509
33 P_TSX_FLAT_LAYOUT Instance attribute Private Type reference (TYPE) TP_TSX_FLAT_LAYOUT 20010220
34 P_T_ATR Instance attribute Private Type reference (TYPE) RRX1_T_ATR 20010509
35 P_T_DIM_INT Instance attribute Private Type reference (TYPE) RRX1_T_DIM_INT 20010509
Methods
# Method Level Visibility Method type Description Created on
1 APPEND_CHAVL Instance method Private Method 20010510
2 CHECK_CHAPRSNT Static method Private Method 20011101
3 GET_FLAT_DATA Instance method Public Method Flattening 20010227
4 GET_FLAT_DATA_BAPI Instance method Public Method Flattening 20080813
5 GET_FS_DATA Instance method Public Method Leading Columns for Flattening 20010227
6 GET_FS_DATA_BAPI Instance method Public Method Leading Columns for Flattening 20080813
7 GET_OLAP_DATA Instance method Private Method 20010222
8 GET_REPORT Instance method Private Method 20010221
9 GET_STREAM_DATA Instance method Public Method 20010209
10 GET_STREAM_INFO Instance method Public Method 20010221
11 GET_STREAM_INFO_INTERNAL Static method Private Method 20010221
12 GET_STREAM_INFO_STATIC Static method Public Method 20010221
13 GET_TXT_N Instance method Private Method 20010222
14 INIT_PREQUERY Instance method Private Method 20011026
15 LEN Instance method Protected Method 20020902
16 PRSNT_TO_GROUPS Static method Private Method 20010509
Events
Class CL_RSR_MDX_FLAT_QUERY has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 TO_NUMC3 Protected See coding 20030514
2 TP_NUMC3 Private See coding 20020902 tp_numc3(3) TYPE n
3 TP_SX_FLAT_HIER Private See coding 20010510 BEGIN OF tp_sx_flat_hier, chanmid TYPE rsd_sid, anc TYPE STANDARD TABLE OF tp_s_anc WITH DEFAULT KEY INITIAL SIZE 0, END OF tp_sx_flat_hier
4 TP_SX_FLAT_LAYOUT Private See coding 20010220 BEGIN OF tp_sx_flat_layout , flat_posit TYPE rszposn, type TYPE char1, num_cols TYPE i, dim_int TYPE rrx1_s_dim_int, cel_int TYPE rrx1_s_cel_int, atr TYPE rrx1_s_atr, int_format TYPE rs_bool, attrid TYPE rsd_sid, BEGIN OF hry, unam TYPE rrthryunam, caption TYPE rs_txtlg, lvl TYPE STANDARD TABLE OF tp_s_lvl WITH DEFAULT KEY INITIAL SIZE 0, END OF hry, END OF tp_sx_flat_layout
5 TP_S_ANC Private See coding 20010510 BEGIN OF tp_s_anc, chavl_ext TYPE rsd_chavl_ext, text TYPE rstxtxl, END OF tp_s_anc
6 TP_S_IOBJ_SORT Private See coding 20010220 BEGIN OF tp_s_iobj_sort , flat_posit TYPE rszposn, iobjnm TYPE rsd_iobjnm, chanmid TYPE rsd_sid, sid_index TYPE i, sid_index_h TYPE i, cardinality TYPE i, cumul_card TYPE rsroa_df, prequery TYPE rs_bool, hiesid TYPE rsd_sid, nosums TYPE rs_bool, cmpsta TYPE rsd_s_cob_pro-cmpsta, dimension TYPE rsd_s_cob_pro-dimension, keyflag TYPE rsd_s_cob_pro-keyflag, highcard TYPE rsd_s_cob_pro-highcard, END OF tp_s_iobj_sort
7 TP_S_LVL Private See coding 20010509 BEGIN OF tp_s_lvl, lvl_unam TYPE bapi6111si2-lvl_unam, lvl_number TYPE bapi6111si2-lvl_number, END OF tp_s_lvl
8 TP_THX_FLAT_HIER Private See coding 20010510 tp_thx_flat_hier TYPE HASHED TABLE OF tp_sx_flat_hier WITH UNIQUE KEY chanmid INITIAL SIZE 0
9 TP_TH_IOBJ_SORT Private See coding 20010221 tp_th_iobj_sort TYPE HASHED TABLE OF tp_s_iobj_sort WITH UNIQUE KEY iobjnm INITIAL SIZE 10
10 TP_TSX_FLAT_LAYOUT Private See coding 20010221 tp_tsx_flat_layout TYPE SORTED TABLE OF tp_sx_flat_layout WITH UNIQUE KEY flat_posit INITIAL SIZE 10
Method Signatures

Method APPEND_CHAVL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_STRING Call by reference Type reference (TYPE) STRING 20010510
2 Importing I_CHAVL_EXT Call by reference Type reference (TYPE) RSD_CHAVL_EXT 20010510
3 Importing I_PRSNT Call by reference Type reference (TYPE) RRX1_S_DIM-IOBJPRSNT RSD_C_CHAPR-KEY 20010510
4 Importing I_SEP Call by reference Type reference (TYPE) CHAR1 ',' Single-Character Indicator 20010510
5 Importing I_TEXT Call by reference Type reference (TYPE) RSTXTXL 20010510
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: General Error Class 20010510

Method CHECK_CHAPRSNT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_IOBJPRSNT Call by reference Type reference (TYPE) RSD_S_CHA-CHAPRSNT 20011101
2 Importing I_INFOCUBE Call by reference Type reference (TYPE) RSD_INFOCUBE 20011101
3 Importing I_IOBJNM Call by reference Type reference (TYPE) RSD_IOBJNM 20011101

Method CHECK_CHAPRSNT on class CL_RSR_MDX_FLAT_QUERY has no exception.

Method GET_FLAT_DATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_T_DATA Call by reference Type reference (TYPE) RSR_MDX_T_FS_DATA 20010227
2 Exporting E_T_HEADER Call by reference Type reference (TYPE) RSR_MDX_T_FS_DATA 20010227
3 Importing I_END_ROW Call by reference Type reference (TYPE) RRTUPLEID Ordinal Number of a Cell in a Data Set 20010227
4 Importing I_START_ROW Call by reference Type reference (TYPE) RRTUPLEID Ordinal Number of a Cell in a Data Set 20010227
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: General Error Class 20010227

Method GET_FLAT_DATA_BAPI Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_T_DATA Call by reference Type reference (TYPE) RRT1_T_FS_DATA 20080813
2 Exporting E_T_HEADER Call by reference Type reference (TYPE) RRT1_T_FS_DATA 20080813
3 Importing I_END_ROW Call by reference Type reference (TYPE) BAPI6111CD-CELL_ORDINAL Ordinal Number of a Cell in a Data Set 20080813
4 Importing I_START_ROW Call by reference Type reference (TYPE) BAPI6111CD-CELL_ORDINAL Ordinal Number of a Cell in a Data Set 20080813
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: General Error Class 20080813

Method GET_FS_DATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_T_DATA Call by reference Type reference (TYPE) RSR_MDX_T_FS_DATA 20010227
2 Importing I_END_ROW Call by reference Type reference (TYPE) RRTUPLEID Ordinal Number of a Cell in a Data Set 20010227
3 Importing I_INTERNAL Call by reference Type reference (TYPE) RS_BOOL RS_C_FALSE Boolean 20010302
4 Importing I_START_ROW Call by reference Type reference (TYPE) RRTUPLEID Ordinal Number of a Cell in a Data Set 20010227
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: General Error Class 20010227

Method GET_FS_DATA_BAPI Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_T_DATA Call by reference Type reference (TYPE) RRT1_T_FS_DATA 20080813
2 Importing I_END_ROW Call by reference Type reference (TYPE) BAPI6111CD-CELL_ORDINAL Ordinal Number of a Cell in a Data Set 20080813
3 Importing I_INTERNAL Call by reference Type reference (TYPE) RS_BOOL RS_C_FALSE Boolean 20080813
4 Importing I_START_ROW Call by reference Type reference (TYPE) BAPI6111CD-CELL_ORDINAL Ordinal Number of a Cell in a Data Set 20080813
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: General Error Class 20080813

Method GET_OLAP_DATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_TA_SETXX Call by reference Type reference (TYPE) ANY TABLE 20010222
2 Changing C_TH_DAT_N Call by reference Type reference (TYPE) RRX1_TH_DAT_N Dat_n 20010222
3 Importing I_NO_SUMS Call by reference Type reference (TYPE) RS_BOOL RS_C_FALSE Boolean 20011026
4 Importing I_PREQUERY Call by reference Type reference (TYPE) RS_BOOL Boolean 20010222
5 Importing I_S_SETXX Call by reference Type reference (TYPE) ANY 20010222
# Exception Resumable Description Created on
1 CX_RSR_MDX_EMPTY Empty Result 20010222
2 CX_RS_ERROR BW Error (with Syntax Check) 20010222

Method GET_REPORT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_TH_CEL_INT Call by reference Type reference (TYPE) RRX1_TH_CEL_INT 20010221
2 Exporting E_TH_TEXTE Call by reference Type reference (TYPE) RRO01_TH_TEXTE 20010221
3 Exporting E_T_ATR Call by reference Type reference (TYPE) RRX1_T_ATR 20010221
4 Exporting E_T_DIM_INT Call by reference Type reference (TYPE) RRX1_T_DIM_INT 20010221
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: General Error Class 20010221

Method GET_STREAM_DATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_STRING Call by reference Type reference (TYPE) STRING 20010209
2 Importing I_COUNT_AS_CHAR Call by reference Type reference (TYPE) RS_BOOL RS_C_FALSE Boolean 20020902
3 Importing I_NO_SUMS Call by reference Type reference (TYPE) RS_BOOL RS_C_FALSE Boolean 20010306
4 Importing I_NUM_ROWS Call by reference Type reference (TYPE) I Ordinal Number of a Cell in a Data Set 20010209
# Exception Resumable Description Created on
1 CX_RSR_MDX_EMPTY Empty Result 20010209
2 CX_RS_ERROR BW Error (with Syntax Check) 20010220

Method GET_STREAM_INFO Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_T_GROUPS Call by reference Type reference (TYPE) RRT_T_STREAM_GROUPS Description of the Data Stream 20010221
2 Exporting E_T_SUBGROUPS Call by reference Type reference (TYPE) RRT_T_STREAM_SUBGROUPS Description of the Subgroups of a Data Stream 20010221
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: General Error Class 20010221

Method GET_STREAM_INFO_INTERNAL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_TSX_FLAT_LAYOUT Call by reference Type reference (TYPE) TP_TSX_FLAT_LAYOUT 20010221
2 Exporting E_T_GROUPS Call by reference Type reference (TYPE) RRT_T_STREAM_GROUPS Description of the Data Stream 20010221
3 Exporting E_T_SUBGROUPS Call by reference Type reference (TYPE) RRT_T_STREAM_SUBGROUPS Description of the Subgroups of a Data Stream 20010221
4 Importing I_INFOCUBE Call by reference Type reference (TYPE) RSD_INFOCUBE 20010509
5 Importing I_TH_CEL_INT Call by reference Type reference (TYPE) RRX1_TH_CEL_INT 20010221
6 Importing I_TH_MAP Call by reference Type reference (TYPE) RZD1_TH_MAP 20020325
7 Importing I_TH_TEXTE Call by reference Type reference (TYPE) RRO01_TH_TEXTE 20010221
8 Importing I_T_ATR Call by reference Type reference (TYPE) RRX1_T_ATR 20010221
9 Importing I_T_DIM_INT Call by reference Type reference (TYPE) RRX1_T_DIM_INT 20010221
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: General Error Class 20010221

Method GET_STREAM_INFO_STATIC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_T_GROUPS Call by reference Type reference (TYPE) RRT_T_STREAM_GROUPS Description of the Data Stream 20010221
2 Exporting E_T_SUBGROUPS Call by reference Type reference (TYPE) RRT_T_STREAM_SUBGROUPS Description of the Subgroups of a Data Stream 20010221
3 Importing I_CUBE_NAM Call by reference Type reference (TYPE) BAPI6110CUB-CUBE_NAM Cube name 20010306
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: General Error Class 20010221

Method GET_TXT_N Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_NUM_ROWS Call by reference Type reference (TYPE) I 20020219
2 Importing I_TA_SETXX Call by reference Type reference (TYPE) ANY TABLE 20010222
# Exception Resumable Description Created on
1 CX_RS_ERROR BW Error (with Syntax Check) 20010222

Method INIT_PREQUERY Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_NO_SUMS Call by reference Type reference (TYPE) RS_BOOL Boolean 20011026
# Exception Resumable Description Created on
1 CX_RSR_MDX_EMPTY Empty Result 20011026
2 CX_RS_ERROR BW: General Error Class 20011026

Method LEN Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_ANY Call by reference Type reference (TYPE) ANY 20020902
2 Returning R_NUMC3 Value transfer Type reference (TYPE) TO_NUMC3 20020902

Method LEN on class CL_RSR_MDX_FLAT_QUERY has no exception.

Method PRSNT_TO_GROUPS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_NUM_COLS Call by reference Type reference (TYPE) I 20010509
2 Changing C_T_SUBGROUPS Call by reference Type reference (TYPE) RRT_T_STREAM_SUBGROUPS Description of the Subgroups of a Data Stream 20010509
3 Importing I_ATR Call by reference Type reference (TYPE) RS_BOOL RS_C_FALSE Boolean 20010509
4 Importing I_DATATP Call by reference Type reference (TYPE) RSD_S_COB_PRO-DATATP 'CHAR' Data type in ABAP Dictionary 20010509
5 Importing I_LVL_NUMBER Call by reference Type reference (TYPE) BAPI6111SI2-LVL_NUMBER Distance of a member from the root node (root = 0) 20010509
6 Importing I_LVL_UNAM Call by reference Type reference (TYPE) BAPI6111SI2-LVL_UNAM Unique name of a hierarchy level 20010509
7 Importing I_ORDINAL Call by reference Type reference (TYPE) BAPI6111SI1-ORDINAL General reference field for numbering 20010509
8 Importing I_OUTPUTLEN Call by reference Type reference (TYPE) RSD_S_COB_PRO-OUTPUTLEN 60 Output Length 20010509
9 Importing I_PRSNT Call by reference Type reference (TYPE) RRX1_S_DIM-IOBJPRSNT RSD_C_CHAPR-KEY 20010509
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: General Error Class 20010509
History
Last changed by/on SAP  20130531 
SAP Release Created in 30A