on 04-27-2006 1:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Haven't tried on 3.5. I did run into some system problems when I tried to partition a transactional cube on 3.1 (Oracle).
The partitioning only impacts the E fact table, so they must be compressing their InfoCube for the partitioning to even come into play.
Can only partition on FISCPER or CALMONTH.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.