Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

Explain about the dimension in the warehouse?

1065


What is the transaction to maintain services?

1939


How dashboard is created in sap bw?

1069


How to create condition and exceptions in bi.7.0?

942


Does it have delta facility?

2152


How do you access to source system data in bi without extraction?

1030


what is high cardinality tell me brief

1529


What are the steps to do the configuring third party (bapi) tools.

1027


What is ud connect in sap bw system? How does it allow reporting in bi system?

964


What is the dimension in bw?

953


What is web template.

971


Differentiate between v1, v2, v3 jobs in extraction.

1044


Describe your experience with bw extractors

990


What are the advantages of new LO extraction?

2308


What are the template options?

2063