SAP ABAP Class CL_RSDB6_MDC_ADVISOR (Back-End Class for MDC Advisor)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-SYS-DB-DB6 (Application Component) BW DB2 Universal Database
     ⤷ RSDB6_7EHP1 (Package) Development EHP1 / BI 7.01 and BI 7.11

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_DB6_MDC_ADVISOR	DB6 MDC Advisor Backend Interface	20080219
2	Interface implementation (CLASS c. INTERFACES i_ref)	IF_DB6_MDC_ADVISOR_CONSTANTS	Constants for DB6 MDC Advisor	20080219

Properties

Class	CL_RSDB6_MDC_ADVISOR
Short Description	Back-End Class for MDC Advisor
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSDB6_7EHP1	Development EHP1 / BI 7.01 and BI 7.11
Created	20080218	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	DB6CE	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	RRSI	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
4	RSD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
5	RSDB6	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
6	RSDD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
7	RSDG	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
8	RSDRS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
9	RSDU	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_DB6_MDC_ADVISOR	☐	☐	DB6 MDC Advisor Backend Interface	20080219
2	IF_DB6_MDC_ADVISOR_CONSTANTS	☐	☐	Constants for DB6 MDC Advisor	20080219

Friends

Class CL_RSDB6_MDC_ADVISOR has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ADVISOR_SCHEMA	Constant	Private	☐	Type reference (TYPE)	STRING	'DB2'	The schema the advisor works in	20080219
2	MDC_ADV_RESULT	Instance attribute	Private	☐	Type reference (TYPE)	DB6_MDC_ADVISOR_RESULT_TAB		Advisor Results	20080219
3	MDC_DIMENSIONS	Instance attribute	Private	☐	Type reference (TYPE)	DB6_MDC_ADVISOR_DIMENSION_TAB		Advised MDC dimensions	20080219
4	PARTTIM_EXISTS	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		Existence of parttim column	20081229
5	USE_SAMPLE	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		Use sample of E fact table	20081229

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADAPT_WORKLOAD	Instance method	Private	Method	Adapt workload to sample name etc.	20080219
2	ADVISE_WORKLOAD	Instance method	Private	Method	Executes the MDC Advisor for a specific workload	20080219
3	ANALYZE_SAMPLE	Instance method	Private	Method	Updates statistics on sampled table and changed pages	20080219
4	BUILD_ERROR_NODE	Instance method	Private	Method	Create result entry for error cases	20080219
5	BUILD_UPD_SYSSTAT_COLDIST_STMT	Instance method	Private	Method	build update statement for table sysstat.coldist	20081229
6	BUILD_UPD_SYSSTAT_COL_STMT	Instance method	Private	Method	build update statement for catalog table sysstat.columns	20081229
7	CHECK_PACKAGE_DIMENSION	Instance method	Private	Method	Checks if package dimension is the only MDC dimension	20080219
8	CHECK_SAMPLE_SIZE	Instance method	Private	Method	Estimates size of the sample	20081229
9	CHOOSE_ADVISEMENT	Instance method	Private	Method	Choose right advisement when two fact tables exist	20080219
10	CONSTRUCTOR	Instance method	Public	Constructor	Constructor	20080219
11	CONVERT_TABLE_TO_STRING	Instance method	Private	Method	Convert table to string	20081229
12	COUNT_WORKLOAD	Instance method	Private	Method	Checks if workload is collected for the InfoProvider	20080219
13	CREATE_EFACT_SAMPLE	Instance method	Private	Method	Creates sample of the e fact table	20080219
14	CREATE_FFACT_SAMPLE	Instance method	Private	Method	Creates sample of f fact table	20080219
15	CREATE_IC_SAMPLE	Instance method	Private	Method	Creates samples of the fact table for the InfoCube	20080219
16	DELETE_ADVISEMENT	Instance method	Private	Method	DB6: Deletes entries in the advise_table table of the MDC ad	20080219
17	DELETE_ADV_RESULT	Instance method	Private	Method	Deletes result from the last advisement	20080219
18	DELETE_PARTTIM_PROPOSAL	Instance method	Private	Method	Deletes parttim proposal	20080219
19	DELETE_WORKLOAD	Instance method	Private	Method	Deletes entries in the advise_workload table	20080219
20	DROP_SAMPLE_TABLE	Instance method	Private	Method	Drops sampled tables	20080219
21	DROP_TEMPORARY_TABLES	Instance method	Private	Method	Drops temporary BW tables	20080219
22	EXECUTE_UPD_STATS_QUERY	Instance method	Private	Method	Executes update statement	20081229
23	EXISTS_PARTTIM_FIELD	Instance method	Private	Method	Checks if parttim field exists	20081229
24	FILL_EFACT_SAMPLE	Instance method	Private	Method	Fills sample of the e fact table	20080219
25	FILL_FFACT_SAMPLE	Instance method	Private	Method		20080219
26	FILL_PARTIM_COLUMN	Instance method	Private	Method	Fills parttim column of the e fact table with right value	20080219
27	GET_COLCARD_STATS_PART	Instance method	Private	Method	Get cardinality for parttim column	20081229
28	GET_DATASTORE_TYPE	Instance method	Private	Method	Returns the type of a DataStore object	20100323
29	GET_DS_SPACE_CHECK	Instance method	Private	Method	Executes space check for DataStore object	20080219
30	GET_IC_SPACE_CHECK	Instance method	Private	Method	Call space check for InfoCube	20080219
31	GET_ORIGINAL_STATISTICS	Instance method	Private	Method	Gets the statistics from the original table	20081229
32	GET_SAMPLE_FACT_TAB_NAME	Instance method	Private	Method	Names of the InfoCube shadow tables	20080219
33	GET_STMT_CLAUSEL_PART	Instance method	Private	Method	Gets clause of statement	20081229
34	IS_ERROR_CASE	Instance method	Private	Method	Checks if a MDC advisement exists for the InfoProvider	20080219
35	PARSE_DB2LOOK_OUTPUT	Instance method	Private	Method	Parse db2look output	20081229
36	SAVE_ADVISEMENT	Instance method	Private	Method	Save advisement	20080219
37	SET_DIMENSIONS	Instance method	Private	Method	Sets dimensions to keys	20080219
38	SET_INDEX_NAME	Instance method	Private	Method	Set name of sampled table index	20081229
39	TEST_PARTTIM_COLUMN	Instance method	Private	Method	Test parttim column as MDC Dimension	20080219

