Settings to Save ESI Time Profile Aggregates in BW

This ASR profile contains aggregates with the system load caused by business objects.

Technical BW extractor and data destination data:

Extractor Name	WA (STATISTICAL RECORDS SECONDARY EXTRACTOR ESI TIME PROFIL)
Extractor Class	E2E_LUW_ECL_0CCMESFTIME
Analysis View in ST03	-
Data Loader Profile	0CCMES
Data target hourly data	DSO: 0CCMESDH
	InfoCubes: 0CCMESDH1, 0CCMESDH2
	MultiCube: 0CCMBESDH
Data target daily data	DSO: 0CCMESDD
	InfoCubes: 0CCMESDD1, 0CCMESDD2
	MultiCube: 0CCMBESDD
Data target weekly data	DSO: 0CCMESWD
	InfoCubes: 0CCMESWD1,0CCMESWD2
	MultiCube: 0CCMBESWD
Data target monthly data	DSO: 0CCMRSMD
	InfoCubes: 0CCMRSMD1, 0CCMRSMD2
	MultiCube: 0CCMBESMD
MultiCube (All Resolutions)	0CCMBES
Profile ID (for configuration settings)	ETP

Technical data for the profile fields and their recompression sequence (this information is particularly important to protect certain fields from possible recompression if you want to configure the ASR overload protection yourself – see Configuring ASR Overload Protection):

Field ID	Field Name	Recompression Sequence	ID of BW InfoObject	Name of BW InfoObject
TASKTYPE_TXT	Task Type		0CCMTTYPE	Task Type
MANDTNM	Client		0CCMMANDT	Client
ACCOUNT	User Name	1	0CCMUSRID	User Name
ORGUNITID	Organizational Unit		0CCM_ORGU	Organizational Unit
REPORT	ABAP Report		0CCMREPO	ABAP Report
TCODE	Transaction		0CCMTCODE	Transaction
JOBNAME	Job Name	2	0CCMBJOBN	Job Name
BO_NAME	Business Object Name		0CCMEBON	ESI Business Object Name
BO_NODE	Business Object Node		0CCMEBOK	ESI Business Object Node
BO_CORE_OP	Business Object Core Operation		0CCMEBOC	ESI Business Object Core Operation
BO_ACTION	Business Object Action		0CCMEBOA	ESI Business Object Action
CALL_LEVEL	Call Level		0CCMECLL	ESI Call Level
HTTPCONID	HTTP Connection ID		Not used in BW
HTTPDEST	HTTP Destination		Not used in BW
COMPONENT	Component		0CCMAPCO	Application Component
DEVCLASS	Development Class		0CCMDEVCL	Development Class
HOURSLOT	Time Slot (Hours)	4	0SMD_TIHH	Time (hh)
MINSLOT	Time Slot (Minutes)		Not used in BW
TIMESLOT	Time Slot	3	0CCMATIRA	Time Range (Hour - Hour)

This profile can configure the extractor, to reduce the BW data volume, in the following ways (Change ASR Aggregate Extraction Settings contains general extractor configuration information):

Configuration setting	BI Diagnostic Center setting	Parameter Name	Dimension	Info objects affected
Activate/deactivate user names	Time Profiles ESI Time Profile Remove User Names	ETP_NO_USER	DIM_USER	User [0CCMUSRID] User in Client [0CCMCLUSR]
Activate/deactivate hourly resolution	Time Profiles ESI Time Profile Remove Hours	ETP_NO_HOURS	-	Time [0TIME] Time (hh) [0SMD_TIHH] Time (YYYYMMDDhhmm) [0SMD_TIHM]
Activate/deactivate job names	Time Profiles ESI Time Profile Remove Job Names	ETP_NO_JOBNAME	DIM_PROG	Job name [0CCMBJOBN]
Activate/deactivate program names	-	ETP_NO_PROG	DIM_PROG	ABAP report [0CCMREPO]
Restrict call level	RFC Server/Client RFC Server Call Level	ETP_CALL_LEVEL	BO action	ESI Call Level [0CCMECLL]