Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 36525 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 is the use of real-time infocube?
What internally happens when bw objects like info object, info cube or ods are created and activated?
How do you install business content AWB?
How to get the recordmode D or A in changelog table when we delete or add records in DSO?
When we use condition the totals do not match why?
How are dimensions optimized?
In update rules for an infocube we can specify separate update rules for characteristics of each of the key figures. In which situations is the above used?
How do you check the alert monitor?
how the master data is read?
Can you add programs in the scheduler?
What is ?filling? of aggregate?
In real world when do you recommend aggregate?
what is structure in reporting?
How do you enter documents?
What are the mathematical functions?
