Settings to Save TREX Client Aggregates in BW

This ASR profile contains aggregates of the ABAP application server system load caused by TREX system calls.

It is used in the Root Cause Analysis Work Center.

Technical BW extractor and data destination data:

Extractor Name	WA (STATISTICAL RECORDS SECONDARY EXTRACTOR TREX CLIENT)
Extractor Class	E2E_LUW_ECL_0CCMTREXCLIENT
Analysis View in ST03	-
Data Loader Profile	0CCMATX
Data target hourly data	DSO: 0CCMATXDH
	InfoCubes: 0CCMTXDH1, 0CCMTXDH2
	MultiCube: 0CCMXTCDH
Data target daily data	DSO: 0CCMATXDD
	InfoCubes: 0CCMTXDD1, 0CCMTXDD2
	MultiCube: 0CCMXTCDD
Data target weekly data	DSO: 0CCMATXWD
	InfoCubes: 0CCMTXWD1,0CCMTXWD2
	MultiCube: 0CCMTXCWD
Data target monthly data	DSO: 0CCMATXMD
	InfoCubes: 0CCMTXMD1, 0CCMTXMD2
	MultiCube: 0CCMTXCMD
MultiCube (All Resolutions)	0CCMTXC
Profile ID (for configuration settings)	TREXC

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	2	0CCMUSRID	User Name
ORGUNITID	Organizational Unit		0CCM_ORGU	Organizational Unit
TIMESLOT	Time Slot	1	0CCMATIRA	Time Range (Hour - Hour)
REPORT	ABAP Report		0CCMREPO	ABAP Report
TCODE	Transaction		0CCMTCODE	Transaction
JOBNAME	Job Name	3	0CCMBJOBN	Job Name
COMPONENT	Component		0CCMAPCO	Application Component
DEVCLASS	Development Class		0CCMDEVCL	Development Class
CALL_TYPE	Call Type		0SMDTXCT	TREX Client Call Type
PROTOCOL	Protocol		0SMD_PRTY	Web Service Protocol Type
DESTINATION	Destination		0SMDTXDEST	TREX Destination
TREX_SID	TREX System ID		0SMDTXSID	TREX System ID
INDEX_ID	Index ID	4	0SMDTXIDX	TREX Index ID
FUNCNAME	Function Name	5	0SMDTXFNC	TREX Function Name

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 TREX Client Remove Hours	TREXC_WITH_HOURS	-	Time [0TIME] Time (hh) [0SMD_TIHH] Time (YYYYMMDDhhmm) [0SMD_TIHM]
Activate/deactivate user names	TREX/Inbound Queue/External Systems/Web Server TREX Client Remove User Names	TREXC_NO_USER	DIM_USER	User [0CCMUSRID]
Activate/deactivate index	TREX/Inbound Queue/External Systems/Web Server TREX Client Remove Index ID	TREXC_NO_INDEXID	CALL Details	TREX Index ID [0SMDTXIDX]
Activate/deactivate function names	TREX/Inbound Queue/External Systems/Web Server TREX Client Remove Function Names	TREXC_NO_FUNCNAME	CALL Detail	TREX function name [0SMDTXFNC]
Activate/deactivate job names	TREX/Inbound Queue/External Systems/Web Server TREX Client Remove Job Names	TREXC_NO_JOBNAME	DIM_PROG	Job name [0CCMBJOBN]
Activate/deactivate program names	-	TREXC_NO_PROG	DIM_PROG	ABAP report [0CCMREPO]