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
- 36681 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
List the steps to do the converting from lis to lo extraction.
How much time would it take to extract 1 million data from infocube?
What is a repair request?
as you said you have worked on cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?
What is aggregate hierarchy?
What is the dimension in bw? How would you optimize the dimensions?
What are the load process and processing?
what is meant by compounding attribute tell me the scenario?
When a query is run with a loop, what does it generate? A) Cartesian product b)An incompatible combination of objects c) An SQL statement generation error d)Results returning too many rows e)Results returning too few rows
What are the monitor settings?
Which report can you use to monitor change run?
What is start routines.
Compare info cubes with operational data store?
What are the tools to monitor overall query performance.
How do you use print settings?