Events

Class CL_RSDB6_MDC_ADVISOR has no event.

Types

Class CL_RSDB6_MDC_ADVISOR has no local type.

Method Signatures

Method ADAPT_WORKLOAD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ADAPT_PARTIM	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Boolean	20080219
2	Importing	ORIG_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219
3	Importing	SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219
4	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method ADVISE_WORKLOAD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IP_TYPE	Call by reference	☐	Type reference (TYPE)	RS_TLOGO			20080219
2	Importing	MULTIPROV	Call by reference	☑	Type reference (TYPE)	RSD_INFOCUBE			20081229
3	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method ANALYZE_SAMPLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20081230
2	Importing	ORIG_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081230
3	Importing	SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method BUILD_ERROR_NODE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ERROR_CASE	Call by reference	☐	Type reference (TYPE)	STRING			20080219
2	Importing	MULTIPROV	Call by reference	☑	Type reference (TYPE)	RSD_INFOCUBE			20081229
3	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

Method BUILD_ERROR_NODE on class CL_RSDB6_MDC_ADVISOR has no exception.

Method BUILD_UPD_SYSSTAT_COLDIST_STMT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_QUERY	Call by reference	☐	Type reference (TYPE)	STRING			20081229
2	Importing	I_PARTTIM_COL	Call by reference	☐	Type reference (TYPE)	RSD_FIELDNM			20081229
3	Importing	I_SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081229
4	Importing	I_SEQNO	Call by reference	☐	Type reference (TYPE)	I			20081229
5	Importing	I_S_DISTRIBUTION	Call by reference	☐	Type reference (TYPE)	DB6_MDC_ADVISOR_DISTRIBUTION			20081229
6	Importing	I_TYPE	Call by reference	☐	Type reference (TYPE)	STRING			20081229

