1 / 6

UK’s Reporting Strategy

UK’s Reporting Strategy. SAP’s Business Warehouse (BW) is the long-term solution for reporting. Business Warehouse is a preferable over writing reports in the SAP online system (R/3) because of: ease of use snapshot or point-in-time comparisons

tyme
Download Presentation

UK’s Reporting Strategy

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. UK’s Reporting Strategy • SAP’s Business Warehouse (BW) is the long-term solution for reporting. • Business Warehouse is a preferable over writing reports in the SAP online system (R/3) because of: • ease of use • snapshot or point-in-time comparisons • ability to integrate with several reporting tools (WebFOCUS, SAS, etc.) • ability to merge R/3 and non-R/3 data • ability to merge data from multiple R/3 functional areas (MM, FI, HR, etc.) • ability to report on extensive attributes of master data (fund center, grant, etc.) • analytic (drilldown, data pivots) and operational (lists) reports • preservation of processing speed in the R/3 system for more critical needs such as payroll and student registration.

  2. Business Warehouse Concepts • BW Business Content • Data structures, extraction/load jobs and reports • Not all R/3 data is delivered in BW BC. • BW Customization • Add R/3 elements not in delivered BC • Add UK custom R/3 elements (ProCard) • Add non-R/3 data (ProSAM, historical data) • Add custom data structures and queries • Modify delivered BC data structures and queries

  3. Business Warehouse Concepts • Data Structures • Operational Data Store (ODS) – detail transactions • InfoCubes – dimensional analysis of summary data, with possible drilldown to details in ODS • Reporting Tools • Business Explorer (BEx) – Power users; write reports. • BEx Web Reporting – Customize and run reports written by others. • Other – SAS and WebFOCUS interface. Future decisions.

  4. Business Warehouse (BW) Implementation • Phase I • Identified and prioritized 2,000+ existing reports • Focus on most critical R/3 (not historical) data and most critical reports • Scope for FI/MM • SAP Delivered – Grants Management, AP and AR • Custom Work – Funds Management, FI-Special Ledger, Check Management, ProCard, extensive AP & AR master data additions • Scope Definition for HR, ProSam and CM – in progress

  5. Business Warehouse (BW) Implementation • Phase II • Migrate historical data to BW in stages (3-5 years) • Development of “lower” priority reports • Strategic Enterprise Management (SEM) – dashboard, strategy map

  6. Examples of Reports Delivered in BW • Financials • 1099 Vendors • Vendor Document Details • Check Management Analysis • Assigned Funds (All Ledgers) • Budget Version Comparison • Commitments and Actual • Grants Management – Budget Detail

More Related