Many companies struggle with the ability to quickly and accurately create easy-to-read reports. This book systematically explains how you can leverage SAP Analysis Office (AO) to support your company’s reporting needs. AO combines the experience users had with Business Explorer (BEx) reporting over the last decade, with the additional pivoting functionality offered by Microsoft, along with standard Excel reports. Combining these functionalities, SAP created a powerful tool for your daily analysis as you will discover in this book. Tight integration with the SAP NetWeaver BW environment ensures that reporting users can access and refresh data. This book dives into: - Installation and prerequisites - Key functionality and detailed explanations like Analysis Excel pivot, ribbon, and context menus - Enhanced reporting with API and Visual Basic (VBA) - A comparison of Business Explorer (BEx) and Analysis Office (AO) functionality

Don't just read about SAP BW - get your hands dirty with this updated, must-have guide. Tackle all of the common tasks you'll encounter when working with SAP BW, from creating objects, to extracting and transforming data, to mastering the BEx tools. Keep your skills sharp with information new to this edition, including updates for SAP BW 7.4 and BW on SAP HANA. And follow along with a comprehensive case study to cement your knowledge. Detailed Steps for Working with SAP BW Get click-by-click instructions with guiding screenshots that will answer your questions and get you working in your own SAP BW system. Supplements and Bonus Material Find helpful lists of transaction codes, SAP Notes, data for the case study, and sample code downloads. Content New to this Edition Comprehensive updates include information on planning with DSOs, query execution in BW on HANA, SAP Lumira, and so much more. Highlights: InfoObjects Master data DataStore objects InfoCubes InfoProviders Data extraction BEx Query Designer BEx Web Application Designer Reporting and analysis Planning applications SAP HANA

Understand how your controlling processes relate to SAP Discover the many features and functionalities of the Controlling component Up-to-date for enhancement package 5 If you use Controlling in SAP ERP Financials, this book is a must-have resource for your daily work. You ll learn how to perform transactions with fewer steps and less effort, and you ll discover how to troubleshoot minor problems and system issues. In addition to the core areas of Controlling, you ll also find coverage of more advanced topics, such as SAP NetWeaver BW, SAP BusinessObjects, the SAP Financials Closing Cockpit, and topics added in recent enhancement packages. This book will help you to master the system and work more efficiently on a daily basis.

As an administrator, your ongoing to-do list dominates your desk. Let us help: With this book, learn the daily, monthly, quarterly, and yearly administration tasks you should be performing, and how to perform them. This comprehensive guide will walk you through system setup and configuration to lay a sound foundation for effective data storage, and then teach you to employ performance tuning techniques to optimize system performance. Consult detailed best practices to learn how to create BW objects and run reports, as well as to effectively use jobs and skills profiles for system support. Advance your SAP BW system from a B-movie to a blockbuster.

They say that the best way to learn is by doing. With this practical guide to SAP NetWeaver BW, put that theory to the test. Start with conceptual explanations and then dive straight into real-world application--all with the help of a case study that teaches you how to meet common business intelligence requirements. Whether you want to create objects, extract and transform data, or master the BEx tools, this book is all the help you need. 1. From Beginner to ExpertStart with the basics and move to the advanced--from InfoObjects to Open Hub, you'll be guided every step of the way. 2. Hands-on ExperienceDo more than learn what DSOs and InfoCubes are--use step-by-step instructions and hundreds of screenshots to actually create them yourself. 3. Practical Business ScenarioGet to know ABCD Corp., the fictional company that serves as the basis for your training. As you use SAP NetWeaver BW to meet its business requirements, you'll learn essential skills for working in the system. 4. Changes in Release 7.3Update your skills for the latest release. With information on graphical modeling, new types of InfoProviders, BW Workspaces, and SAP HANA, even experienced SAP NetWeaver BW users will find something new. 5. Data Files for DownloadDownload the bonus data files for ABCD Corp., which will give you everything you need tocreate the necessary objects and practice the tasks described in the book. Highlights: InfoObjects DataStore objects InfoCubes InfoProviders MultiProviders Process chains Extraction, transformation, and loading BEx tools Planning applications SAP BusinessObjects BI Administration Open Hub SAP HANA