BW Statistics

BW Statistics is a multi-cube named 0BWTC_C10. It contains six basic cubes, each of which stores specific system performance information (Screen 13.1).

SCREEN 13.1

graphics/13fig01.gif

BW Statistics works as follows:

  1. The raw statistical data are collected in database tables, such as RSDDSTAT, RSDDSTATWHM, and RSDDSTATAGGR.
  2. The raw statistical data are loaded into the basic cubes through the regular BW data load procedure.
  3. We run queries on the multi-cube to obtain BW performance information.

To specify the InfoCubes for which we want to collect statistical data, follow these steps:

Work Instructions

Step 1. In Administrator Workbench, select BW statistics for InfoCubes from the Tools menu.

 

 

SCREEN 13.2

graphics/13fig02.gif

Step 2. Select the InfoCubes for which we need to collect statistic data, and then click graphics/save1.gif.

 

 

SCREEN 13.3

graphics/13fig03.gif

Note

Check column OLAP to collect OLAP-related statistical data, such as the number of records retrieved from the database. Check column WHM (WareHouse Management) to collect ETTL and data management-related statistical data, such as the number of records loaded into an InfoCube.

Step 3. To delete statistical data from the database tables, such as RSDDSTAT, click graphics/popup.gif in Screen 13.3. In the pop-up window, specify a date and time period, and click graphics/dateandtime.gif. The statistical data in the specified date and time period will then be deleted.

 

 

SCREEN 13.4

graphics/13fig04.gif

To give you an idea of the performance information that BW Statistics can provide, Table 13.1 lists SAP-delivered queries for the multi-cube 0BWTC_C10.

Table 13.1. BW STATISTICS QUERIES

Query Characteristics Key Figures
Chart: Records OLAP per InfoCube

BW system

InfoCube

Overall time (OLAP)

Records, selected on database

Records, transferred from the database

Cells, transferred to front end

Formatting, transferred to front end

Number, read texts

Chart: Times OLAP per InfoCube

BW system

InfoCube

Time, initializing the OLAP processor

Time, OLAP processor

Time, read on the database

Time, front end

Time, authorization check

Time, read texts/master data

Mean time per query

BW system

User

InfoCube

Aggregate

Query (UID)

Number of navigations

Overall time (OLAP)

Mean overall time (OLAP)

Mean time, initializing OLAP

Mean time, OLAP processor

Mean time, reading database

Mean time, front end

Mean time, authorization check

Mean time, reading texts/master data

Mean number of records, selected on the database

Mean number of records, transferred from the database

Mean number of cells, transferred to front end

Mean number of formatting, transferred to front end

Mean number of texts, read

OLAP performance with/without reading on demand/aggregates

BW system

User

InfoCube

Query

OLAP read on/off Aggregate

Number of navigations

Overall time (OLAP)

Mean overall time (OLAP)

Mean time, initializing OLAP

Mean time, OLAP processor

Mean time, reading database

Mean time, front end

Mean time, authorization check

Mean time, reading texts/master data

Mean number of records, selected on the database

Mean number of records, transferred from the database

Mean number of cells, transferred to front end

Mean number of formatting, transferred to front end

Mean number of texts, read

Rolling up aggregates

BW system

InfoCube

User

Superior cube

Aggregate cube

Aggregate

Number of navigations

Last used (day)

Last used (time of day)

Run-time query

BW system

User

InfoCube

Query

Validity period category

Number of navigations

Mean overall time (OLAP)

Overall time (OLAP)

Time, initializing the OLAP processor

Time, OLAP processor

Time, read on the database

Time, front end

Time, authorization check

Time, read texts/master data

Overall number (OLAP)

Records, selected on database

Records, transferred from the database

Cells, transferred to front end

Formatting, transferred to front end

Number, read texts

Transfer method loading data

BW system

Automatically/manually posted

Calendar day

Source system

Transfer type (WHM)

Times and records (WHM)

InfoSource

InfoPackage ID

Transfer type WHM

Data request (SID)

Transfer type (WHM)

Time (procedure WHM)

Records (procedure WHM)

Use of InfoObjects

BW system

Characteristic value

Hierarchy

Aggregation level

InfoObject type

InfoObject

Number of navigations

Last used (day)

Last used (time of day)

Use of InfoObjects in navigation

BW system

Statistical data UID

Navigation step

Front-end session

Characteristic value

Hierarchy level

Hierarchy

Aggregation level

Aggregate

OLAP read on/off

InfoCube

User

Query

InfoObject

Frequency
Using aggregates (OLAP)

BW system

InfoCube

Aggregate

Number of navigations

Last used (day)

Last used (time of day)

Using hierarchies

BW system

InfoObject

Characteristic value

Aggregation level

InfoObject type

Hierarchy

Number of navigations

Last used (day)

Last used (time of day)

Using InfoCube OLAP/WHM

BW system

InfoCube

Time (OLAP/WHM)

Total load time (WHM)

Overall time (OLAP)

Records (OLAP/WHM)

Overall number (OLAP)

Total number of records (WHM)

Using InfoCubes

BW system

InfoCube

Number of navigations

Last used (day)

Last used (time of day)

Utilizing OLAP

BW system

User

Time

Calendar day

Validity period category

OLAP read on/off

Navigation step

Database read mode

Aggregate

UTC time stamp

InfoCube

Query

Number of navigations

Mean overall time (OLAP)

Overall time (OLAP)

Time, initializing OLAP processor

Time, OLAP processor

