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

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

6004


iam looking for some scenarion on reporting concepts like - replacement path,customer exits, all types of variables. plese send me some important links and materials. so it will be helpful for me. thanks in advance

1461


What are the objects that support documentation?

1553


Can you explain about start routines how you used in your project give me an example?

480


What is the difference between sap bw 3.5 and 7.0?

588






What is the table filled when you select ABAP?

1640


What are extractors? Name a few which are used commonly in the sap bw?

521


I have 80 queries which query is taking so much time how can you solve it

1247


What is an infoobject and why it is used in sap bi?

567


What are transfer rules?

544


What are value sets?

1534


Explain business blueprint stage.

530


What are Process Chains?

532


You want to start an implementation project. List the steps you would take to gather the requirements.

497


What are the load process and processing?

522