Learn to Create a SAP BW Technical Specification
First day on your new SAP BW job? Wondering where to start? Not really an expert on SAP ASAP? Maybe you don’t even have an ‘S’ number yet so you can download templates from SAP Service Marketplace. Want to shine, but need a light to see the end of the tunnel? Well, perhaps our SAP Business Intelligence Technical Specification template can help you little bit. In it, you will define:
- GENERAL INFORMATION
- DESCRIPTION AND PURPOSE
- TECHNICAL DESIGN OVERVIEW
- Design Solution – Overview
- Data Flow Diagram
- FLOW OF TRANSACTIONAL DATA
- FLOW OF MASTER DATA
- Data Requirements
- Key Figures/KPIs
- TIME CHARACTERISTICS
- UNIT CHARACTERISTICS
- TECHNICAL SOLUTION
- BI OBJECT DETAIL DESIGN (DATA FLOW DESIGN)
- InfoObject (Characteristics & Key Figure) Detail Specification
- Datasource/Extractor Detail Specification
- DSO/ODS Detail Specification
- InfoCube Detail Specification
- MultiProvider Detailed Specification
- Reporting Requirements
- WORKBOOK DESIGN
- ERROR MESSAGES
- SECURITY REQUIREMENTS/ AUTHORIZATION DETAILS
- ADDITIONAL INFORMATION AND ATTACHMENTS
- UNIT TEST PLAN
As you might have guessed, the definition of a SAP BW System is a complex undertaking and requires considerable expertise. Top Gun SAP BW consultants have to understand not just the complete SAP BW system capabilities, but also the capabilities of the SAP Business Objects solutions. In addition, to continuously improve their SAP Consulting skills, they will need to understand the underlying business processes, both from the perspective of what SAP can do as well as what the business process means within the context of the particular industry a business is in.
In addition to the SAP BW Technical specification document, you should also consider data governance. Why? Because it is estimated that U.S. Business’ lose $600,000,000,000.00 (yes, billion) due to bad data. In a later article, we will discuss our general recommendations for designing a robust data governance management system to help avoid some of the losses you may be suffering from now.
Got a better Template? Why Not Share It..
Lonnie D. Ayers, PMP
President, SAP BW Consulting, Inc.