Settings to Save External System Load Aggregates in BW

This ASR Profile contains aggregates with the workload that is created in a system due to actions from other systems.

This aggregate is used in the following applications:

Root Cause Analysis (see Root Cause Analysis Work Center)
SAP EarlyWatch Alert

Technical BW extractor and data destination data:

Extractor Name	WA (STATISTICAL RECORDS SECONDARY EXTRACTOR-0CCMSAEXE)
Extractor Class	E2E_LUW_ECL_0CCMSAEXE
Analysis View in ST03	External System Load (see Display External System Load)
Data Loader Profile	0CCMEX
Data target hourly data	DSO: 0CCMEXDH
	InfoCubes: 0CCMEXDH1, 0CCMEXDH2
	MultiCube: 0CCMAEXDH
Data target daily data	DSO: 0CCMEXDD
	InfoCubes: 0CCMEXDD1, 0CCMEXDD2
	MultiCube: 0CCMAEXDD
Data target weekly data	DSO: 0CCMEXWD
	InfoCubes: 0CCMEXWD1,0CCMEXWD2
	MultiCube: 0CCMAEXWD
Data target monthly data	DSO: 0CCMEXMD
	InfoCubes: 0CCMEXMD1, 0CCMEXMD2
	MultiCube: 0CCMAEXMD
MultiCube (All Resolutions)	0CCMAEX
Profile ID (for configuration settings)	EXSYS

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
I_SYSTEMID	Initial System		0CCMISYS	Initial System
I_SERVTYP	Initial Service	4	0CCMISRV	Initial Service
I_USERID	Initial User	2	0CCMIUSR	Initial User
I_ACTION	Initial Action	3	0CCMIACTI	Initial Action
I_ACTTYPE	Initial Action Type	5	0CCMIATYP	Initial Action Type
PRESYSID	System ID of Last Caller		0CCMPSID	System ID of Last Caller
TIMESLOT	Time Slot	1	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 hourly resolution	TREX/Inbound Queue/External Systems/Web Server Load from External Systems Remove Hours	EXSYS_WITH_HOURS	-	Time [0TIME] Time (hh) [0SMD_TIHH] Time (YYYYMMDDhhmm) [0SMD_TIHM]
Activate/deactivate user names	TREX/Inbound Queue/External Systems/Web Server Load from External Systems Remove User Names	EXSYS_NO_USER	DIM_USER	Initial User [0CCMIUSR]
Activate/deactivate action	TREX/Inbound Queue/External Systems/Web Server Load from External Systems Remove Actions	EXSYS_NO_ACTION	initial action	Initial Action [0CCMIACTI] Initial Action Type [0CCMIATYP]

Configuration setting

BI Diagnostic Center setting

Parameter Name

Dimension

Info objects affected

Activate/deactivate hourly resolution

Start of the navigation path TREX/Inbound Queue/External Systems/Web Server Next navigation step Load from External Systems Remove Hours End of the navigation path

EXSYS_WITH_HOURS

Time [0TIME]

Time (hh) [0SMD_TIHH]

Time (YYYYMMDDhhmm) [0SMD_TIHM]

Activate/deactivate user names

Start of the navigation path TREX/Inbound Queue/External Systems/Web Server Next navigation step Load from External Systems Remove User Names End of the navigation path

EXSYS_NO_USER

DIM_USER

Initial User [0CCMIUSR]

Activate/deactivate action

Start of the navigation path TREX/Inbound Queue/External Systems/Web Server Next navigation step Load from External Systems Remove Actions End of the navigation path

EXSYS_NO_ACTION

initial action

Initial Action [0CCMIACTI]

Initial Action Type [0CCMIATYP]