Missing secondary indexes

[Former Member]

Hello All,

In transaction db02 I see that I have missing secondary indexes. The problem is I don't know to which InfoCubes these belong so I cannot go there to try and repair them on the performance tab. Below are some missing secondary indexes as seen in transaction db02.

/BIC/E100069-120

/BIC/E100069-110

/BIC/F200068-010

Please direct me as to which InfoCubes to go to and how you determined this.

Thank you in advance,

Keith

[edwin_harpino · Accepted solution]

hi Keith,

it's aggregate (fact table E and F)

100069 and 200068

to get infocube name, go to table RSDDAGGRDIR

fill in AGGRCUBE = 100069

INFOCUBE is the infocube name

hope this helps.

[Former Member]

Hi,

at DB02 mark your index and press buttn: Display definition, maybe it helps a bit

/manfred