PowerOLAP Excel Integration

This section concerns what may be the most important end-user feature of PowerOLAP®—the product's use of Excel as a front end. We will consider the PowerOLAP Add-In Menu and Toolbar; the different function for creating a worksheet (OLAPReadWrite, OLAPTable and OLAPPivot; the functions that appear in a worksheet (OLAPDatabase and OLAPMember); entering data through Excel; and generally working through Excel as a sophisticated user would—including the many ways of changing data views, and the use of database reference formulas that will enable to bring virtually any and all PowerOLAP data into Excel.

New Slice

OLAP Table

OLAP Pivot - Part 1

OLAP Pivot - Part 2

OLAP Query

OLAP ReadWrite

Standard PowerOLAP Integration

VBA Integration