Informix includes many Advanced SQL OnLine Analytical Processing (OLAP) functions that are rarely used, and we will demonstrate how to take advantage of them. OLAP is Business Intelligence queries that allow users to perform reporting for sales, marketing, inventory control, business processes, and many other functions. Typically it would require a multi-dimensional database. SQL OLAP functions allow you to roll-up, roll-down and slice and dice your data. We will demonstrate examples of Window Partitioning of data (before and after group by), Ranking, using row numbers, and before and after rows using ANSI SQL-99 standards, known as the Elementary OLAP package.