BPS read very slow - possibility to change SQL / execution plan for cube?

[Former Member]

Hello,

we run a job every night updating about half a milltion records in a cube with

2 Millionen records. This job runs more than three hours. The analysis shows

the the main bottle neck is the database query. We already tried to do the data into quite small data packages.

Compression is done, indexes are alright, database statistics are refreshed s.o.

Is there a possiblity to influence the sql query BPS sends to the database or influence the execution plan of the query to get a better performance?

Thank you.

Regards, Lars.

[Former Member]

Hi Lars,

not the answer your are asking for, but did you try "Partitioning of planning packages" using UPC_BUNDLE_EXECUTE_STEP? See note 546464 for details.

Regards Matthias