Method BUILD_UPD_SYSSTAT_COLDIST_STMT on class CL_RSDB6_MDC_ADVISOR has no exception.

Method BUILD_UPD_SYSSTAT_COL_STMT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_QUERY	Call by reference	☐	Type reference (TYPE)	STRING			20081229
2	Importing	I_COLCARD	Call by reference	☐	Type reference (TYPE)	I			20081229
3	Importing	I_HIGH2KEY	Call by reference	☐	Type reference (TYPE)	I			20081229
4	Importing	I_LOW2KEY	Call by reference	☐	Type reference (TYPE)	I			20081229
5	Importing	I_PARTTIM_COL	Call by reference	☐	Type reference (TYPE)	RSD_FIELDNM			20081229
6	Importing	I_SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081229

Method BUILD_UPD_SYSSTAT_COL_STMT on class CL_RSDB6_MDC_ADVISOR has no exception.

Method CHECK_PACKAGE_DIMENSION Signature

Method CHECK_PACKAGE_DIMENSION on class CL_RSDB6_MDC_ADVISOR has no parameter.
Method CHECK_PACKAGE_DIMENSION on class CL_RSDB6_MDC_ADVISOR has no exception.

Method CHECK_SAMPLE_SIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_USE_SAMPLE	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Boolean	20081229
2	Importing	I_FACT_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081229

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20081229

Method CHOOSE_ADVISEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method CONSTRUCTOR Signature

Method CONSTRUCTOR on class CL_RSDB6_MDC_ADVISOR has no parameter.
Method CONSTRUCTOR on class CL_RSDB6_MDC_ADVISOR has no exception.

Method CONVERT_TABLE_TO_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_LENGTH	Call by reference	☐	Type reference (TYPE)	I			20081229
2	Exporting	E_STMT	Call by reference	☐	Type reference (TYPE)	STRING			20081229
3	Importing	I_T_STMT	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20081229

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20081229

Method COUNT_WORKLOAD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	COUNT	Value transfer	☐	Type reference (TYPE)	I			20080219
2	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method CREATE_EFACT_SAMPLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20080219
2	Importing	ORIG_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219
3	Importing	SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method CREATE_FFACT_SAMPLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20080219
2	Importing	ORIG_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219
3	Importing	SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method CREATE_IC_SAMPLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20080219
2	Importing	MULTIPROV	Call by reference	☑	Type reference (TYPE)	RSD_INFOCUBE			20081230

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method DELETE_ADVISEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method DELETE_ADV_RESULT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INFOPROVIDER	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method DELETE_PARTTIM_PROPOSAL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method DELETE_WORKLOAD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method DROP_SAMPLE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method DROP_TEMPORARY_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method EXECUTE_UPD_STATS_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_QUERY	Call by reference	☐	Type reference (TYPE)	STRING			20081229

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20081229

Method EXISTS_PARTTIM_FIELD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_CALMONTH_COL	Call by reference	☐	Type reference (TYPE)	RSD_FIELDNM			20081229
2	Exporting	E_CALMONTH_EXISTS	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Boolean	20081229
3	Exporting	E_FISCPER_COL	Call by reference	☐	Type reference (TYPE)	RSD_FIELDNM			20081229
4	Exporting	E_FISCPER_EXISTS	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Boolean	20081229
5	Importing	I_INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20081229

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20081229

