3 Review(s)

Quickly master this extremely robust and powerful business intelligence tool Get to grips with the most important, frequently used, and advanced features of Oracle Hyperion Interactive Reporting 11 A step-by-step guide packed with screenshots and clear explanations Explore the features of dashboards, reports, pivots, and charts Learn how to build advanced data models and queries, and how to import external data set into your analysis In Detail Oracle Hyperion Interactive Reporting is one of the many products in the Oracle Enterprise Performance Management software suite, an industry-leading business intelligence software package. The primary focus of the Interactive Reporting product is to provide strong relational querying and data analysis capabilities. It also provides the capability to disseminate information throughout an enterprise. There is a very steep learning curve for most users of this tool. This book examines the power of the Interactive Reporting Web Client software, focusing on the key features of each section of the product. The author's experience in developing and supporting Interactive Reporting users is very well documented in this book. The goal is to educate you on every useful feature of the product, enabling you to gather information from various sources and process it to produce meaningful results that help you to spot problems and analyze trends necessary for business decisions. The book starts with a quick introduction to the product interface and the EPM Workspace, with explanation of importing and provisioning. It then takes you through each section from building a query and data model to building graphical displays of the data in a logical sequence. The report sections and interactive dashboards are also discussed at length. The book also covers advanced features of the product and provides you with the information necessary to build the foundation for creating complex queries and computations using the product. Demonstrates the key functionalities of the Oracle Hyperion Interactive Reporting software with a detailed view of each section and an introduction to dashboard design What you will learn from this book Navigate the Workspace with examples for importing and provisioning Interactive Reporting documents Learn to build data models and queries, and import external data Gain in-depth understanding of leveraging user-defined SQL in the product Learn to analyze data in the Result, Table, and Pivot sections Explore the different chart types and methods for adding chart content Build report sections including data from multiple queries and different charts and pivots Create interactive dashboards and configure interactive components Approach This is a hands-on walkthrough, from gathering information to creating a report to the presentation sections. It helps you to get accustomed to the software and gives an in-depth understanding of how to easily unleash the powerful functionality of the software. As a result you will be able to use the powerful functionalities of Oracle Hyperion Interactive Reporting 11 to drive important business decisions. The style of the book allows you to use it as a guide to walk through each chapter or as reference material while you work with the software. Who this book is written for This book is for all Oracle Hyperion Interactive reporting users from novice to advanced. If you find yourself struggling while using this tool or you are new to the tool, this book will guide you through and make the learning process incremental. About the Author Edward J. Cody is an accomplished data warehouse and business intelligence consultant with over seven years of experience with Hyperion products. Mr. Cody was a speaker at Oracle OpenWorld 2008 on Essbase, and he has spoken at local user groups on ETL software. His experience with Interactive Reporting began with Brio v6 and has continued through the most recent version. He also has extensive experience with Essbase and Financial Reporting. Mr. Cody has consulted both private and Government organizations throughout his career. He has a Bachelor of Science in Systems Engineering from the George Washington University, School of Engineering and Applied Science, and he has a Master of Science in the Management of Information Technology from the University of Virginia, McIntire School of Commerce. His experience includes leading large Data Warehouse and Oracle Hyperion Business Intelligence projects, and he is currently leading an assessment of a major data warehouse and business intelligence initiative. He is well known for his efforts to centralize metrics, reduce BI complexity, and leverage process automation and product integration to increase performance while reducing maintenance. Mr. Cody has designed training programs on the software and decided to author a book on Oracle Hyperion Interactive Reporting after exposure to user feedback on the complexity of learning the product. He identified that an introductory user guidebook on using the essential features of the software would be beneficial to all software users. Table of Contents Preface Chapter 1: Oracle Hyperion Interactive Reporting Chapter 2: The Query Chapter 3: The Data Model Chapter 4: Advanced Querying and Filtering Chapter 5: Results and Tables Chapter 6: Pivots Chapter 7: Charts Chapter 8: Reports Chapter 9: Dashboards Index