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.

Optimal SAP Business Warehouse reporting performance requires regular monitoring and identification of a potential performance issues. In this book, you will learn the most important processes and tools that help identify bottlenecks and solutions to solve them. Dive into the fundamental aspects of data modeling to efficient ETL (Extract, Transform, Load) This book will quickly enable SAP BW professionals to apply the techniques covered in this book to improve performance with hands-on advice and screenshots. This complete guide to SAP BW performance optimization covers: - Quick gains in performance - Practical applications - Comprehensive coverage on performance optimization - Leveraging tools and utilities from ETL to reporting processes

This book is your guide for analyzing and optimizing ABAP source code. You ll learn about the analysis tools and performance-relevant technologies, and discover how you can analyze existing source code and enhance your programming style. This is the resource you need to ensure that your ABAP programs are fully optimized. 1 Analysis Tools After reading this book, you ll know when and how to use analysis tools properly including Code Inspector, performance trace, ABAP trace, or single records statistics. 2 Programming Technologies Get detailed information on parallel processing, internal tables, SQL data processing, and much more, and learn how these technologies affect performance. 3 Buffering Explore the different buffers that are available on the SAP NetWeaver Application Server ABAP, and learn the most important buffer options to avoid unnecessary database accesses. 4 Database Tuning You ll obtain a description of the database architecture and the technical background of database accesses, and master the tuning options for database accesses. 5 New Developments Learn from a comprehensive overview of the new developments in ABAP Release 7.0, EhP2, such as Transaction SAT, the innovations of the performance trace, and changes of internal tables.

SAP HANA has revolutionized the way we store data and architect reporting solutions. This book provides a step-by-step guide for moving an existing SAP BW system on any database to SAP HANA. Identify the differences between the database migration option (DMO) process and other options. Get sample staffing plans, tools for hardware sizing and planning, and budgeting tips for planning your migration project. Walk through the process for cleaning your SAP Business Warehouse (BW) system prior to migration and find out how doing so can reduce your SAP BW on HANA implementation costs. Walk through DMO process prerequisites and examine the SAP BW on HANA Migration Cockpit in detail. Get step-by-step instructions for executing a SAP BW on HANA migration using DMO and get tips based on lessons learned from the world’s largest DMO migration project. Walk away with best practices for monitoring the health of your SAP HANA implementation. Using practical examples, tips, and screenshots, the authors provide expert strategies to help your company’s migration project succeed. - Proven techniques for planning and executing a successful migration
- Building a solid migration business case - Sizing and optimization of SAP BW on SAP HANA - Step-by-step runbook for the migration process

"This book is insightful and thought-provoking for even the most seasoned SAP BW individual." —Richard M. Dunning, Chair, American SAP Users Group Written by the leading experts in the field, this comprehensive guide shows you how to implement the SAP Business Information Warehouse (BW) and create useful applications for business analysis of company-wide data. You'll quickly learn how to design, build, analyze, and administer the data and information in the SAP BW component. The authors present the material in a way that reflects the process an organization goes through during a software implementation. They begin with an introduction to the fundamentals of data warehousing and business intelligence, helping you determine if SAP BW is right for your organization. The book then focuses on the business content and options available when trying to deliver value from the data stored in the SAP BW. And it includes a methodology for implementing the BW, such as data modeling and techniques for capturing and transforming data. With this book, you'll discover the options available in SAP BW 3.0 and explore a new way to drive business performance. It will show you how to: Tackle such challenges as eliminating poor data quality Develop an information model in order to properly deploy SAP BW Utilize ETL, data storage, information access, analysis, and presentation services Schedule, monitor, archive, and troubleshoot data loads Effectively plan and manage the performance of a data warehouse The companion Web site provides useful guides and templates for configuring your system, industry case studies, and additional updates.

Finally, a detailed reference that gives administrators expert instruction to analyze and optimize performance in SAP BW. All the BW basics are covered such as architecture and data modelling, plus the ins and outs of systematic performance analysis, as well as volumes of valuable data design tips. Readers get an in-depth introduction to SAP BW indices, statistics, and database optimizers and learn about the key aspects of reporting performance. Full-length chapters deal with aggregates as well as extraction and loading performance. Plus, of course, the mission-critical topics of compression and InfoCube partitioning are discussed extensively. The depth and breadth of the information in this book, together with practical guidance that you can use right away, gives administrators the tools to analyze and tune BW performance immediately. Highlights include: BW architecture, sizing, and data modeling System load analysis Indices and database statistics Reporting performance: OLAP Cache, query monitor and trace, BW Reporting Agent, front-end performance and network, BEx queries and Excel workbooks Aggregates Compression and partitioning Extraction and loading performance: Integration of data sources, data flow, communication and transfer techniques, Persistent Staging Area, performance aspects for load, data extraction, and data transformation processes Update of InfoCubes and ODS objects

Attention administrators! Are you pursuing a background in SAP Basis, or just seeking brush up on your skills? If so, look no further than this practical guide! Updated for SAP NetWeaver 7.4, this resource offers the fundamental concepts of system administration, with step-by-step instructions and hundreds of screenshots. From system monitoring with SAP Solution Manager to database administration and disaster recovery, learn how to handle everything from the routine to the occasional hiccup.

If you're making the leap from SAP BW to SAP HANA, this book is your indispensable companion. Thanks to detailed pre-migration and post-migration steps, as well as a complete guide to the actual migration process, it's never been easier to HANA-ify your SAP BW system. Once your migration is complete, learn everything you need to know about data modeling, reporting, and administration. Are you ready for the next generation of SAP BW? Highlights: Implementation options Preparing for migration Step-by-step migration guide Post-migration steps LSA++ Data modeling Reporting Administration

Novice or expert, this is your one-stop shop for administering SAP HANA 2.0! You'll begin with a deep dive into database and engine architecture. Then explore your key tools: SAP HANA cockpit, SAP HANA Studio, the command-line interface, and more. From there, choose the topics you need. Backup and recovery? High availability? Data tiering? Security? Objects, tables, and transactions? All covered within these pages! From installation to performance tuning, this book has it all.Highlights include:1) Installation and updates 2) Architecture3) SAP HANA cockpit4) SAP HANA Studio5) Persistency6) High availability/disaster recovery7) Scale-out systems8) Data tiering9) Objects and tables10) Security11) Performance12) Monitoring