Defining OLAP?


OLAP is short for Online Analytical Processing. It is a category of tools that allow data analysts to analyze multidimensional data.

An OLAP server is a tool that sits between the data warehouse and your computer. The OLAP server understands how data is organized in the database and has special functions for aggregating and presenting that data.

Common OLAP servers include products such as Essbase from Hyperion and SQL Server with Analysis Tools from Microsoft.

An OLAP server will take a few hundred million records from a data warehouse and create a multi-dimensional data structure. This structure, known as an OLAP cube, will make querying faster.



    Pivot Table Data Crunching
    Pivot Table Data Crunching for Microsoft Office Excel 2007
    ISBN: 0789736012
    EAN: 2147483647
    Year: 2003
    Pages: 140

    Similar book on Amazon

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net