what is the t-code to create INDEX in SAP BI(7.0)?/How can
we create the index in SAP BW/BI?
- 4 Answers
- 35744 Views
- Enteg Technologies, TCS, I also Faced
- E-Mail Answers
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
What are the general services supported?
What is the use dso in bw system? What kind of data is stored in dsos
hierarchies are not there in bi?why
What are the destination target options?
When is idoc data transfer used?
what is InfoCube?what are the types and uses and in which Case it suppose to be use?
List the steps to do the creating classes in sap-bw
What are the steps within sap bi to create classes for bw?
I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?
which object based you created extended star schema?
how would you do the unloading non-cumulative cubes.
In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
WHAT IS THE DIFFERENCE BETWEEN WORKBENCH REQUEST AND CUSTOMERIZIED REQUEST
What is sap bw/bi? What is the purpose of sap bw/bi?
List the steps to configure sd and mm for bw.
