Issue with index creation of an infocube.

[Former Member]

Hi,

I have an issue with creation of index's for a info cube in SAP BI. when i create index's using

a process chain for the cube it is getting failed in the process chain. when i try to check the index's for this

cube manual the following below massage is shown.

*The recalculation can take some time (depending on data volume)*

*The traffic light status is not up to date during this time*

Even i tried to repair the index's using the standard program "SAP_INFOCUBE_INDEXES_REPAIR" in SE38

to repair the index so it is leading to dump in this case.

Dear experts with the above issue please suggest.

Regards,

Prasad.

[Former Member · Accepted solution]

hi,

Goto DB02 -- Diagnostics -- Missing Tables and indexes.

Try to create/correct the index here.

regards,

Arvind.

[Former Member]

Hi,

Please check the Performance tab in the Cube manage and try doing a repair index from there.

This generates a job so check the job in SM37 and see if it finishes. If it fails, check the job log which will give you the exact error.

These indices are F fact table indices so if nothing works, try activating the cube by the pgm 'RSDG_CUBE_ACTIVATE' and see if that resolves the issue.

Let us know the results.