Chapter 4. Advanced Querying and Filtering
The flexibility to create complicated queries extends beyond the simple querying, filtering, and data modeling techniques shown in the previous chapters. Interactive Reporting provides the flexibility to take advantage of some advanced features to create reports and perform analysis quickly and easily. This chapter focuses 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 covers:
- The generation of SQL in Interactive Reporting
- Creating and modifying column definitions
- Commonly used Oracle functions
- Advanced filtering techniques
- Custom SQL
- Combining queries
- The query log and exporting SQL ...
Get The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
