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

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

This book provides system architects, technical consultants, and IT management the tools to design a system architectures to deploy SAP applications on SAP HANA. Explore production and non-production systems, deployment options, backup and recovery, data replication, high-availability, and virtualization in detail. Dive into on-premise deployment options and data provisioning scenarios. Walk through scale-up and scale-out options and data partitioning considerations. Review the advantages and disadvantages of storage and system replication options and when to use each. Clarify how to leverage HANA for single node and distributed systems. Dive into a discussion on software and hardware virtualization. Compare the options available and guide your decision using flowcharts your organization can leverage to choose the proper technology for your environment and specific needs. This book enables readers to carefully evaluate and implement a well-considered SAP HANA scenario. - SAP HANA sizing, capacity planning guidelines, and data tiering - Deployment options and data provisioning scenarios - Backup and recovery options and procedures - Software and hardware virtualization in SAP HANA

SAP BW/4HANA has introduced a new era in data warehousing at SAP. Further steps towards simplification, flexibility, and performance are now possible with SAP HANA as the proven technological basis. SAP BW/4HANA offers modern concepts for data management, operation, and modeling and thus opens the door for fully innovative application scenarios. This book will show you how the SAP HANA database influences the Business Warehouse and how you can optimize your system. As a practical guide, the book is aimed at experienced SAP BW experts as well as decision makers who need a well-grounded overview. The authors address the versions SAP BW/4HANA 1.0 and SAP BW 7.5 in equal measure, highlighting new functions and differences. The book also focuses on the migration options and conversion tools for moving to SAP BW/4HANA. Use this reference book to enter the world of SAP BW with SAP HANA as the database platform! - Migration, sizing, operation, data management with SAP BW/4HANA and SAP BW 7.5 on HANA - The new central source Systems SAP HANA and ODP - New modeling options, mixed scenarios, LSA++, and differences compared to SAP BW 7.5 - The role of BW in operational SAP reporting

This book provides system architects, technical consultants, and IT management the tools to design a system architectures to deploy SAP applications on SAP HANA. Explore production and non-production systems, deployment options, backup and recovery, data replication, high-availability, and virtualization in detail. Dive into on-premise deployment options and data provisioning scenarios. Walk through scale-up and scale-out options and data partitioning considerations. Review the advantages and disadvantages of storage and system replication options and when to use each. Clarify how to leverage HANA for single node and distributed systems. Dive into a discussion on software and hardware virtualization. Compare the options available and guide your decision using flowcharts your organization can leverage to choose the proper technology for your environment and specific needs. This book enables readers to carefully evaluate and implement a well-considered SAP HANA scenario. - SAP HANA sizing, capacity planning guidelines, and data tiering - Deployment options and data provisioning scenarios - Backup and recovery options and procedures - Software and hardware virtualization in SAP HANA

This book dives into SAP BW on SAP HANA. Explore the fundamentals of data warehousing on SAP HANA and identify what is different about running in an SAP HANA environment. Readers can utilize this handbook prior to or post migration to maximize their ROI. Review data loading methods and virtualization options. Walk step by step through external data integration in SAP BW 7.4 including enhanced composite providers, open ODS views, and virtual tables. Explore the new reporting options for SAP BW on SAP HANA and look at changes to the BI analytical engine, calculated key figures, and query connections to SAP BusinessObjects tools. Dive into data architecture and learn more about virtualization options for enterprise data warehouse in conjunction with SAP HANA. Get detailed instructions for upgrading, maintaining, and running SAP BW on SAP HANA including service packs, transports, and admin functions. Learn more about modeling in SAP BW enabled by SAP HANA in regards to moving from LSA to LSA++. By using practical examples, tips, and screenshots, the author brings readers up to speed on running SAP BW on SAP HANA. - Tips for upgrading, maintaining, and running BW on HANA - Data loading methods and real-time data acquisition - New reporting paradigm for BW on HANA - HANA data architecture

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.

Companies are leveraging the power of big data and are tasked with putting an infrastructure in place that will allow for the analysis of this data. One essential piece of that infrastructure is the data warehouse (DWH). This book offers a comprehensive introduction to SAP Business Warehouse (BW). You'll learn about the primary features and functions of SAP NetWeaver BW, including architecture, data modeling, data extraction, data staging, and reporting. Learn about the different types of InfoProviders available in SAP BW and get a detailed understanding of InfoObjects and InfoCubes. Walk through the ETL process and best practices for administering InfoCubes and DataStore objects. Get tips on how to optimize data access using aggregates and statistics. By using practical examples, tips, and screenshots, the author brings readers new to SAP BW up to speed on the fundamentals and best practices for providing reports to users. • Tips for loading data from a source system to SAP BW with SAP ETL • How to automate ETL tasks using process chains • Using SAP BW Business Content to accelerate the design of your BW objects • Leverage BEx Query Designer and BEx Analyzer

SAP BI Edge is a powerful business intelligence (BI) solution for midsize companies. This book offers a comprehensive overview of what to expect and where you should start building your reporting framework. You'll get detailed information on reporting tools, like Information Designer, Universe Designer, BI Launchpad, Crystal Reports, and Dashboards (formerly XCelsius). Get tips for creating an InfoSet strategy and leverage it to run reports. Learn how to use the Information Design Tool (IDT) to design data models and layer your data to create universes. Identify the common queries you will need to get started and walk through how to publish SAP reporting data in a web format and create practical management dashboards. By using practical examples, tips, screenshots, and a case study the author brings readers new to SAP BI Edge up to speed on the fundamentals. - Installation and setup tips for SAP BI Edge with SAP ERP - Query and reporting tools best practices - How to build a dynamic SAP ERP data model based on your configuration - Step-by-step instructions on how to create a SAP BI universe