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 / 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 ods (operational data store)?
What are the system tools you can use?
Can you explain about start routines how you used in your project give me an example?
please tell me the most frequently asked interview questions about sap BW with answers
What is the use ':' as an authorization value?
why ods activation fail? What types of fails are there? What are the steps to handle
Tell something you know about the dimension in the warehouse and how it can be optimized?
What is the format of LO data sources?
Explain business blueprint stage.
What are the mathematical functions?
how would you do the unloading non-cumulative cubes.
What are the inputs for an infoset?
How does a navigational attribute differ from other attributes in terms of linking it with the infocube?
What are the flags for general reporting?
how client access the reports