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

How would you convert an info package group to a process chain?

2476


can anyone tell me abt WAD navigation?

2355


What are the proposal options available?

2428


What is a temporal join?

1111


What are the sap enhancements to enhance fir data?

973


What is business content?

2043


What is the use of rollup?

1073


How does bex analyzer connect to bw?

1161


Which report can you use to monitor change run?

2035


What are the other BW processes?

2110


What is occurence

2249


What is the calculated key figure?

978


What is SAP exit?

2202


What is authorization processing type?

1941


when u creating infoobject it shows reference and template what is it

2731