Indicies Creation for Cube and ODS

[Former Member]

Hi Expert's,

How can we create indicies either for cube or for ODS?If we can create can u people eloberate this one with step by step approach.

Thanks in Advance.

Vasu.

[Former Member · Accepted solution]

Hi Vasu,

For Cube,

1. Goto Manage Cube option

2. Click on 'Performance' tab

3. Create Index (Batch)

For ODS,

1. Double click on ODS from RSA1

2. Under 'ODS object' locate "indexes"

3. Right click on indexes and create

4. Click on "unique" check box (optional)

5. Drag required characteristic(s) to the created index

Alternatively you can create it from TCODE "se11" and goto the active table of ODS and create.

Regards

Saugata