Stats for InfoPackage

[Former Member]

Hi,

We are NW 700 EHP1 SPS3.

Which table stores the stats for InfoPackage/Request times.

I want to know how long it took in earlier cases.

We are having some performance issue so I want to know the time for previous runs.

I tried the RSSELDONE but it dos not tell me the start and end time for a request.

Your immediate help will greately appreciated.

Regards,

Sume

[Former Member · Accepted solution]

Hi,

Please find some important tables in SAP-BI

https://wiki.sdn.sap.com/wiki/display/BI/ImportantTablesinSAPBI%28NW2004%29

Hope this is helpful.

Regards,

Krishna

[Former Member · Accepted solution]

Hi,

Check for the program /SSA/BWT where I find the runtimes of pc,dtp etc...

Hope this helps.

Thanks & Regards,

Vishnu

Edited by: Ravula Vishnu on Mar 10, 2011 4:59 AM

[Former Member]

Thank you all.

SC

[former_member222556]

Hi,

InfoPackage:

RSLDPIO Links datasource to infopackages

RSLDPIOT InfoPackage Text Description

RSLDPRULE ABAP source code for InfoPackages

RSLDPSEL Hardcoded selections in InfoPackages

RSMONICDP Contains the request-id number by data target

RSPAKPOS List of InfoPackage Groups / InfoPackages

RSSUBSTEP2EVID

https://wiki.sdn.sap.com/wiki/display/BI/ImportantTablesinSAPBI%28NW2004%29

Best Regards

Obaid

[Former Member]

Hi Sume ,

You can install BI technical content . you can monitor the infopackage statistics details from there .

If you have Bi Admin cockpit , check the infoprovider - 0TCT_MC23 .

You check the infopackage statistics in the table - RSDDSTATWHM.

Check these notes also :

a> 965386 - Activating the technical content for the BI admin cockpit

b> 1554490 - Missing entries for InfoPackage Statistics in Cube 0TCT_C23

Regards,

Lokesh

[Former Member]

Hi,

Use table RSBKREQUEST, if you have the request number. This table will give all the required information.

[shanthi_bhaskar]

check RSREQICODS and RSMONIFACT, RSSTATMANPART

[Former Member]

Hi,

I checked these and does not help.

I need for requests comming from source system, which is R3.

There is a table which stores the load time for each requests by date

Regards,

SC

[Former Member]

I think RSREQDONE is a good one.

Regards,

SC