O'Reilly logo

Oracle APEX 4.2 Reporting by Vishal Pathak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing time series reports

In this section, we will learn about some of the time series functions which help in the development of analytical reports in APEX.

I have created OEHR_TIME_DIM for displaying some of the time series reports. Most OLAP reports use a time dimension for analysis. The reports introduced in this section are special because of their queries. This section is designed to primarily display the quantum of analytical processing possible using SQL.

Creating aggregation on a partitioned time dimension region

We have seen grouping sets in the Using grouping sets and HTML formatting in a query section. Here we are going a step further by using the cube extension of the group by clause. We will also see the use of some aggregation ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required