OLAP (online analytical processing) is an efficient method of data analysis on information stored in a relational database. Using OLAP you can analyze data on different dimensions, acquire result sets with subtotaled rows, and organize data into multidimensional cubes, all in a single SQL query. You can also use filters to drill down into the data, returning result sets quickly. This chapter describes the SQL/OLAP functionality that Sybase IQ supports.
The tables shown in OLAP examples are available in the
asiqdemo database.
