The term OLAP (Online analytical processing) was created as a slight modification of the traditional database term online transaction processing (OLTP). OLAP performs multidimensional analysis of business data and provides the capability for complex calculations and trend analysis. 1,455 more words
Tags » Rollup
ROLLUP, CUBE, and GROUPING SETS Operators have been around since SQL Server 2005. These operators are extensions of the GROUP BY clause.
The GROUPING SETS operator might be introduced later in SQL Server 2008. 842 more words