Show TOC

Object documentationSettings to Save Time Profile Aggregates in BW

 

This ASR profile stores aggregates containing various pieces of detailed information about the most important workload data, such as CPU time, the number of database changes, and response times. Unlike the other aggregates in which data for the ABAP statistics records is stored, this ggregate contains the most important data of the main statistics record.

This aggregate is used in the following applications:

Technical BW extractor and data destination data:

Extractor Name

WA (Statistical Records Secondary Extractor-0CCMSATPH)

Extractor Class

E2E_LUW_ECL_0CCMSATPH

Analysis View in ST03

Time Profile (see Display Time Profile)

Data Loader Profile

0CCMAW

Data target hourly data

DSO: 0CCMAWDH

InfoCubes: 0CCMAWDH1, 0CCMAWDH2

MultiCube: 0CCMBAWDH

Data target daily data

DSO: 0CCMAWDD

InfoCubes: 0CCMAWDD1, 0CCMAWDD2

MultiCube: 0CCMBAWDD

Data target weekly data

DSO: 0CCMAWWD

InfoCubes: 0CCMAWWD1,0CCMAWWD2

MultiCube: 0CCMBAWWD

Data target monthly data

DSO: 0CCMAWMD

InfoCubes: 0CCMAWMD1, 0CCMAWMD2

MultiCube: 0CCMBAWMD

MultiCube (All Resolutions)

0CCMAW

Profile ID (for configuration settings)

TIMES

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

HOURSLOT

Time Slot (Hours)

0SMD_TIHH

Time (hh)

MINSLOT

Time Slot (Minutes)

Not used in BW

TIMESLOT

Time Slot

0CCMATIRA

Time Range (Hour - Hour)

COMPONENT

Component

0CCMAPCO

Application Component

SUBAPPLICATION

Subapplication

0CCMAPSUB

Subapplication

APPLICATION

Application

0CCMAPAPPL

Application

DEVCLASS

Development Class

0CCMDEVCL

Development Class

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

Start of the navigation path Time Profile Next navigation step Time Profile Next navigation step Delete User Names End of the navigation path

TIMES_NO_USER

DIM_USER

User [0CCMUSRID]

User in Client [0CCMCLUSR]

Activate/deactivate job names

Start of the navigation path Time Profile Next navigation step Time Profile Next navigation step Delete Job Names End of the navigation path

TIMES_NO_JOBNAME

DIM_PROG

Job name [0CCMBJOBN]

Activate/deactivate component data

-

TIMES_NO_COMP

-

Development class [0CCMDEVCL]

Application component [0CCMAPCO]

Subapplication [0CCMAPSUB]

Application [0CCMAPAPPL]

Activate/deactivate program names

-

TIMES_NO_PROG

DIM_PROG

ABAP report [0CCMREPO]