on 01-13-2013 2:02 PM
Partitioning of SAP HANA Optimized InfoCubes - strange approach from SAP BW developers.
No longer required or allowed (i.e. using a time characteristic to split the data into disjoint partitions)
•Four partitions are automatically created behind the scenes
•Partition 1 – non-compressed requests
•Partition 2 – compressed requests
•Partition 3 – reference points for inventory data
- Created regardless of inventory/non-cumulative key figures present
•Partition 4 – historic movements of inventory data
- Created regardless of inventory/non-cumulative key figures present
So we get only 2(!) partitioning - one for non-comp, second- for compressed requests.
That not enough. Why SAP do this...
Why we can't using physical partitioning pluses ? it's not logical. We must store billions of records in one partition ?
Is there any news that SAP change this strange situation with partitioning ?
BW must support all types of
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Note 1719282 - SAP POS DM 1.0 Partitioning Information
Manual partitioning))
I am still shore - partitioning - good and useful feature but in BW - very poor with it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mikhail,
actually I don't see it as critical as you seem to.
With BW 7.3 you can easily use semantic partitioning for InfoProviders including the in-memory-optimized InfoCube.
By that you can easily overcome the (current) 2 billion row limitation of compressed data.
Another thing is: the benefit of partition pruning is relatively smaller for HANA than for other databases, as all filtered columns are always used as filters (basically a "perfect" star query filter) on column level.
A much bigger advantage could be achieved if the partition scheme would allow for partitions containing data that is not used anymore could stay on disk instead of being loaded to RAM for query execution.
As HANA did not have the feature back when the in-memory optimized cube was designed, this is currently not available.
Again, with semantic partitioning you get this already today, too.
And as it is with most many implementation decisions: they are not 'logical or 'compulsory'.
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lars, you are like a child.
I am definally shore thats it will be good if we have ability to choose about phisical partitioning DSO or Cube or not.
About SPO
SPO - delta loading from SPO type of DSO not possible
About BW on HANA
Hana told itself - split, tables to big. Safe resources.
Dear Mikhail,
I think that you have already put your idea on the idea place and now you have to wait. Let's see if SAP will implement your proposal in SAP BW powered by HANA. However, if it is important for you that this will be implemented soon I think you should contact your account executive resp. send a developement request to SAP via SMP. This also not guarantee that this will be implemented, but I think this the best way.
Best Regards,
Marcel
Hi Mikhail,
There seems to be a workaround for the SPO Delta. Please refer to the following document on the same.
http://scn.sap.com/docs/DOC-25591
Regarding the physical partitioning of the tables, I am not completely sure if this should be done manually or let HANA handle it internally.
Also there has been a discussion somewhere that partitioning might have negative impact on the performance and it is advisable to keep the entire table content on the single blade itself.
I'd be very keen on understanding this in details from experts like Lars.
Regards,
Ravi
long time ago was created idea about this
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.