Skip to Content
0

Delete and create index step in BW 7.3

Feb 26, 2017 at 01:13 PM

138

avatar image

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.

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

4 Answers

Frédéric Cincet Feb 27, 2017 at 08:00 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Jinal patel Mar 03, 2017 at 04:17 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
Frédéric Cincet Mar 03, 2017 at 01:22 PM
0

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


capture.png (22.0 kB)
Share
10 |10000 characters needed characters left characters exceeded
Md Ekram Mar 04, 2017 at 06:26 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded