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
- 36727 Views
- Enteg Technologies, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is ?predefined characteristics??
what are the reports used from business content in sap bw project?name them and what was the requirement?
Can anyone send me the what the scenario's client given in the real time,I mean functionalspecs,reporting scenarios?
Give an example of the content key figure OTOTALSTCK (quantity total stock)?
what are the drawbacks of cubes?
What are the naming conventions for aggregates created from statistics?
How to fetch the data from sap-r/3, sap-bw/bi to informatica system? what is step by step procedure? at what senario you retrieve the data from sap system to informatica or say dwh system? --
How will you get more details on data source and delta modes?
List the steps you would take to create your dashboard in bw.
What is generally included in the data target administrative task?
What is the use of real-time infocube?
What are extractors?
What is the web download scheduler?
How do you use print settings?
what is sid for to trasport the object along the land scape:/
