Download Quick Start Manual
Transcript
You can next select Model, Cube to see the Linked Cube itself, or select Model, Dimensions to see what Dimensions have been created. Ü To determine what a Slice looks like, select Slice, New: All the Fact Data in an MS Analysis Services cube has also been delivered to the PowerOLAP Cube, and appears in the Slice. To update the Fact Data in Cube, all you need to do is hit F9 (whether you are in PowerOLAP or an Excel worksheet created from a Slice. Concerning “write back”: provided the Cube was created using the ReadWrite capability and the cell into which you type data is a all Detail (i.e., leaf) Members and the Cube is enabled for “write-back” (and you have the requisite rights to do so), you can hit F9 also to send that data point to the MS Analysis Services cube. Finally, the Update Linked Cube function allows you to update the PowerOLAP cube with any new Meta Data and Fact Data changes that were made to the “provider” Cube (e.g., an MS Analysis Services cube): Ü Select Tools, PowerOLAP Services, Update Linked Cube. The Update Cube dialog appears: The dialog lists the Cubes that were created as a linked cube. Ü Select the Cube(s) to rebuild and click OK. 58 PowerOLAP Quick Start Manual