what is the t-code to create INDEX in SAP BI(7.0)?/How can we create the index

what is the t-code to create INDEX in SAP BI(7.0)?/How can
we create the index in SAP BW/BI?

Question Posted / nanic_c

4 Answers
35835 Views
Enteg Technologies, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the t-code to create INDEX in SAP BI(7.0)?/How can we create the index in SAP BW/BI?..

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

what is the t-code to create INDEX in SAP BI(7.0)?/How can we create the index in SAP BW/BI?..

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
binary tree.

Is This Answer Correct ?

22 Yes

4 No

what is the t-code to create INDEX in SAP BI(7.0)?/How can we create the index in SAP BW/BI?..

Answer / nagendra

RSDDV - To create/maintain BIA indexes on specific cubes

Is This Answer Correct ?

10 Yes

2 No

what is the t-code to create INDEX in SAP BI(7.0)?/How can we create the index in SAP BW/BI?..

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
performance)

Is This Answer Correct ?

8 Yes

6 No

Post New Answer

More SAP BW (Business Warehouse) Interview Questions

What are processing commands?

0 Answers

Percentage result of overall result (%GT)?

1 Answers

What is the attribute only flag?

1 Answers

can any one give me a senario for generic data source extraction? why u go for infosets and multiproviders ? give me a senario for each? what is time stamp, calday, numpt? what is safty intervels, y we set lower lt and upper lt?

0 Answers IBM,

In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.

0 Answers Rockwell, TCS,

How do you do Currency translation in SAP BW ?What are the settings that needs to be done?

0 Answers

Explain table partition?

0 Answers

What is the namespace of BW?

3 Answers

what is E_T_RANGE?

1 Answers

How the mapping is done in bw?