Data and Reporting Infrastructures
Business Warehouse Reporting
The SAP Business Warehouse (SAP BW) is the primary reporting platform for financial, human resources, and procurement SAP source systems. SAP BW is distinct from the SAP source system modules in that it is a consolidated data repository (a data warehouse) intended to support data reporting and analytical capabilities. The SAP source systems for financial, human resources, and procurement functions represent administrative and on-line transaction processing (OLTP) capabilities for data and process management. SAP BW is the extended reporting environment for this data and any other integrated information deemed relevant by business owners.
SAP BW reporting is made available through the SAP portal via the reporting tabs and folders. SAP BW reports are organized by subject area with specific reports provided as links on the respective menu pages. Each day, nearly 3,000 people across the University rely on SAP BW reporting. Other reporting interfaces and tools are also provided to data or business owners (central offices and administrators) of the particular data components, yet by far the primary and most-widely used method of reporting is the set of SAP BW Reports available in the Reporting section on the SAP portal. More…
The Open Hub Destination object is used to distribute data from the BW system to non-SAP destinations. Any objects supported by the Data Transfer Process (DTP) can be used as open hub data sources. Database tables and flat files can serve as open hub destinations. The database tables can be located in BW or in another database system that is supported by SAP NetWeaver. Data can be extracted and sent to downstream systems using APIs, SAP Data Services or a third-party tool.
Query Manager (QM)
The Central HR Functional Reporting Service relies on Query Manager (QM), a powerful and flexible software tool, to enable authorized employees to create and/or run reports for a wide range of SAP HR data. The queries execute directly on the data as it exists the SAP source system. There are no delays in obtaining time-critical information, since the reports, known as Queries, read live data directly from SAP. More…