Any Performance Impact Of Partioning With Transactional InfoCubes?
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.
Marc Bernard replied
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.
SAP NetWeaver RIG