Skip to Content
author's profile photo Former Member
Former Member

BW Statistics on Process Chain

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2007 at 11:17 PM

    Hi,

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2007 at 01:04 AM

    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..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2007 at 09:17 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.