MDX Reporting and Analytics with SAP NetWeaver BW

Download or read book MDX Reporting and Analytics with SAP NetWeaver BW written by Larry Sackett and published by SAP PRESS. This book was released on 2009-08 with total page 383 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.