SQL OLAP

DB2 SQL OLAP : OnLine Analytical Processing BASIC


OLAP functions : OnLine Analytical Processing functions

Advantages-

  1. OLAP functions are specially helpful to create complex reports using a single SQL statement.
  2. OLAP functions provide multiple and very advance data grouping and ordering options which are not possible by simple “GROUP BY” and/or “ORDER BY” clauses.

Below is the list of available OLAP functions.

1. ROW_NUMBER For Sequencing
2. RANK
3. DENSE_RANK
4. ROLLUP For Grouping
5. CUBE
6. GROUPING
7. GROUPING SETS

IBM i developer.

View Comments
There are currently no comments.