DB2 SQL OLAP : OnLine Analytical Processing BASIC
OLAP functions : OnLine Analytical Processing functions
Advantages-
- OLAP functions are specially helpful to create complex reports using a single SQL statement.
- 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 |
SQL OLAP
DB2 SQL OLAP : ROW_NUMBER
IBM i developer.