<b>Update Time - Request Time = Total time taken to upload</b>
Is this formula right to calculate the total time taken to upload right from upload to activation of the request? If not then how can i get the extact time taken by already uploaded request.
My issue is:
I have already done with the upload of data but now i want to get extact time taken for this upload.
You dont need to calculate the Upload time for already finished loads. It is displayed directly on the screen.
Goto RSMON->Monitor->Click the Request (I assume its GREEN). On the right side, Header Tab, one of the Details (third from the top is <b>Valid. Per.</b>) The total time consumed is displayed in this detail (2 day(s) 1hr59mins)
To further see additional info, click its value and a small dialog box will appear.
There you will see the <i>Start Time and End Time</i>.
Hope I have helped, If I did, please grant points...
Total Time for Data loading is defined as
=Collection & Extraction time + Transfer Time + Staging Time + Transformation Time = Loadinh Time
For finding the Extraction time go to transaction RSMO
Click on specific process and than click on Detail Tab.
In the right hand side you will find a tree like structure.
Click on Extraction Start and see the time at the bottom
Click on Extraction end and see the time at the bottom.
Difference in these two timings will be the exact extraction time.
Hope this helps. If yes, please reward with points.