SAP Analysis for Microsoft Office—Practical Guide
ISBN 978-1-4932-2004-5 569 pages, 2021
E-book formats: EPUB, PDF, online
ISBN 978-1-4932-2005-2 569 pages, 2021, Print edition hardcover
E-book formats: EPUB, PDF, online
ISBN 978-1-4932-2006-9
- Use SAP Analysis for Microsoft Office for reporting and planning
- Work with prompts, organize data, apply calculations, and format reports
- Conduct advanced data analysis with formulas and macros
In this book, you’ll learn about:
-
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.
-
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.
-
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:
-
Workbook creation
-
Report navigation
-
Prompts
-
Data processing, organization, and analysis
-
Planning applications
-
Report customization and formatting
-
Formulas
-
Macros
-
Configuration
-
Troubleshooting
You may also like:
-
SAP BW/4HANA 2.0 –
The Comprehensive Guide663 pages, hardcover
Ready for SAP BW/4HANA 2.0? Whether you're an architect, administrator, or developer, this comprehensive guide is for you. Start with a new installation or migrate from an existing SAP BW system. Then walk through major administration, security, and data management … More about the bookfrom $84.99
Available
E-book | Print edition | Bundle -
Group Reporting with SAP S/4HANA –
Financial Consolidation Guide375 pages, hardcover
Perform financial consolidation in your SAP S/4HANA system! With this guide to SAP S/4HANA Finance for group reporting, learn about the new group reporting architecture and data model. Configure your master data and integrate transactional data for consolidation using the … More about the bookfrom $84.99
Available
E-book | Print edition | Bundle -
SAP S/4HANA Embedded Analytics –
The Comprehensive Guide432 pages, hardcover
Meet your BI needs with SAP S/4HANA embedded analytics! Explore the system architecture and data model and learn how to perform analytics on live transactional data. Business user? Walk step-by-step through SAP Smart Business KPIs, dashboards, and multidimensional reporting. Analytics … More about the bookfrom $84.99
Available
E-book | Print edition | Bundle