Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Any Performance Impact Of Partioning With Transactional InfoCubes?

Dear Colleagues,

I have a customer who is running BW 3.5 and is trying to determine if partitioning their transactional InfoCubes by Fiscal Year will impact performance with BPS?

They had thought they had read somewhere that partitioning of Transactional InfoCubes results in poor write performance?

Thank you in advance for any insights or feedback you may be able to provide.

-M

Tags:
Former Member
replied

Hello Michael,

it depends

1) Only the E-table is partitioned

-> No impact on saving plan data since that inserts only into F-table

2) Only partitioning by period/month

-> If you plan full year, the database has to read 12 partitions from the E-table which is a bit slower than without partitioning.

-> If you plan only a period/month at a time, it will be a bit faster.

3) MultiCubes / Multi Planning Area

-> If you want to combine InfoCubes, you typically need the same partitioning. So if your Actuals InfoCube is partitioned, also partition the Planning InfoCube.

Regards,

Marc

SAP NetWeaver RIG

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question