Notes
This feature is enabled through licensing. Check Home tab/Options
command/Licensing to see if Analysis Services functionality is
enabled on your system.
PowerOLAP® Services is a dynamic front-end capability to Microsoft Analysis Services Cubes and to other OLE DB for OLAP – compliant Cubes.
PowerOLAP® Services can be employed for a number of critical uses, particularly given the power afforded the user in the PowerOLAP Cube Modeler. Dimensions can be added ”going forward” in the PowerOLAP Cube with a few clicks. Data can be sent into new Cubes created in PowerOLAP®, via the Formula writer or via the Transfer Cube feature (for this feature, refer to the Import and Export section of the PowerOLAP® User Manual).
With the Cubes now in PowerOLAP®, you can use all familiar spreadsheet capabilities, with no loss of the everyday and powerful features Excel affords you.