This book is a complete SAP BW BEx Analyzer and Query Designer training course and has been written with SAP End-Users and Consultants in mind. Whether your current job title is functional consultant, financial reporting analyst, BW/BI Consultant, business consultant, project manager or something entirely different, if you are responsible or have an interest in creating SAP reports, then this book is for you.
Much of the book is written in the "How-To" style and will allow anybody to follow along and create reports from scratch. It is written in such a way that each chapter builds on the last so that you become familiar in lots of different aspects of SAP BEx reporting to enable you to then start creating your own reports and analysis applications as well as understand how SAP have created the standard reports delivered with the base system.
The reporting principles and guidelines apply across all SAP modules whether you're writing reports for HR, FI, SD or one of the many other modules within SAP.
Over my years of working with SAP systems Peter Moxon has had the great pleasure of working with some top-notch functional and technical consultants who know how to document, plan and develop SAP reporting solutions of all types. Likewise I have had the unpleasant experience of working with lower quality consultants, who don’t understand the complete SAP reporting solutions and tool-sets resulting in poor quality reporting solutions. This ultimately often results in project delays and cost overruns.
The aim of this book is to help you understand how SAP BEx Analyzer reports are put together and used so that you will be able to produce reports on your own quickly and efficiently resulting in increased work productivity and giving you answers to questions about your own companies data and performance.
Getting Started
First, learn how to use existing reports already available in your SAP BW system, then create and design flexible query definitions that can be used by a wide variety of users, with a focus on performance and usability. You will delve into the capabilities of BEx Analyzer and enhanced navigation features, such as drag and drop to facilitate end-user interaction, the new design mode to develop reporting applications within MS Excel, and additional integration with Excel formatting and formulas.
Follow Along with Complete End-to-End Reporting Examples
Create new queries, make reusable fields such as Calculated & Restricted Key Figures, add Conditions to your reports, build exception based queries and master report-to-report interfaces.
Highlights
• BEx Query Designer
• Accessing InfoProviders
• Creating Custom Templates
• Defining Jump Targets
• Build Analysis Application
• Integrate Exception & Conditional reporting techniques
• Embed multiple reports into your Workbooks
• Learn to build new reports in less than 2 minutes!
This book will give you the skills to create unlimited SAP BW reports, create and use both simple and complex query definitions using the BEx Query Designer and create full Analysis Applications in the BEx Analyzer.
Much of the book is written in the "How-To" style and will allow anybody to follow along and create reports from scratch. It is written in such a way that each chapter builds on the last so that you become familiar in lots of different aspects of SAP BEx reporting to enable you to then start creating your own reports and analysis applications as well as understand how SAP have created the standard reports delivered with the base system.
The reporting principles and guidelines apply across all SAP modules whether you're writing reports for HR, FI, SD or one of the many other modules within SAP.
Over my years of working with SAP systems Peter Moxon has had the great pleasure of working with some top-notch functional and technical consultants who know how to document, plan and develop SAP reporting solutions of all types. Likewise I have had the unpleasant experience of working with lower quality consultants, who don’t understand the complete SAP reporting solutions and tool-sets resulting in poor quality reporting solutions. This ultimately often results in project delays and cost overruns.
The aim of this book is to help you understand how SAP BEx Analyzer reports are put together and used so that you will be able to produce reports on your own quickly and efficiently resulting in increased work productivity and giving you answers to questions about your own companies data and performance.
Getting Started
First, learn how to use existing reports already available in your SAP BW system, then create and design flexible query definitions that can be used by a wide variety of users, with a focus on performance and usability. You will delve into the capabilities of BEx Analyzer and enhanced navigation features, such as drag and drop to facilitate end-user interaction, the new design mode to develop reporting applications within MS Excel, and additional integration with Excel formatting and formulas.
Follow Along with Complete End-to-End Reporting Examples
Create new queries, make reusable fields such as Calculated & Restricted Key Figures, add Conditions to your reports, build exception based queries and master report-to-report interfaces.
Highlights
• BEx Query Designer
• Accessing InfoProviders
• Creating Custom Templates
• Defining Jump Targets
• Build Analysis Application
• Integrate Exception & Conditional reporting techniques
• Embed multiple reports into your Workbooks
• Learn to build new reports in less than 2 minutes!
This book will give you the skills to create unlimited SAP BW reports, create and use both simple and complex query definitions using the BEx Query Designer and create full Analysis Applications in the BEx Analyzer.
