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

Which Cube contains the dataload timings

Posted on Apr 14, 2004 at 09:40 AM 7 Views

Hi,

We want to reschedule the dataloads on our BW (2.1C) system. At the moment we have dataloads scheduled for 3 regions (Europe, Asia, America). It will help a lot if there is an existing query (from the Technical Content) which we can use to see how long a dataload is taking.

Thanks for your advice

BW (SAP Business Warehouse) SAP Crystal Reports, version for Eclipse
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 28, 2004 at 04:46 AM

    There is a How To paper (service.sap.com/bw) with instructions for installing the BW Statistics cubes.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      May 05, 2004 at 05:13 PM

      > We do have already the BW Stats Cubes installed, I

      > can't find the query (if it's exists) which contains

      > the load times.

      You can write your own query against 0BWTC_C05. Use the KF's Records (proc. WHM) 0TCTMNREC0, Time (WHM Process) 0TCTMTIME, Frequency 0TCTSTAUIK, and the char Trans. type (WHM) 0TCTWHMACT.

  • author's profile photo Former Member
    Former Member
    Posted on Apr 30, 2004 at 01:33 AM

    The are several sheets in the delivered BW Statistics workbook related to Load (WHM). An example of the queries used is 0BWTC_C10_Q313.

    Note: You can also find information on load times using ST03... Select Expert Mode (near top left of screen) to see BW data, select the day, week or month, select Upload under Analysis Views. Options on the tab strips let you filter the source, or change the summarization etc..

    Add comment
    10|10000 characters needed characters exceeded