SAP ABAP Class CL_RSR_MDX_STMT_GEN_CUBE (Generator for Mdx Cmd out of Bex Queries)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSR_MDX_BASE (Package) MDX: Basis

Properties

Class	CL_RSR_MDX_STMT_GEN_CUBE
Short Description	Generator for Mdx Cmd out of Bex Queries
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSR_MDX_BASE	MDX: Basis
Created	20130617	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	RRO01	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSR_MDX_STMT_GEN_CUBE has no interface implemented.

Friends

Class CL_RSR_MDX_STMT_GEN_CUBE has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_CUBE_NAME	Instance attribute	Private	☐	Type reference (TYPE)	RRTCUBE		Cube name	20130617
2	P_QUERY_NAME	Instance attribute	Private	☐	Type reference (TYPE)	RSZCOMPID		Name (ID) of a reporting component	20130617
3	P_R_OLAP	Instance attribute	Private	☐	Object reference (TYPE REF TO)	IF_RSR_OLAP			20130617
4	P_SX_REPORT	Instance attribute	Private	☐	Type reference (TYPE)	RRO01_SX_REPORT			20130617
5	P_S_REPKEY	Instance attribute	Private	☐	Type reference (TYPE)	RSZCOMPKEY			20130702

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20130617
2	GENERATE	Instance method	Public	Method	Generate MDX Command	20130617
3	GET_CAN_BE_SHOWN_MEM	Instance method	Private	Method	Get can be shown members	20130627
4	GET_CONDITIONS	Instance method	Private	Method	Get Conditions for keyfigures	20130701
5	GET_DEFAULT_FILTER	Instance method	Private	Method	Get set name and defintion for default filter	20130627
6	GET_DIMENSIONS	Instance method	Private	Method	get dimensions on axes	20130626
7	GET_MDX_STATEMENT	Instance method	Private	Method	build the complete statement	20130627
8	GET_PROPERTIES	Instance method	Private	Method	get dimenstion properties	20130627
9	GET_SORTING	Instance method	Private	Method	Get hierarchy name and check sort settings	20130626
10	RESHAPE_DIM_TABLE	Instance method	Private	Method	Reshape dim table	20130627

Events

Class CL_RSR_MDX_STMT_GEN_CUBE has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TP_S_CONSET	Private	See coding			20130708	BEGIN OF tp_s_conset, set_name TYPE String, set_def TYPE String, axis TYPE RRXAXIS, END OF tp_s_conset
2	TP_S_DEFAULT_FILTER	Private	See coding			20130702	BEGIN OF tp_s_default_filter, set_name TYPE String, set_def TYPE String, END OF tp_s_default_filter
3	TP_S_HRY_MEMBER	Private	See coding			20130703	BEGIN OF tp_s_hry_member, mem_name TYPE String, mem_def TYPE String, axis TYPE RRXAXIS, END OF tp_s_hry_member
4	TP_S_STRING_AXIS	Private	See coding			20130702	BEGIN OF tp_s_string_axis, statement TYPE string, axis TYPE RRXAXIS, posit TYPE rrxswahl , eltuid TYPE sysuuid_25, END OF tp_s_string_axis
5	TP_T_CONSET	Private	See coding			20130708	tp_t_conset TYPE STANDARD TABLE OF tp_s_conset WITH DEFAULT KEY INITIAL SIZE 0
6	TP_T_DEFAULT_FILTER	Private	See coding			20130702	tp_t_default_filter TYPE STANDARD TABLE OF tp_s_default_filter WITH DEFAULT KEY INITIAL SIZE 0
7	TP_T_HRY_MEMBER	Private	See coding			20130703	tp_t_hry_member TYPE STANDARD TABLE OF tp_s_hry_member WITH DEFAULT KEY INITIAL SIZE 0
8	TP_T_STRING_AXIS	Private	See coding			20130702	tp_t_string_axis TYPE STANDARD TABLE OF tp_s_string_axis WITH DEFAULT KEY INITIAL SIZE 0

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CUBE_NAME	Call by reference	☐	Type reference (TYPE)	RRTCUBE		Cube name	20130617

#	Exception	Resumable	Description	Created on
1	CX_RSR_MDX_CUBE_NOT_FOUND	☐	Query exists	20130627

Method GENERATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_MDX_COMMAND	Value transfer	☐	Type reference (TYPE)	STRING		MDX Command	20130617

Method GENERATE on class CL_RSR_MDX_STMT_GEN_CUBE has no exception.

