BW Missing Index

[Former Member]

I get following index missing in BW server . Please help how create it.

Primary Index:

ADMI_FILES-0

BTCOMSET-0

CREP_HTTP-0

Secondary Index:

/BIC/FZRT_C03SK-060

/BIC/FZRT_C03SK-070

/BIC/FZRT_C03SK-090

/BIC/FZRT_C03SK-100

T & R

MS

[Reagan · Accepted solution]

Hello

Check this SAP KBA

1820508  - Missing secondary indexes for infocubes in transaction DB02 > Missing Tables and Indexes

Regards

RB

[Former Member · Accepted solution]

Hi RB,

How to create primary index. please help.

I think

BW indexes never created via SE14 transaction.

BW indexes should only be created via the standard BW reports.

please share the process for create it.

Thn,

MS

[Reagan · Accepted solution]

Hello

ADMI_FILES-0
BTCOMSET-0
CREP_HTTP-0

They don't look like BI indexes.

Create the index using the Tx SE14

Regards

RB

[former_member188883 · Accepted solution]

Hi MS,

In DB02 , you can select the missing index and click on "Create in DB" button from the Menu option.

Schedule the job in background to create index.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

Thanks for your reply.

Please help how create

Secondary Index:

/BIC/FZRT_C03SK-060

/BIC/FZRT_C03SK-070

/BIC/FZRT_C03SK-090

/BIC/FZRT_C03SK-100

Thn

MS

[Reagan · Accepted solution]

Hello

Read the SAP note I have provided before.

Here it is one more time:

1820508  - Missing secondary indexes for infocubes in transaction DB02 > Missing Tables and Indexes

Regards

RB

[sunny_pahuja2]

Check below link:

http://scn.sap.com/thread/1577977

Thanks

Sunny