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.
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 ...