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.
Create Excel Worksheet
As you know PowerOLAP® application allows you to create a dynamically connected bi-directional Excel worksheet from a Slice of a Cube. It is dynamic in that the worksheet data values reflect data updates and changes made in PowerOLAP®application.
PowerOLAP® software creates the worksheet with a single click, establishing a bi-directional link with Excel. The connection between the two applications is bi-directional in that you may update and add data either from the Excel worksheet or from within a PowerOLAP slice.
To demonstrate the ease of creating an Excel worksheet from a PowerOLAP slice:
1. Open (or create) a Slice in PowerOLAP.
2. From the PowerOLAP ribbon go to the Slice tab and in the Worksheet control group click on the Worksheet icon or Create Excel Worksheet command and select a worksheet output (e.g., OLAPTable).
Alternatively, you may simply hit F8.