Demand Planning Job taking a very long time

[Former Member]

Hi,

We run our demand planning job once every month. The job is taking very very long time (around 60,000 secss) to complete. When I check the job log system passes some steps and just waits in some specific steps with the message

Step 059 started (program /SAPAPO/TS_BATCH_RUN, variant ZADAU_OFF1, user ID APP-BATCH)

SQL: 07.01.2008 09:54:28 APP-BATCH

TRUNCATE TABLE "/BI0/0600000002"

SQL-END: 07.01.2008 09:54:28 00:00:00

SQL: 07.01.2008 09:54:30 APP-BATCH

TRUNCATE TABLE "/BI0/0600000002"

SQL-END: 07.01.2008 09:54:30 00:00:00

Itwaits for aorung 2 hours with thie same repeated message before it goes to the next step. Not sure what is the issue. Our fiunctional guys have tried changing the macros, etc to optimize performance. But still same issue. Any quick help would be greatly appreciated.

Thanks in advance.

Regards,

PK

[Former Member]

PK,

Are you managing infocube keyfigures in the planning book? The issue looks to be of infocube performance.

rgds,

SB.

[Former Member]

Hi SB,

No we are not managing infocube keyfigures in the planning book. Appreciate your time.

Regards,