cancel
Showing results for 
Search instead for 
Did you mean: 

Indicies Creation for Cube and ODS

Former Member
0 Kudos
55

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

For cubes, the Delete and Create index options on the Performance tab allow you to delete / recreate them, but not defein new ones. For InfoCubes, the BW defined indexes are sufficient, although it can sometimes be advantageous to look at adding secondary indexes to large master data tables, and in some cases, even on large dimension tables. In those situations, you would need to have the DBA create them - the Admin Wkbench does not provide that functionality.

Former Member
0 Kudos

For ODS you can do it. Go to manage ODS and under the list of fields there is an indexes folder where directly indexes are created by drag and drop the different field you want to be in index.

For cubes is not recomendable create indexes due to complex of the cube estructure,. They can't be created from cube management.