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