BW Statistics on Process Chain

[Former Member]

Dear Colleagues,

I am working on BI 7.0/SP07.

in BW system, there are several process chain(PC) running daily, but I am not able to capture the statistics on PC because Bw statistics may not be on for PC. I coulc not found where to activate statistics for PC. This can be done for Infpoprovider, Queries, DTP, workbooks and Template, but what to do for process Chain.

Please advice

Regards

Pankaj

[Former Member]

Hi,

No maintenance necessary for dataload statistics as of SAP NetWeaver BI 7.0, SPS9 , it means you need not explicitly switch on process chain and infopackage statistics, it will be by default on. Please refer the note 952191.

Hope this helps.

Best Regards,

Rajani

[Former Member]

For data-load statistics of process chains and processes:

use 0TCT_C21, 0TCT_VC21 and 0TCT_MC21

Data load statistics (Process Chains, DTP and InfoPackage) are collected automatically, no maintenance is necessary

For DTP settings not getting collected, please check out the note 966964.

For more Insights -

The new InfoProviders are:

For more highly aggregated query-runtime statistics:

0TCT_C01, 0TCT_VC01 and 0TCT_MC01

These replace InfoCube 0BWTC_C02.

For more detailed query-runtime statistics:

0TCT_C02, 0TCT_VC02 and 0TCT_MC02

These replace InfoCube 0BWTC_C02.

For data manager statistics:

0TCT_C03, 0TCT_VC03 and 0TCT_MC03

These replace InfoCube 0BWTC_C03.

For data-load statistics of process chains and processes:

0TCT_C21, 0TCT_VC21 and 0TCT_MC21

For data-load statistics of data transfer processes:

0TCT_C22, 0TCT_VC22 and 0TCT_MC22

For data-load statistics of InfoPackages:

0TCT_C23, 0TCT_VC23 and 0TCT_MC23

These deliver essentially the same information as InfoCube 0BWTC_C05 but they use the new InfoObjects. The remaining new InfoProviders also use the new InfoObjects.

For the current data-load status of process chains and processes:

0TCT_VC11 and 0TCT_MC11

For the current status of requests loaded to InfoProviders, InfoObjects that have been updated flexibly, and PSA tables:

0TCT_VC11 and 0TCT_MC11

Hope it Helps

Chetan

@CP..

[Former Member]

Thanks...just follow up 2 questions

1) My DTP statistics running fine, but process chain cubes 0TCT_C21 are not populating any data. Extract Checker RSA3 showing no data. What could be the reason?

2) the following infoproviders does not SAP standard Cubes as a datasource. rather Cubes does not exits in Standard Business content. Then how the Multiproder and Virtual cubes be used without datasource as Cube?

0TCT_VC11 and 0TCT_MC11

0TCT_VC12 and 0TCT_VC12

Please advice

Regards

Pankaj

[Former Member]

Please advice. I am really stucked into this since long time now. Your valuable inputs will really help me a lot.

Regards

Pankaj

[Former Member]

Hi Pankaj,

0TCT_C21 shows statistics for only successful process chains.

Just check whether in your system, are there any successful process chains.

Even then if teh statistics are not cmng, the reason could be bcz entries under the column ANALYZED_STATUS are not filled in table RSPCLOGCHAIN.

The CCMS dispatcher can be started in transaction RZ21:

Methods-> Method definitions ->Display -> Search method RSPC_CCMS_AGENT

-> Doubleclick

Re-save the collection method, this will check and evt. create the job.

1.Please create a test program attached in the note (Test_Report.zip).

2. Goto->Text Elements->Text Symbols-> Give the entry as Examine all

Chains that were Started After-> save->Activate.

3. Copy the below code into a report and run it by giving the date as 01.01.2003 in the selection screen:

TYPE-POOLS: rs.

SELECTION-SCREEN BEGIN OF LINE.

SELECTION-SCREEN COMMENT 1(60) text-001 FOR FIELD p_begin.

PARAMETERS: p_begin LIKE sy-datum.

SELECTION-SCREEN END OF LINE.

DATA: l_r_log TYPE REF TO cl_rspc_log,

l_s_log TYPE rspc_s_processlist,

l_t_chainattr TYPE rspc_t_chainattr,

l_s_chainattr TYPE rspcchainattr,

l_t_logchain TYPE TABLE OF rspclogchain,

l_s_logchain TYPE rspclogchain.

• ==== Get Logs to check ====

SELECT * FROM rspcchainattr INTO TABLE l_t_chainattr

WHERE objvers = 'A'

AND unwatched = rs_c_false.

LOOP AT l_t_chainattr INTO l_s_chainattr.

SELECT * FROM rspclogchain APPENDING TABLE l_t_logchain

WHERE chain_id = l_s_chainattr-chain_id

AND datum GE p_begin

AND analyzed_status eq ' '.

ENDLOOP.

DELETE l_t_logchain WHERE draw_type <> 'TRIGGER'.

LOOP AT l_t_logchain INTO l_s_logchain.

• ---- Get and refresh log ----

CREATE OBJECT l_r_log

EXPORTING

i_logid = l_s_logchain-log_id

EXCEPTIONS

no_log = 1

aborted = 2

OTHERS = 3.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

ENDLOOP.

Hope this helps.

Best Regards,

Rajani

[Former Member]

Hi,

You can use transaction RZ20 to see the process chains, also the Monitor Logs on the process chains in RSPC.