Learning through sharing
1. What are the Query Tuning you do when you use reporting?
a) Install BW Statistics and use of aggregates for reporting
b) Avoid using too many characteristics in rows and columns, instead place it in free characteristics and navigate / drill-down later.
1. What is data integrity?
Data Integrity is about eliminating duplicate entries in the database. Data integrity means no duplicate data.
2. What is the difference between SAP BW 3.0B and SAP BW 3.1C, 3.5?
The best answer here is Business Content. There is additional Business Content provided with BW 3.1C that wasn't found in BW 3.0B. SAP has a pretty decent reference library on their Web site that documents that additional objects found with 3.1C.