what is the t-code to create INDEX in SAP BI(7.0)?/How can
we create the index in SAP BW/BI?
Answers were Sorted based on User's Feedback
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
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|
Answer / kiran babu r
Index can be created by managing a cube. There are two types
of indexes. They are primary index and secondary index.
Primary index is automatically created by the system ie
system generated index. Secondary index is created by us.
Indexing is a process of storing data according to an index
like in a phone book.Secondary indexes are of bit map and
|Is This Answer Correct ?||22 Yes||4 No|
Answer / nagendra
RSDDV - To create/maintain BIA indexes on specific cubes
|Is This Answer Correct ?||10 Yes||2 No|
Answer / durgaprasad
Index-- use to locate needed records from database tables
quickly.BW uses two types
---1. bitmap and 2. B-tree.
b-tree is for regular database tables and bitmap is for fact
tables and aggregate tables
Bitmap index - Bit map index uses maps of bits to locate
records in table.This indexs are very effective for Boolean
operators of where class of a select statement.when the
codinalality of a collum is low bit map index size will be
small there by reducing i/o volume.(which improves the
|Is This Answer Correct ?||8 Yes||6 No|
Define the Lis data flow?
I have 80 queries which query is taking so much time how can you solve it
I am learning SAP BI.i want learn more about Extraction in Bi.can please provide more info about it.what is the use of Extraction in real time.please provide detailed information about it.
Can anyone send me the what the scenario's client given in the real time,I mean functionalspecs,reporting scenarios?
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
Which R/3 version supports LO extraction?
Define the update rule?
Where do you store your custom images (like logos)?
what is delta mechanisum in SAP bi with example
What are the enhancements available for LIS?
how can u correct the error in loading for Delta failure
Can you name a few important tasks which are essential in the data warehousing and management of the same?