what is the t-code to create INDEX in SAP BI(7.0)?/How can
we create the index in SAP BW/BI?

Answer Posted / kumar

I am sorry as I am not aware of TCode for Index. But, I can
roughly tell how to create Index. Creating Indexing is a
part of Performance Issues on Query. As we know that
whenever we load data to the data target, Primary indexes
are created automatically and uses Linear search i.e,search
record by record, whereas when we can create Secondary
Indexes, it will follow Binary search and hence the query
performance improves.

To create a Secondary Index,

1.Select your data target(Infocube or DSO)and select context
menu and select Manage.
2. Select the Performance tab and select 'Create Index' button.
3. In the new dialog box, Select 'Selection' and then select
'Immediate' and click Save.
4. Select 'Start' and click 'Continue'.

Once the Secondary Index is created, a check mark is created
in front of the data target.

Is This Answer Correct ?    43 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you do the optimizing the dimensions

476


How extended star schema is different from star schema?

454


What is update mode for master data?

1638


What is ?predefined characteristics??

2041


Which datastore object is used?

507






Explain the architecture of the sap bw system and its components?

455


What is the structure of infocube?

510


what are the benefits of cubes?

562


what is the difference between pdf and excel format after saving the report?

5976


why ods activation fail? What types of fails are there? What are the steps to handle

1371


how bw was found

1357


Are there any limitations for bex analyzer?

528


What are the objects that support variables?

1389


How would you do the calling a bw query from an abap program.

482


I am looking for SAP BI banking reports and business content for banking. Please help

3242