Method GET_CAN_BE_SHOWN_MEM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_CAN_BE_SHOWN_MEM	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130627
2	Importing	I_T_STARTLIST_DIM	Call by reference	☐	Type reference (TYPE)	RRO01_T_DIM			20130627
3	Importing	I_T_STARTLIST_MEM	Call by reference	☐	Type reference (TYPE)	RRO01_T_MEM			20130627

Method GET_CAN_BE_SHOWN_MEM on class CL_RSR_MDX_STMT_GEN_CUBE has no exception.

Method GET_CONDITIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_CONDITIONS	Call by reference	☐	Type reference (TYPE)	TP_T_CONSET		String table	20130701
2	Importing	I_COLUMNS	Call by reference	☐	Type reference (TYPE)	STRING			20130708
3	Importing	I_ROWS	Call by reference	☐	Type reference (TYPE)	STRING			20130708
4	Importing	I_T_STARTLIST_CON	Call by reference	☐	Type reference (TYPE)	RRO01_T_CON			20130702
5	Importing	I_T_STARTLIST_DIM	Call by reference	☐	Type reference (TYPE)	RRO01_T_DIM			20130708
6	Importing	I_T_STARTLIST_FAC	Call by reference	☐	Type reference (TYPE)	RRO01_T_FAC			20130701

Method GET_CONDITIONS on class CL_RSR_MDX_STMT_GEN_CUBE has no exception.

Method GET_DEFAULT_FILTER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DEFAULT_FILTER	Call by reference	☐	Type reference (TYPE)	TP_T_DEFAULT_FILTER			20130627
2	Importing	I_T_STARTLIST_CON	Call by reference	☐	Type reference (TYPE)	RRO01_T_CON			20130701
3	Importing	I_T_STARTLIST_FAC	Call by reference	☐	Type reference (TYPE)	RRO01_T_FAC			20130627

Method GET_DEFAULT_FILTER on class CL_RSR_MDX_STMT_GEN_CUBE has no exception.

Method GET_DIMENSIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DIM_X	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130626
2	Exporting	E_T_DIM_Y	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130626
3	Importing	I_T_CAN_BE_SHOWN_MEM	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130627
4	Importing	I_T_SORTING	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130626
5	Importing	I_T_STARTLIST_DIM	Call by reference	☐	Type reference (TYPE)	RRO01_T_DIM			20130627

Method GET_DIMENSIONS on class CL_RSR_MDX_STMT_GEN_CUBE has no exception.

Method GET_MDX_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_STMT	Call by reference	☐	Type reference (TYPE)	STRING			20130702
2	Importing	I_T_DEFAULT_FILTER	Call by reference	☐	Type reference (TYPE)	TP_T_DEFAULT_FILTER			20130627
3	Importing	I_T_DIM_X	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130627
4	Importing	I_T_DIM_Y	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130627
5	Importing	I_T_HIER_SUM	Call by reference	☐	Type reference (TYPE)	TP_T_HRY_MEMBER			20130703
6	Importing	I_T_PROPERTIES	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130627

Method GET_MDX_STATEMENT on class CL_RSR_MDX_STMT_GEN_CUBE has no exception.

Method GET_PROPERTIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_PROPERTIES	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130627
2	Importing	I_T_STARTLIST_ATR	Call by reference	☐	Type reference (TYPE)	RRO01_T_ATR			20130627
3	Importing	I_T_STARTLIST_DIM	Call by reference	☐	Type reference (TYPE)	RRO01_T_DIM			20130627

Method GET_PROPERTIES on class CL_RSR_MDX_STMT_GEN_CUBE has no exception.

Method GET_SORTING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_HIER_SUM	Call by reference	☐	Type reference (TYPE)	TP_T_HRY_MEMBER			20130703
2	Exporting	E_T_SORTING	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130626
3	Importing	I_T_STARTLIST_DIM	Call by reference	☐	Type reference (TYPE)	RRO01_T_DIM			20130626

Method GET_SORTING on class CL_RSR_MDX_STMT_GEN_CUBE has no exception.

Method RESHAPE_DIM_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_DIM	Call by reference	☐	Type reference (TYPE)	TP_T_STRING_AXIS			20130627
2	Importing	I_T_STARTLIST_DIM	Call by reference	☐	Type reference (TYPE)	RRO01_T_DIM			20130627

Method RESHAPE_DIM_TABLE on class CL_RSR_MDX_STMT_GEN_CUBE has no exception.

History

Last changed by/on	SAP	20140121
SAP Release Created in	740