Indexes on E or F table

[Former Member]

Hi,

When we create indexes on the infocube, are these primary index or secondary index?

2. Are these on F table or E table.

3. What are the fields on the which the index is created.

Thanks,

[Former Member]

When we create indexes on the infocube, are these primary index or secondary index?

Ans) Indexes are Primary

2. Are these on F table or E table.

Ans) These are on F table

3. What are the fields on the which the index is created.

Ans) Fields are decided by you .. these should be the fields that you frequently query upon and hence the retrieval needs to be faster

Cheers!!

Amit

[Former Member]

Hi,

The indexes for a infocube are built searching the tab Performance inside Manage. You don't have the need of creating it. You just have to rebuilt it after each request.

If you want to see it the indexes for each infocube you have to enter the transaction SE11 the abap dictionary. Inside the field Data base table you introduce *name of the infocube for example if the cube is named sales_cube you should introduce *sale_cube press visualizate and then you will choose if you want to see F table or E table. After that look for the button indexes end then you will see the data base indexes for the cube. I assume thet are secondary indexes. There is at least one index for each dimension that is asociated with the fact table. This answer solve your question?

Regards,

Ray

[yogesh8984]

Hi,

As far as my knowledge goes, we can create AGGREGATES to improve the performance of Cubes (Multidimensional Structures).

We create Indexes generally on flat structures (ODS or DSO).

We create indexes on the fields which appears in the selection screen of reports. These indexes works as secondary indexes where as the keys of the table acts as a primary indexes.

Again creating aggregates on Cubes or creating indexes on ODSes based on lot of analysis on how the reports will be executed? What are the frequently used parameters in executing the reports.

Regards,

Yogesh.

Edited by: Yogesh Kulkarni on Apr 21, 2008 12:48 PM

[chemicala_srimallikarjuna]

Hi,

primary index is created by system, secondary index can be created 'at users will'.Plscheck course material bw360 for indexes.

take a look threads

Regards

CSM Reddy