Partition of BPC cube on HANA

[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

[Former Member]

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

[former_member185511]

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.