Oracle APEX 4.2 Reporting

Oracle APEX 4.2 Reporting
eBook: $32.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $87.98    Print cover: $54.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Provides an introduction to the APEX architecture and is a step-by-step guide to setting up the APEX environment on Weblogic
  • Integrations of the reports with the most popular reporting technologies and generation of exotic and typical reports alike
  • Packed with complex APEX applications to help you learn newer ways of fulfilling reporting requirements in APEX

Book Details

Language : English
Paperback : 428 pages [ 235mm x 191mm ]
Release Date : August 2013
ISBN : 1849684987
ISBN 13 : 9781849684989
Author(s) : Vishal Pathak
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Applications, Enterprise, Oracle

Table of Contents

Chapter 1: Know Your Horse Before You Ride It
Chapter 2: Conventional Reporting in APEX
Chapter 3: In the APEX Mansion – Interactive Reports
Chapter 4: The Fairy Tale Begins – Advanced Reporting
Chapter 5: Flight to Space Station: Advanced APEX
Chapter 6: Using PL/SQL Reporting Packages, Jasper, and Eclipse BIRT
Chapter 7: Integrating APEX with OBIEE
Chapter 8: All About Web Services and Integrations
Chapter 9: Performance Analysis
  • Chapter 1: Know Your Horse Before You Ride It
    • What is really new in the new avatar of APEX?
    • APEX configurations
      • APEX configuration using DAD
        • Internal mod_plsql configuration
        • External mod_plsql configuration
      • APEX Listener configuration
    • Installing APEX engine and Listener
      • Installing the APEX engine in the database
      • Creating a WebLogic domain and starting the servers
      • Setting the APEX Listener
        • Configuring and deploying APEX Listener on the WebLogic domain
    • Creating APEX workspace
    • Understanding the APEX URL
      • The protocol
      • The hostname and port number
      • The DAD name and web context
      • The f procedure
      • The application ID in the URL
      • The page number in the URL
      • Session management
        • The zero session ID
      • Request handling
      • Debugging
        • Error handling
        • TKPROF
      • Cache management
      • Passing values and navigation
      • Making APEX printer friendly
    • Decoding the APEX page submissions
    • APEX behind the scenes
    • Other web interfaces
    • A pessimist's view of APEX
      • Cap of 200 page items
      • SQL Injection
      • Cross-site scripting
    • Summary
    • Chapter 2: Conventional Reporting in APEX
      • Creating database objects and installing the reference application
      • Implementing external table authentication
      • Displaying environment properties using the USERENV namespace
      • Displaying the CGI environment variables
      • Implementing a classic report search functionality
      • Enabling sorting and CSV download
      • Implementing group reports
        • Using the Break Formatting section in classic reports
        • Using JavaScript to modify a report
        • Using grouping sets and HTML formatting in a query
      • Additional methods of formatting
        • Highlighting the searched text in a report
        • Editing a template for additional formatting
      • Implementing a matrix report
        • Understanding the with clause
        • Understanding the Oracle 11g's pivot operator
        • Understanding string aggregation
      • Data highlighting using Dynamic Actions and jQuery
      • Advanced formatting using APEX templates
      • Understanding dynamic query region in APEX
      • Implementing hierarchical reports
        • Hierarchical reports with drilldown
        • Creating dynamic messages using substitution variables
        • Creating dynamic breadcrumbs for drill ups
        • Creating a report with hierarchical query
        • Creating a hierarchical report using the recursive with clause
        • Creating a tree based on hierarchical data
      • Understanding methods to upload files in APEX
        • Using DA to set page items and side effects of PPR
          • A workaround to the side effects of PPR
        • Using substitution variables for labels
        • Auto feeding one APEX item based on another
        • The method to upload files using WWV_FLOW_FILES
      • Understanding download methods
        • Download using APEX format mask
        • Download using developer-defined stored function
        • Download using APEX_UTIL.GET_BLOB_FILE_SRC
        • Download using p process
      • Implementing soft deletion with AJAX and APEX templates
      • DML operations and report filtering using DA, JavaScript, and page processes
        • Filtering reports and logging values using Dynamic Actions
        • AJAX – a two-way communication between page process and JavaScript
      • Implementing a tabular form
        • Creating a tabular form
        • Changing item type on user event
      • Implementing a master detail report and displaying complex types
        • Displaying complex types and varray in a report
      • Implementing time series reports
        • Creating aggregation on a partitioned time dimension region
        • Time series analysis with analytical functions and time dimension
          • Using the query partition clause for data densification
        • Creating aggregations using the model clause
      • Implementing data-level security
        • Using VPD
        • Using query filters
      • Summary
      • Chapter 3: In the APEX Mansion – Interactive Reports
        • About the reference application
        • Important features of the interactive report
          • The Search functionality
          • Using the Select Columns feature of the Actions menu
          • Using the filtering feature of the Actions menu
            • Linking the interactive reports
          • Using the Rows per Page feature of the Actions menu
            • Customizing the number of rows in an IR
          • Using the formatting options of the Actions menu
            • Using Control Break
            • Using the Compute option
            • Using Chart in an IR
          • Using the Flashback feature of the Actions menu
          • Using the Save Report feature of the Actions menu
          • Using the Reset and Download features of the Actions menu
            • Configuring the Email functionality
            • Downloading in CSV and HTML formats
            • Downloading in PDF format
          • Using the Subscription feature of the Actions menu
        • Other configurable attributes of an IR
          • Using the Link Column section of the Report Attributes page
          • Using the Icon View section of the Report Attributes page
          • Using the Detail View section of the Report Attributes page
          • Using the Advanced section of the Report Attributes page
          • Using the Column Group section of the Report Attributes page
        • Using Dynamic Actions (DA) to add custom functions in the Actions menu
        • Using CSS in IR
          • Formatting a column using another column
          • Using CSS in the page header to format APEX data
            • Changing the font color of alternate rows in APEX
          • Using a user-defined CSS class in APEX
          • Conditionally highlighting a column in IR using CSS and jQuery
          • Formatting an IR using a region query
        • Understanding the process of any customizations in IR
        • Using APEX views to create a classic report on saved IRs
          • Capturing report ID using JavaScript
        • Creating multiple IR on the same page
        • Authorizing user groups to view report columns
        • Creating Interactive Report Dashboard
        • Understanding Dynamic Interactive Reports
          • Using native PL/SQL table function approach and conditional columns
            • Using parallel-enabled table functions
          • Unterstanding interface table function approach
            • Understanding the ODCITableDescribe function
            • Understanding the ODCITablePrepare function
            • Understanding the ODCITableStart function
            • Understanding the ODCITableFetch function
            • Understanding the ODCITableClose function
          • Understanding the collection approach
        • Summary
        • Chapter 4: The Fairy Tale Begins – Advanced Reporting
          • About the reference application for this chapter
          • Using LDAP authentication
            • Process to get the necessary DN from JXplorer
          • Creating sparkline reports
          • Creating a report with slider
          • Creating HTML charts
            • Creating a bar chart using APEX's HTML chart functionality
              • Creating an APEX HTML chart
              • Displaying the top N and the bottom N rows in an HTML chart
              • Understanding the APEX HTML bar chart behind the scenes
            • Understanding self-generated HTML charts
            • Creating a report from XMLTYPE
          • Creating Google visualization charts
          • Creating Flash charts
            • Customizing an XML chart
            • Understanding Anychart options using a doughnut chart
            • Discussion on scatter and 3D stacked charts
            • Discussion on a gauge chart
            • Discussion on a gantt chart
            • Discussion on a candlestick chart
            • Creating Flash image maps
          • Creating a calendar
          • Creating a report with images
          • Creating a dialog box
          • Creating a context menu
          • Creating a wizard and using hierarchical queries and regular expressions
            • Setting different validations for different parts of a page process
          • Summary
          • Chapter 5: Flight to Space Station: Advanced APEX
            • Creating HTML image maps
              • Server-side image maps
              • Client-side image maps
            • Creating PL/SQL Server Pages (PSP)
            • Understanding and using loadjava utility
            • Creating funnel charts using FusionCharts
            • Creating tag cloud
            • Creating plugins
              • Creating item and page process plugin
              • Creating DA plugin
            • Creating websheet application
              • Understanding datagrid
              • Understanding reports
              • Understanding the features of administration and view drop-downs
              • Understanding Websheet Help menu
              • Sharing websheets using ACL
            • Configuring the mail
            • Downloading APEX application without web server
            • Understanding Oracle OLAP cubes
            • Understanding Oracle's advanced queuing
            • Understanding other APEX features
              • Understanding locking and unlocking of pages and team development
              • Understanding database object dependencies report
              • Understanding advisor
              • Understanding shortcuts
              • Understanding data loading wizard
              • Understanding application express views
            • Understanding background jobs in APEX
            • Knowing about important functions from the API
              • Knowing about the APEX API
              • Knowing about the database API
            • Summary
              • Chapter 7: Integrating APEX with OBIEE
                • Understanding Oracle fusion management architecture
                • Understanding OBIEE
                  • Understanding the BI Server component
                  • Understanding the BI Presentation Server
                    • Understanding Dashboards, analysis (answers), and filters
                    • Understanding KPIs and KPI watchlist
                    • Understanding Actions
                    • Understanding OBIEE Mapviewer
                    • Understanding strategy management
                    • Configuring the Gmail SMTP server in OBIEE
                    • Understanding agents
                • Integrating OBIEE with APEX
                  • Integration using web services
                  • Integration with APEX using Go URL
                    • Integration using iFrames in APEX
                • Understanding BI Publisher
                  • Creating and mailing reports in BI Publisher
                    • Creating data model in BI Publisher
                    • Using the BI Publisher's MS Word plugin to make rtf templates
                    • Assembling the rtf template and data model together
                    • Scheduling reports and e-mail delivery in BI Publisher
                    • Creating barcode reports in BI Publisher
                    • Dynamic BI Publisher
                • Integrating BI Publisher with APEX
                  • Using convert servlet in Instance Settings
                  • Integrating APEX with BI Publisher using web services
                  • BI Publisher guest folder
                • Summary
                • Chapter 8: All About Web Services and Integrations
                  • Understanding reports on web services and collections
                    • Setting XML DB web services
                    • Creating a report on native XML DB web services
                    • Using XMLTable to parse a web service response
                    • Using a native web service to return a collection of rows
                    • Configuring RESTful web services using Resource Templates
                    • Creating RESTful web services using Resource Templates
                    • Parsing JSON objects and using MAKE_REST_REQUEST
                • Understanding and implementing BPEL
                  • Configuring the General section
                  • Configuring the Assignment section
                  • Understanding Human workflows and Worklist
                • Integration with SAP crystal reports
                • Migrating from MS Access to APEX
                • Migrating from Oracle Forms and Reports
                • Integration with Google API
                • Integration with Oracle R Enterprise
                • Summary
                  • Chapter 9: Performance Analysis
                    • Tuning pointers for development
                      • Using v()
                      • Using the page and region caching
                      • Understanding the weighted page performance of APEX
                      • Using the #TIMING# substitution string
                      • Choosing a pagination scheme
                      • Tuning the like comparisons
                      • Using the bind variables
                      • Using materialized views
                      • Using bulk operations
                      • Using sequences
                      • Understanding indexes
                        • Understanding the bitmap index
                        • Understanding the reverse key index
                        • Ordering columns in an index
                      • Using the with clause
                      • Understanding partitioning strategies
                      • Understanding anonymous blocks versus stored procedures
                      • Using star transformation
                      • Understanding clustering of tables
                      • Understanding parallelism
                      • Using code inlining
                      • Understanding short circuit evaluation
                      • Understanding PLSQL_CODE_TYPE
                      • Using PL/SQL datatypes
                      • Using HTML in SQL
                      • Implementing XML PIVOT queries
                      • Understanding denormalization
                      • Understanding secure files, deduplication, and large object storage
                    • Discussions on HTML, JavaScript, and client-side tools
                      • Understanding image storage
                      • Using browser-specific tools
                      • Using minified JavaScript
                      • Compressing HTML for better performance
                      • APEX Listener parameters
                    • Discussions on database tools for performance tuning
                      • Using PL/SQL hierarchical profiler and DBMS_PROFILER
                      • Understanding Data Guard
                      • Understanding SGA result cache
                      • Understanding SQL work areas
                      • Using data compression
                      • Understanding segment space problems
                      • Understanding the Database Resource Manager
                      • Understanding the SQL Access Advisor and SQL Tuning Advisor
                      • Understanding temporary tablespace
                      • Understanding SQL monitoring
                      • Understanding DB_FILE_MULTIBLOCK_READ_COUNT
                      • Understanding extended statistics
                      • Understanding SQL Performance Analyzer
                      • Understanding SQL Tuning Advisor
                      • Understanding pinning in keep pool
                      • Understanding Automatic Database Diagnostic Monitor (ADDM)
                      • Understanding Automatic Workload Repository (AWR)
                      • Understanding index-organized tables
                      • Understanding row chaining and row migration
                      • Understanding the clustering factor
                      • Understanding the Active Session History report
                    • Summary
                    • Appendix
                      • Steps to create PACKT_SCHEMA
                      • SQL Injection
                        • Dynamic SQL with concatenated variables
                        • Assumption of formats and implicit conversions
                      • Cross-site scripting
                      • Database and web interaction in DAD and Listener configurations
                        • The DAD configuration
                        • The Listener configuration
                      • APEX behind the scenes
                        • Enabling auditing on the APEX_PUBLIC_USER schema
                        • Switching off the auditing

                      Vishal Pathak

                      Vishal Pathak is an IT professional with over six years of experience of working in the BI space. He is specialized in Oracle APEX and integrating technologies on a heterogeneous system. His skills include an array of technologies such as Oracle APEX, Oracle BI Publisher, OBIEE, BPEL, PL/SQL, JEE, Jasper Reports, jQuery, and HTML 5. He has a degree in Electrical and Electronics Engineering from the Birla Institute of Technology, Mesra. He has worked with multinational giants such as TCS, Wipro, Capgemini, and CTS. He has led and worked on many huge Business Intelligence implementations across diverse industry sectors. Some of the major clients that he has worked with include British Telecommunications, Uninor, Department of Social Services (LA DPSS), Marriot and Sony DADC. He is also a Sun Certified Java Programmer and an Oracle Certified Associate and blogs about his technical thoughts at He lives in India and he loves to trek frequently. Sitting in a secluded part of his garden, thinking about the world and its numerous complexities, and appreciating its beauty is one of his favorite activities.
                      Sorry, we don't have any reviews for this title yet.

                      Code Downloads

                      Download the code and support files for this book.

                      Submit Errata

                      Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                      Sample chapters

                      You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                      Frequently bought together

                      Oracle APEX 4.2 Reporting +    Oracle E-Business Suite Financials R12: A Functionality Guide =
                      50% Off
                      the second eBook
                      Price for both: $52.20

                      Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                      What you will learn from this book

                      • Get to grips with the APEX architecture, its configurations, and how to set up an APEX environment on Weblogic
                      • Explore the uses of the very old Classic reports and learn to implement almost all possible reporting requirements using Classic reports
                      • Understand and work with a number of technologies that can be freely used with APEX to help you reduce your licensing cost
                      • Discover how to do a lot of new things using a combination of JavaScript, HTML, and Interactive reports
                      • Get to know the advanced features of APEX along with a few Oracle 11g database features
                      • Learn about a number of techniques to tune an APEX application that will improve your customer satisfaction

                      In Detail

                      The biggest challenge in the reporting world is to reduce the overall project cost by picking a tool that minimizes effort and time and to ensure an enriching user experience. Oracle APEX, a 4GL technology, with its unique features such as low implementation time and flexibility, aids us in creating performance-tuned applications with minimum hassle.

                      "Oracle APEX 4.2 Reporting" is a unique blend of fascinating solutions and intriguing integrations which gives you a 360 degree view of the reporting solutions available to you on the market. It showcases advanced APEX solutions that will empower you to fulfill all kinds of tricky requirements of the reporting world. Live applications support the discussions in the text, enabling you to perform your own experiments on prebuilt applications to take your learning to new heights.

                      "Oracle APEX 4.2 Reporting" will help you build a well-founded understanding of Oracle APEX along with most of the reporting technologies used today. It is written with the idea of being as practical as possible so that you reap the benefits from day one.

                      Starting with a brief introduction to the architecture of APEX and installation to enable you to see the applications provided with the book in action, we then move on to the uses of Classic and Interactive reports and explore the advanced features of APEX. We will also explore the most widely used reporting solutions, which is then followed by a brief discussion on BPEL, which is like the glue that can gel any number of tools together. Oracle 4.2 APEX Reporting concludes with several ways of tuning an APEX application, as good performance is the heart of customer satisfaction.


                      "Oracle APEX 4.2 Reporting" is a practical tutorial for intermediate to advanced use, with plenty of step-by-step instructions and business scenarios for understanding and implementing the ins and outs of making reports.

                      Who this book is for

                      "Oracle APEX 4.2 Reporting" is for you if you design or develop advanced solutions in APEX or wish to know about the advanced features of APEX. If you wish to have a 360 degree view of reporting technologies or work in a complex heterogeneous enterprise, this is a must-have.

                      Code Download and Errata
                      Packt Anytime, Anywhere
                      Register Books
                      Print Upgrades
                      eBook Downloads
                      Video Support
                      Contact Us
                      Awards Voting Nominations Previous Winners
                      Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                      Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software