Skip to Content
0

Partition of BPC cube on HANA

Jul 26, 2017 at 08:47 AM

49

avatar image
Former Member

I came across blogs/sap notes which says the maximum records which can be stored is 2 billion count per table/ partition. Over 2 billion count of records, the light optimization is failing.

a) Is there anyway, for partition of the BPC cube on HANA if it has already exceeded 2 billion count, without losing the data from the uncompressed sub index. ( round robin partition ).

b) How to do the partition of the BPC F- table ( Model FACT table) from HANA Studio ?

Regards

Srinivas

bpc
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Bilen Cekic Jul 26, 2017 at 09:35 AM
0

you can partition any table without losing data. my BPC sales model has 32 billion rows.

As i remember it was running "alter table xx partition by..." command, but i will check again , it was long time ago implemented.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 28, 2017 at 09:54 AM
0

when it was tried in our sandbox system, to do partition- As in BW cube ,by round robin technique, there will be 4 sub indexes.

Part id 1 has compressed data and part id 4 has uncompressed data. When it was partitioned, the uncompressed data was lost.

Regards

Srinivas

Share
10 |10000 characters needed characters left characters exceeded