SAP BW stands for Business warehouse (Data warehouse on SAP). The Business Information Warehouse (BW) is SAP’s architectural solution for data warehousing. It is a separate system from SAP transaction processing. No data is generated in SAP BW. It takes care of ETL and reporting both.
SAP BW History:
SAP BusinessObjects Explorer : Google for your business intelligence environment. SAP BusinessObjects Explorer is a web-based search and exploration application that enables business professionals to explore and search through business information. Read more
Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time. It consists of numeric facts called measures which are categorized by dimensions.
In Star Schema all of the information about a dimension is stored in a single table. Each level of a hierarchy Read more