Taking forever to load data into BW for Fixed Assets

[Former Member]

Hi All, I am trying to load Fixed Asset data into BW, The load is taking a really long time, the year before it had taken 8 hours, now it runs forever and we have to kill the run.

Is there any clean up for tables that needs to be done in terms of logging or anything along those lines. Our Basis people are junior and don't really have a lot of experience with BW basis clean up in BW.

[MartinMaruskin · Accepted solution]

What is technical name of DataSource for Fixed Assets?

Is there any customer specific extension of this DataSource? If so try to see if there is a room to improve its performance.

[Former Member · Accepted solution]

The Datasources are 0FIAA_DS11, 0FIAA_DS12 & 0FIA_DS13,

No Customer specific extensions have been done, It has to generate a sid.

[Former Member · Accepted solution]

Martin,

I am responding for Andrew.

the Datasource names are 0FI_AA_11, 0FI_AA_12.

No customer extensions have occurred.

Thanks,

Erik

[former_member188011]

Hi Andrew:

Could you please provide more details? for example:

- Are you dealing with Full or Delta loads?

- Have you applied any SAP Note to solve the problem?

- How many records are you trying to load?

- Is the problem ocurring while loading the all three InfoCubes? (0FIAA_C11, 0FIAA_C12 and 0FIAA_C13)... or while loading just one of them in particular?

- Is the problem ocurring while loading the all three DSOs? (0FIA_DS11, 0FIA_DS12 and 0FIA_DS13)... or while loading just one of them in particular?

Regards,

Francisco Milán.

[Former Member]

Francisco,

I am the BI Analyst that works with Andrew. He has asked me to answer your questions.

-we are working with Delta loads.

-No SAP notes have been applied for this issue as i am aware. I have created a message for sap and they have not responded yet. i have called them this morning to ask for a review of the message.

-a total of 18000 fixed assets are being loaded.

-the problem is with 0FIAA_C13. the load is running forever. we have been successfull in running a sub set of data (only one company code which has 40 fixed assets. this took 15 minutes to run). therefore, the process works, it is just taking forever to run. my calculations have determined that it should take approx. 67 hours to load the data.

-the dso's are fine. the one dso 0FIA_DS13 does take longer, but it does finish. the problem is with the cube )FIAA_C13.

Thx,

Erik (for Andrews)