In this book you'll find everything you need to configure and execute Web reporting and Web applications, as well as detailed instruction to take advantage of the resulting possibilities for analysis and reporting in SAP BW. First, you'll be introduced to the basic topics of BEx Query Designer, BEx Web Application Designer, BEx Web Applications, BEx Analyzer, and SAP Business Content. Then, expert guidance shows you, step by step, how to master the process of creating custom reports and analysis. That's just for starters. You'll also learn best practices for creating your own SAP BW Web Cockpit and much more. Highlights include Data Warehousing and SAP BW Data Presentation Concepts and their Implementation in SAP BW BEx Query Designer: Analysis and Definition of Data, Query Views and Elements BEx Web: Web Framework, BEx Web Application Designer, Details of Web Items Information Broadcasting: Online and Offline Reporting, Sending Reports, Publishing in the SAP Enterprise Portal SAP Business Content: Elements and Areas of Use Detailed Sample Scenario Appendices: Includes BW Glossary, Sample Queries, Transaction Codes, Metadata Tables, Index

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

Your Hands-On Guide to SAP Business Information Warehouse Give your company the competitive edge by delivering up-to-date, pertinent business reports to users inside and outside your enterprise. SAP Business Information Warehouse Reporting shows you how to construct Enterprise Data Warehouses, create workbooks and queries, analyze and format results, and supply meaningful reports. Learn how to use the BEx and Web Analyzers, Web Application Designer, Visual Composer, and Information Broadcaster. You will also find out how to forecast future business trends, build enterprise portals and websites, and tune performance. Group data into InfoCubes and DataStore Objects and generate reports using queries and workbooks Work with the BEx Analyzer, Web Analyzer, and Query Designer Build queries and reports using the Business Administration Workbench Add attachments and drill-through using Document Integration and RRI Format and distribute results using Report Designer and Information Broadcaster Extend functionality with Enterprise Portal, Data Modeling, and Visual Composer Deploy charts, maps, diagrams, and unit of measure conversions Predict trends and possible outcomes using SBC and Integrated Planning Generate HTML pages using Enterprise Reporting and Web Application Designer Create BI-based corporate Web and intranet sites using SAP Enterprise Portal

Managing your SAP data in Microsoft Excel? This is your guide to using SAP Analysis for Microsoft Office! Get started with the basics, from creating your first workbook to navigating through reports. Then, follow step-by-step instructions to process data, analyze data, develop planning applications, customize reports, and work with tools such as formulas and macros. Including details on troubleshooting, UI customization, and more, this book is your all-in-one resource! In this book, you'll learn about: a. Reporting and Data Analysis Learn to work with reports in SAP Analysis for Microsoft Office: define parameters with prompts, adjust formatting and styles, and extend reports with local data. Filter, sort, and display your data using hierarchies, and refine data analysis with simple and advanced calculations. b. Planning Use your SAP data to develop planning workbooks. Plan your data both manually and with functions and sequences. Understand key settings for cell locking, the planning model, and more. c. Advanced Features Take your skills to the next level. Write formulas to use in your reports, and create and use macros in your workbooks, including steps to use API methods, callbacks, and design rules. Highlights include: 1) Workbook creation 2) Report navigation 3) Prompts 4) Data processing, organization, and analysis 5) Planning applications 6) Report customization and formatting 7) Formulas 8) Macros 9) Configuration 10) Troubleshooting

MDX (Multi-Dimensional eXpressions) is extraordinarily powerful, and is used for both self-service reporting and advanced analytics. If you are going to do multi-dimensional analysis, you have to know MDX. MDX enables business users to perform analyses and generate reports that are next to impossible in any other query language, such as SQL, or even in BEx queries. This is the complete guide to generating effective reports and solving business problems using MDX in NetWeaver BW. First, the author introduces you to this extraordinarily powerful query and calculation language for both advanced analytics and self-service reporting. With expert guidance, you'll explore the idiosyncrasies of the MDX language and understand what object(s) each function takes as inputs and what they generate as outputs. Then, get an in-depth look at self-service reporting and analytics with MDX and how well these tasks are accomplished depending in large part on the modeling of InfoCubes. You'll find out about techniques for improving query response time, including use of the SAP NetWeaver BW Accelerator.Finally, you'll also learn about the recent and substantial enhancements to the SAP NetWeaver BW MDX engine, the MDX-based OLAP BAPI, and the OLAP Data Access (ODA) component in SAP BusinessObjects.

"This book is the definitive guide for SAP NetWeaver BI professionals. Based on their extraordinary expertise with the product, the authors provide deep insights about key innovations in the areas of user experience, query performance, integrated planning, and enterprise-wide data warehousing." —Stefan Sigg, Vice President, SAP NetWeaver Business Intelligence The long-anticipated publication of this second edition reflects the growing success of SAP NetWeaver as well as the various Business Intelligence (BI) capabilities that are embedded with SAP BW version 7.0. Written by SAP insiders, this comprehensive guide takes into account the ever-changing features, functionality, and toolsets of SAP NetWeaver to bring you the most updated information on how to use SAP BW to design, build, deploy, populate, access, analyze, present, and administer data. You'll discover the options that are available in SAP NetWeaver and uncover a new means to improve business performance. This book reflects the process an organization goes through during an implementation of the software. The authors begin with an introduction to BI and SAP NetWeaver and quickly progress to information modeling and enterprise data warehouse concepts. You'll learn how to access and deliver meaningful analytic information to the organization, as well as perform integrated planning functions. Finally, the authors share invaluable insight on warehouse administration, performance, and security. With more than 50 percent new or revised material, this second edition of Mastering the SAP Business Information Warehouse shows you how to: Extract data from online transaction processing systems Store transformed data in a way that best supports reporting and analysis Use the various Business Explorer tools such as BEx Report Designer, BEx Analyzer, BEx Broadcaster, and BEx Web Application Designer Schedule, monitor, troubleshoot, and archive data loads The companion Web site contains sample chapters in Wiki format and the authors' blog where readers may enter discussions about the book and SAP. Wiley Technology Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/ Visit the companion Web site at www.wiley.com/compbooks/mcdonald The companion Web site contains the sample code presented in the text of the book, plus implementation templates.