How is data structured in the Business Warehouse for queries, reporting, and analysis?
The data in the Business Information Warehouse is structured into self-contained business data areas (InfoProviders). Some InforProviders included are InfoCubes (a quantity of relational tables), Operational Data Stores (ODS) which store consolidated and cleansed transaction data on a document level, or combinations of these called MultiProviders. Queries will be defined so users can analyze the data. By selecting and combining InfoObjects (characteristics and key figures) or reusable structures in a query, users determine the way in which they navigate through and evaluate the data in the selected InfoProvider. What kind of reports should be written in BW? Which ones should be written in R/3? To determine specific reporting needs and ensure use of the right reporting tools, it is helpful to classify information requests into two basic types – tactical and strategic. Tactical reports typically contain real-time, dynamic transactional-level information. Tactical reporting is also referr
