Skip to Content
avatar image
Former Member

Delete and create index step in BW 7.3

Hi Experts,

Please could you let me know why we don't have delete and create index step in PC for BW 7.3 which we generally do before and after cube load. We are using HANA as DB.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Feb 27, 2017 at 08:00 AM

    Because index are not needed anymore on a Hana DB (because of its columnar storage).

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 03, 2017 at 04:17 AM

    Thanks Frederic for your answer. Please could you tell me what primary keys it's going to consider in HANA db while creating columnar table for Infocube?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 03, 2017 at 01:22 PM

    I can't check on the database itself at the time, but there seems to be only one (non unique) key according to the DDIC definition of the table.

    There is only the DIMID of the package dimension as a key, the SID of the remaining characteristics of the cubes are just fields:

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 04, 2017 at 06:26 AM

    SAP BW 7.3 still have create and delete index step but not in the case of DB is HANA associated.

    Add comment
    10|10000 characters needed characters exceeded