Infocube/DSO/Process Chain - data load statistics

[Former Member]

Hi,

I'm trying to look for the total data records extracted  per day and extraction time from ECC into a particular DSO or infocube.

Also the start and end times of the process chain which executes this infocube.

We are trying to do some performance analysis for the volume testing.So ,we can compare the data volume loaded vs the execution times.

I was able to look under the infocube/dso -> right click -> MANAGE -> transfered records/update records , request time,update time

For this, do I need to look at the full update details or the delta update details?

Also under a particular process chain,-> right click on First step ->Display messages to get the start time of the job

Right Click on last Step ->Display mseeages to get the job finished time.

I just wanted to get your thoughts on this, if this is the correct way to get the total records extracted and extraction times along with process chain times.

Thank you.

[Former Member]

Hello,

For complerte process chain analysis, you can use program /SSA/BWT in SE38 Tcode.This will give you complete details of all the steps with just 1 screen interface. There is no need to go to manage and check and close again.

Hope it helps you. CHeers !!

[KodandaPani_KV]

Hi,

Based on the time char like 0calmonth, 0calday you will check the data.

check the jobs in SM37 at ECC and BI system.

select the specific jobs it will give clear picture. how much taking time form source to target.

you use the DB02 and STO5 and RSTT you can do performance analysis.

manage screen you will get either full or delta and which one source system and which type of data source.

Process chains have it will automate the PRD system

Thanks,

Phani.

[Former Member]

Hi,

For example if i'm looking for details around one Inventory infocube/DSO ,then will I get accurate information from the MANAGE Screen?

And looking at the process chain that is executing this infocube ,will give me the accurate start and end times of the job (which includes the stats...)

Please calrify.

Thank you.

[Former Member]

Hi,

Also can you please send me the steps to verify the extraction times in ECC .

Thank you.

[KodandaPani_KV]

Hi,

yes, you will get the information while seeing the manage screen of every target.

see the my first replay.

coming to PC how much time taking the each PC.

check the job logs- it will give start time and end time.

how much time taking at IPK, DTP, dso loading, dso activation, dso to cube it will check all things.

Thanks,

Phani.