Time, read on the database

Time, front end

Time, authorization check

Time, read texts/master data

Overall number (OLAP)

Records, selected on database

Records, transferred from the database

Cells, transferred to front end

Formatting, transferred to front end

Number, read texts

Utilizing OLAP according to date Calendar day

Overall time (OLAP)

Overall number (OLAP)

Utilizing OLAP according to time of day Time

Overall time (OLAP)

Overall number (OLAP)

Utilizing OLAP per InfoCube

BW system

InfoCube

Number of navigations

Mean overall time (OLAP)

Overall time (OLAP)

Time, initializing OLAP processor

Time, OLAP processor

Time, read on the database

Time, front end

Time, authorization check

Time, read texts/master data

Overall number (OLAP)

Records, selected on database

Records, transferred from the database

Cells, transferred to front end

Formatting, transferred to front end

Number, read texts

Utilizing OLAP per query

BW system

Query

Number of navigations

Mean overall time (OLAP)

Overall time (OLAP)

Time, initializing OLAP processor

Time, OLAP processor

Time, read on the database

Time, front end

Time, authorization check

Time, read texts/master data

Overall number (OLAP)

Records, selected on database

Records, transferred from the database

Cells, transferred to front end

Formatting, transferred to front end

Number, read texts

Utilizing OLAP per user

BW system

User

Number of navigations

Mean overall time (OLAP)

Overall time (OLAP)

Time, initializing OLAP processor

Time, OLAP processor

Time, read on the database

Time, front end

Time, authorization check

Time, read texts/master data

Overall number (OLAP)

Records, selected on database

Records, transferred from the database

Cells, transferred to front end

Formatting, transferred to front end

Number, read texts

Utilizing WHM per InfoCube

BW system

InfoCube

Time (procedure WHM)

Records (procedure WHM)

Utilizing WHM per InfoSource

BW system

InfoSource

Time (procedure WHM)

Records (procedure WHM)

WHM usage per day Calendar day

Time (procedure WHM)

Records (procedure WHM)

WHM usage per hour Time

Time (procedure WHM)

Records (procedure WHM)

Screen 13.5 shows an example of the query Mean Time per Query.

SCREEN 13.5

graphics/13fig05.gif

Note

When Screen 13.5 was produced, BW Statistics still needed some work. For example, the query did not give query and aggregate information. Later patches fixed most of the bugs.

The following procedure shows how to install BW Statistics and load statistics data into the basic cubes.

Work Instructions

Step 1. Repeat the procedure in Section 10.4, "Installing Business Content Objects and Loading R/3 Data," to activate the multi-cube 0BWTC_C10 and its six basic cubes from Business Content.

 

 

SCREEN 13.6

graphics/13fig06.gif

Step 2. To load data, we must transfer and replicate DataSources.

On the same BW system, run transaction RSA5, enter TCT in the Application Component field, and then click graphics/clock.gif to continue.

 

 

SCREEN 13.7

graphics/13fig07.gif

Note

TCT (Technical ConTent) is the application component that contains all DataSources related to BW Statistics and BW meta-data.

Step 3. Select all DataSources, and then click graphics/transferdatasources.gif.

 

 

SCREEN 13.8

graphics/13fig08.gif

Step 4. The DataSources must be included in a development class to be transported to other BW systems. Here we create them as local objects.

Enter $TMP as the development class name and click graphics/save.gif, or simply click graphics/localobject1.gif to assign the object to $TMP. Click graphics/localobject1.gif to continue.

 

 

SCREEN 13.9

graphics/13fig09.gif

Step 5. Next, we need to replicate the DataSources.

In Administrator Workbench, right-click the BW system, and then select Replicate DataSources.

 

 

Note

The BW system is its own source system here.

SCREEN 13.10

graphics/13fig10.gif

Next, we load the statistical data into the basic cubes. The following steps provide an example of loading data into a basic cube, 0BWTC_C02.

Step 6. Right-click the InfoSource 0BWTC_C02, and then select Assign DataSource….

 

 

SCREEN 13.11

graphics/13fig11.gif

Step 7. Enter the BW system itself as the source system. Click graphics/continue.gif to continue.

 

 

SCREEN 13.12

graphics/13fig12.gif

Step 8. Select the corresponding DataSource. Click graphics/continue.gif to continue.

 

 

SCREEN 13.13

graphics/13fig13.gif

Step 9. Click graphics/yes1.gif to continue.

 

 

SCREEN 13.14

graphics/13fig14.gif

Step 10. Click graphics/activate.gif to activate the transfer rules, and then go back to Screen 13.16.

 

 

SCREEN 13.15

graphics/13fig15.gif

Step 11. Right-click the source system, and then select Create InfoPackage….

 

 

SCREEN 13.16

graphics/13fig16.gif

Step 12. Select the DataSource, enter a description, and then click graphics/continue.gif to continue.

 

 

SCREEN 13.17

graphics/13fig17.gif

Step 13. Click graphics/start1.gif to start the data load.

 

 

SCREEN 13.18

graphics/13fig18.gif

Result

BW Statistics has been activated and loaded with statistical data. You can now run any query against the multi-cube to obtain system performance information.

Besides BW Statistics, several other tools can help us monitor general system performance. We will discuss one of them next.





SAP Bw. A Step-By-Step Guide
Sap Bw: a Step By Step Guide for Bw 2.0
ISBN: B000LZM8CM
EAN: N/A
Year: 2002
Pages: 106
Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net