The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11

Summary

This chapter focused on providing the business analyst with the knowledge to implement advanced querying and filtering techniques to enhance reporting and to decrease manual efforts. The chapter began with an introduction of SQL and the translation of the Request, Filter, and Sort lines of the query into SQL. The chapter identified the methods for adding and modifying custom user-defined request items, and it addressed the methods for creating user-defined filters through SQL. The chapter explored the flexibility of adding custom join conditions and editing the SQL of the document through using Custom SQL. The chapter concluded with the methods used to combine multiple queries into one dataset for analysis.