Implementing SAP BusinessObjects Planning and Consolidation

28.12.2011

Deutsch

9781592293759

Rheinwerk Publishing

SAP PRESS Englisch

Nein

Marco Sisfontes-Monge

400

1

Gebundene Ausgabe

Reporting, BPC, Consolidation, Ownership Application, Currency Translation and the Rate Application, Planning, Budgeting and Forecasting, Data Extraction, Business Objects

1. Introduction (10 pages) 1.1. Overview of each Chapter 1.2. Welcome to SAP BusinessObjects Planning and Consolidation NW 7.5 1.3. Target audience 1.4. SAP BusinessObjects Planning and Consolidation: Microsoft vs. NetWeaver Architecture Differences 1.5. SAP BusinessObjects Planning and Consolidation Implementation Methodology 1.6. Blueprinting using ASAP Methodology 1.7. SAP BusinessObjects Planning and Consolidation NW 7.5 and SAP BI Cubes 1.8. Implementation Strategies: Development vs. Design 1.9. Legacy Systems and Data Conversion 1.10. Best Implementation Practices: Recommendations Before You Start 2. Dimensions, Master Data and Hierarchies (20 pages) 2.1. Introduction 2.2. The Basic Components of a Planning Application 2.3. Dimension Types and their function 2.4. Member Properties and Application Set Parameters 2.5. Period and Calendar Reporting 2.6. Hierarchies, Aggregation, and Dynamic Hierarchies 2.7. Basic components of a Consolidation Application 2.8. Master Data: traditional SAP vs. BPC 2.9. SAP BusinessObjects Planning and Consolidation Delivered Content (Appset) and its Dimensions 2.10. Summary 3. Data Management and Process Chains (30 pages) 3.1. Introduction 3.2. Package Properties 3.3. Types of Pre-delivered Packages 3.3.1. Financial 3.3.2. System Administration 3.3.3. Import and Export 3.3.4. Application related 3.3.5. Run SAP BW Process Chain 3.4. Working with Data Management Packages 3.4.1. Running a Package 3.4.2. Schedule a Package 3.4.3. Moving and Copying a Package 3.4.4. Deleting a Package 3.5. Working with Data Conversion Files 3.6. Working with Data Transformation Files 3.7. BAdl for Start Routine and End Routine 3.8. Summary 4. SAP BusinessObjects Planning and Consolidation Planning: Budgeting and Forecasting (30 pages) 4.1. Introduction 4.2. General definition of the concept of planning for this book 4.3. General Planning Business Model 4.4. Input Templates and Manually entered data 4.5. Allocations 4.6. Distributions 4.7. Components of Business Planning: 4.7.1. Capital Expenditures (CAPEX) 4.7.2. Operational Expenditures (OPEX) 4.7.3. Production Planning (PROD) 4.7.4. Overhead and Cost Center Planning 4.7.5. Headcount 4.7.6. Balance Sheet and Budget Planning 4.7.7. Revenue Forecast 4.7.8. Rolling Forecast 4.7.9. Planning at the Parent Level(to be reviewed) 4.8. Summary 5. Consolidation Basics (20 pages) 5.1. Introduction 5.2. Definition of SAP BusinessObjects Planning and Consolidation Consolidation for this book 5.3. General Consolidation Business Model 5.3.1. Recommended SAP ECC FI Consolidation Configuration 5.3.2. Table Fields for Legal Consolidation in SAP ECC 5.4. The Five Key Consolidation Processes 5.5. Components of Consolidation Reporting 5.5.1. Balance Sheet 5.5.2. Profit & Loss 5.5.3. Cash Flow 5.5.4. Shareholder’s Equity Report 5.5.5. Intercompany Transactions and Elimination 5.5.5.1.1. Using SAP BusinessObjects Planning and Consolidation MS 5.5.5.1.2. Using SAP BusinessObjects Planning and Consolidation NW 5.5.6. Intercompany Matching 5.5.7. Journal Entries and Manual Adjustments (Restatements) 5.6. Summary 6. Consolidation, Working w/ Ownership App (30 pages) 6.1. Introduction 6.2. Joint Ventures, Investments, and Private Equity 6.3. The purpose of the Ownership Application 6.4. Working with the Ownership Application 6.5. Basic Components of the Ownership Application 6.6. Effects of executing the Ownership Application over the Legal Application 6.7. Summary 7. Consolidation: Currency Translation and the Rate Application. (30 pages) 7.1. Introduction 7.2. Currency Translation Adjustments (CTA) and the Rate Application 7.3. IFRS vs. US GAAP 7.4. The Currency Translation Process of SAP BusinessObjects Planning and Consolidation 7.5. The components of the Rate Application 7.6. Updating Currency Exchange Rates 7.7. Handling Multicurrency Reporting 7.8. Summary 8. Data Extraction and Upload into SAP BusinessObjects Planning and Consolidation (30 pages) 8.1. Introduction 8.2. General Framework for data extraction and upload 8.3. Difference between SAP BusinessObjects Planning and Consolidation Microsoft and SAP BusinessObjects Planning and Consolidation NetWeaver 8.4. Data Transformation and Conversion from a Cube 8.5. Data Transformation and Conversion from a Flat File 8.6. Upload a Flat File into the File Storage System 8.7. Creating Data Extraction Package 8.8. Data formats for SAP BusinessObjects Planning and Consolidation 8.9. The Concept of Data Values (Key Figures) in SAP BusinessObjects Planning and Consolidation 8.10. Summary 9. Reporting (40 pages) 9.1. Introduction 9.2. Types of Reporting in SAP BusinessObjects Planning and Consolidation 9.3. Working with SAP BusinessObjects Planning and Consolidation pre delivered Templates 9.4. Working with EVDRE and MS Excel 9.5. Creating your first EVDRE Report 9.6. Creating Drilldown Reports 9.7. Creating Worksheet Formulas 9.8. Creating Member Formulas 9.9. SAP BusinessObjects Planning and Consolidation Reporting using Microsoft PowerPoint 9.10. SAP BusinessObjects Planning and Consolidation Web Reporting 9.11. SAP BusinessObjects Planning and Consolidation System Reports 9.12. Audit Trail Reporting 9.13. Creating BPF and Work Status Reporting 9.14. Summary 10. Business Rules (30 pages) 10.1. Introduction 10.2. SAP BusinessObjects Planning and Consolidation Pre Delivered Programs 10.3. Why Business Rules are Preferred Over Script Logic and MDX 10.4. Working with Dimension Logic and MDX 10.5. Working with Business Rules 10.5.1. Account Transformation 10.5.2. Currency Conversion Setup 10.5.3. Intercompany Booking Setup 10.5.4. Carry-Forward Business Rule 10.5.5. Validation Business Rule 10.5.6. Automatic Adjustment for Legal Consolidation 10.5.7. Intercompany Eliminations 10.6. Summary 11. Script Logic and MDX (20 pages) 11.1. Introduction 11.2. Differences between Script Logic and MDX 11.3. Applicability of MDX and Script Logic 11.4. Script Logic 11.4.1. Overview 11.4.2. Dynamic Parameters to Script Logic 11.4.3. Transferring Data Between Applications 11.4.4. Adding Two Accounts 11.4.5. Calculating a Percentage 11.4.6. Multiplying by a Dynamic Factor 11.4.7. Moving Data Between Two Accounts 11.4.8. Performing Allocations 11.5. Dimension Logic and MDX 11.5.1. Overview 11.5.2. Adding Two Accounts 11.5.3. Calculating a Percentage 11.5.4. Multiplying by a Factor 11.5.5. Movement Calculations 11.5.6. Allocations 11.6. Summary 12. Security in SAP BusinessObjects Planning and Consolidation (30 pages) 12.1. Introduction 12.2. The SAP BusinessObjects Planning and Consolidation Security Architecture 12.3. Task Profiles 12.4. Teams 12.5. User IDs 12.6. Mass Maintenance: Using the End-User Management Tool 12.7. Summary 13. SAP Business Process Flows (BPFs) (20 pages) 13.1. Introduction 13.2. Components of a BPF: 13.2.1. Business Process Flow (BPF) 13.2.2. BPF Template 13.2.3. BPF Instance 13.2.4. BPF Step Region 13.2.5. BPF Identifiers 13.2.6. Owner Property 13.2.7. Reviewer Property 13.2.8. BPF Monitor 13.2.9. My Activities 13.2.10. Action Pane 13.2.11. BPF Action 13.3. Creating a basic Business Process Flow 13.4. BPF Considerations 13.5. Work Status and Security 13.6. Summary 14. Tips and Tricks in SAP BusinessObjects Planning and Consolidation (20 pages) 14.1. Introduction 14.2. Validation 14.3. Transport in SAP BusinessObjects Planning and Consolidation NW 14.4. Transport in SAP BusinessObjects Planning and Consolidation MS 14.5. Creating Custom Measures 14.6. Working with VBA and EVMNU Functions 14.7. Creating Custom Menus 14.8. Summary 15. Performance Tuning and Optimization (30 pages) 15.1. Introduction 15.2. Full and Lite Optimization 15.3. The InApp property 15.4. Creating Partitions in SAP BusinessObjects Planning and Consolidation 7.x MS 15.5. Improving Application Set data upload using Application Set Parameters 15.6. Resolving Concurrency (Send Governor) 15.7. Working with the Project Management Console 15.8. Improving Report Performance using EVDRE 15.9. Worksheet Logic 15.10. SAP BusinessObjects Planning and Consolidation NW 7.5 basic ABAP Profile Parameters 15.11. Summary 16. Conclusions (10 pages) Index (10 pages)

690 mm

9 cm