Method FILL_EFACT_SAMPLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20080219
2	Importing	ORIG_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219
3	Importing	SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219
4	Importing	USE_SAMPLE	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Boolean	20081230

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method FILL_FFACT_SAMPLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20080219
2	Importing	ORIG_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219
3	Importing	SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219
4	Importing	USE_SAMPLE	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Boolean	20081230

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method FILL_PARTIM_COLUMN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CON_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Datenbankverbindung	20081230
2	Importing	NCUMTIM	Call by reference	☐	Type reference (TYPE)	RSNCUMTIM		Ref. Time-Char. for Non-cums	20080219
3	Importing	PDIM_FIELDNM	Call by reference	☑	Type reference (TYPE)	STRING			20080219
4	Importing	PDIM_TABLNM	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20080219
5	Importing	SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219
6	Importing	STMT_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL Statement	20081230
7	Importing	TDIM_FIELDNM	Call by reference	☑	Type reference (TYPE)	RSD_FIELDNM			20080219
8	Importing	TDIM_TABLNM	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20080219
9	Importing	TREF_MAX	Call by reference	☐	Type reference (TYPE)	RSD_CHAVL			20080219
10	Importing	T_CHA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20081230
11	Importing	T_COB_PRO	Call by reference	☐	Type reference (TYPE)	RSD_T_COB_PRO		Properties InfoObjects (in Context InfoCube / ODS Object)	20080219
12	Importing	T_DIME	Call by reference	☑	Type reference (TYPE)	RSD_T_DIME		Dimensions Table	20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method GET_COLCARD_STATS_PART Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_COLCARD	Call by reference	☐	Type reference (TYPE)	I			20081229
2	Importing	I_PARTTIM_COL	Call by reference	☐	Type reference (TYPE)	RSD_FIELDNM			20081229
3	Importing	I_TIME_DIMENSION	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081229

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20081229

Method GET_DATASTORE_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ODSOBJECT	Call by reference	☐	Type reference (TYPE)	RSDODSOBJECT		DataStore Object	20100323
2	Returning	R_DATASTORE_TYPE	Value transfer	☐	Type reference (TYPE)	STRING			20100323

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20100323

Method GET_DS_SPACE_CHECK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DATASTORE	Call by reference	☐	Type reference (TYPE)	RSDODSOBJECT		ODS Object	20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method GET_IC_SPACE_CHECK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method GET_ORIGINAL_STATISTICS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_DB2LOOK_LIST	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20081229
2	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081229

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20081229

Method GET_SAMPLE_FACT_TAB_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	ETB_SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219
2	Changing	FTB_SAMPLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20080219

Method GET_SAMPLE_FACT_TAB_NAME on class CL_RSDB6_MDC_ADVISOR has no exception.

Method GET_STMT_CLAUSEL_PART Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_TIME_DIMENSION	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081229
2	Exporting	E_TIME_KEY	Call by reference	☐	Type reference (TYPE)	RSD_FIELDNM			20081229
3	Importing	I_INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20081229

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20081229

Method IS_ERROR_CASE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ERROR_CASE	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Boolean	20080219
2	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

Method IS_ERROR_CASE on class CL_RSDB6_MDC_ADVISOR has no exception.

Method PARSE_DB2LOOK_OUTPUT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DB2LOOK_LIST	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20081229
2	Importing	I_INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20081229
3	Importing	I_ORIG_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081229
4	Importing	I_SAMPLE_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081229

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20081229

Method SAVE_ADVISEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

Method SAVE_ADVISEMENT on class CL_RSDB6_MDC_ADVISOR has no exception.

Method SET_DIMENSIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IP_TYPE	Call by reference	☐	Type reference (TYPE)	RS_TLOGO			20080219
2	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20080219

Method SET_INDEX_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_QUERY	Call by reference	☐	Type reference (TYPE)	STRING			20081229
2	Importing	I_INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20081229
3	Importing	I_ORIG_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081229
4	Importing	I_SAMPLE_TAB	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20081229

#	Exception	Resumable	Description	Created on
1	CX_DB6_MDC_ADVISOR	☐	Error handling MDC Advisor Call	20081229

Method TEST_PARTTIM_COLUMN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20080219

Method TEST_PARTTIM_COLUMN on class CL_RSDB6_MDC_ADVISOR has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	711