DTP upload performance problem into infocube

[Former Member]

Dear All,

I have an info cube where it is having issue with the upload using DTP and it is taking more time for loading the data even there is not much data.say 10-50 records takes 30 mins.

Even the further updates to other infocubes is also very slow from this cube.

Could you please let me know what will be this issue as it is urgent for me to upload the data.Please suggest your inputs

Regards

Satya

[former_member416151]

Hello,

If the issue still could not be resolved, please have a look at th recently released guided answer for DTP perforamance:
Guided Answers: Data Transfer Process (DTP) performance/memory issues

Best Regards,
Jiandong

[Former Member]

Hi Satya,

1. Cube Index deletion prior to loading improves the performance.

2. Check if there is any start routine or end routine in the transformation to the cube and make sure the routine is optimised.

3. Check with Basis team whether sufficient BGD processes are available.

Regards,

Senthil.

[former_member1327384]

Hi Satya,

Please have a check with your dimensions. If it has crossed more 10-20% compared to your Fact Table, then try analyzing to make a Line Item Dimension.

Goto SE37--->RSDU_INFOCUBE_TABLE_SIZES and give the cube name and check for the entries and check for the %

Regards,

Syed

[jagadeesh_mandepudi2]

Hi

Normally if loading performance is very bad we need to check following

1. Check for cube indexes try to delete indexes and load the data and again create indexes.

2. Still taking time then ask basis team for any drop indexes for particularly this cube if yes try to clear those.

3. Also check for other datatargets also u taking same time if yes then issue because of system perofrmance and lack of background processes.

4. you also try to check DTP jobs to '1', by default it was '3'.

5.Also if there any custome routines in transformations and lookup to master data or other DSO's, try to use optimistic code for those cases.

if anything else let me know.

Jagadeesh

[sbastien_francal2]

Hello Satya,

This could be due to missing indexes and/or obsolete stats. Make sure to drop the stats before loading data in the cube and recreate them once the load completed, and make sure to refresh the db stats for that cube afterwards (that should increase the reading speed, which should improve the uploading time from that cube).

Best regards,

Seb

[Former Member]

Hi

Please look into your transformation and check if you have any routines.

Goto DTP monitor --> Details, here check for each data package which step is taking long time(give the screenshot of that).

in same DTP monitor, click on job overview and check job log. here check when job has started and finished.

Make sure you have enough background processes available when you start DTP

Regards,

Venkatesh

[Former Member]

Hi Satya,

Are you facing this issue with the other loads also?
If Yes, might be performance issue. Check the status of the job in SM37 and also for TRFC's.
If No, let us know at which step it is taking time.

Regards
Sai

[sukdev_koner2]

There are many possibilities:

1. You have to check the transformation between this Cube to other Cube/DSO. Is there any start routine, end routine or Expert routine? That code needs to be analyzed.

Loop inside Loop and SELECT * should be avoided.

2. Check the free available dialog processes to upload the data. This process needs to be increased in SM50/ SM51.

3. This generally happenes due to code issue. Please give me other details to investigate more to help you.

Please feel free to ask any question.