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 a matrix report

The major learning outcomes of this section are as follows:

  • Creating matrix reports
  • Understanding and using the with clause
  • Understanding and using the pivot operator
  • Understanding string aggregation techniques
  • Data highlighting using CSS, jQuery, and Dynamic Actions
  • Advanced formatting using APEX templates.
  • Understanding and using the Dynamic Query region in APEX

Matrix reports also known as pivoted reports are helpful when we have a measure to be sliced and diced on two or more dimensions. For example, let's say, we want to know the count of people (measure) for every combination of shirt color (Dimension 1) and pant color (Dimension 2). A matrix report for this will look like the following:

 

Color

Apparel

Green

Yellow ...

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