cancel
Showing results for 
Search instead for 
Did you mean: 

Invalid indexes

sap_cohort
Active Contributor
0 Kudos

Hi, Is there any way to get a report that might tell me which cubes in my system have invalid indexes? I don't want to have to check them one by one.

Thanks,

Ken Murray

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

In transaction RSRV you can find a check for infocube indexes under elementary test - database. You can gather multiple checks on the different cubes and save this in a test package which you can schedule or start via a process chain.

Kind regards,

Luc

sap_cohort
Active Contributor
0 Kudos

Hi, thanks for the reply. I am looking for a report that might help. I can't find myself looking for invalid indexes on a cube by cube basis. I have too many.

Anyone else know of a way?

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Kenneth

You have twoo options.

1) Go to DB02 and "Missing indexes", here you will see all invalid indexes for your system, (not only for cubes)

2) If you want to see and repair those invalid indexes, you have a "SAP_INFOCUBE_INDEXES_REPAIR" report, which repair your missing infocubes indexes.

Hope this help you