Skip to Content
avatar image
Former Member

Partition of BPC cube on HANA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 26, 2017 at 09:35 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 28, 2017 at 09:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded