Slice Commands
Create and Save a New Slice
PowerOLAP® offers alternative methods for creating a new Slice, from the Slice tab via the Manage Slices command. You have already seen how to create Slices using the New Slice command.
In the proceeding example, the UsingPO was used as the sample database.
To create Slices using Manage Slices command:
1. In the PowerOLAP ribbon, select Slice tab, Manage Slices command. The Slices dialog box appears.
2. Select another Cube by clicking the cube drop down button.
In this example, select Future Year Model.
3. Enter a <new Slice name> in the Slice text box.
In this example, name the new Slice as Slice 1.
4. Click the Add button.
The new Slice name appears in the Slice list box.
Tip
You can use the Enter key in place of clicking the Add button to enter new Slice names.
5. Click OK to close the dialog box.
To view the slice you have created:
1. From the PowerOLAP ribbon,select Slice tab, Open Slice command.
The Open Slice dialog box is displayed.
2. Select the appropriate Cube in the drop-down box(I.e., Future Year Model), then select the New Slice you have just created (I.e., Slice 1).
3. Click OK.
Re-Save Slices after Editing
![]()
Save Slice |
The Save Slice command is used to save changes to a previously saved and currently opened Slice. |
1. In the PowerOLAP ribbon, select Slice tab, Save Slice command.
2. Close the slice.
Open an Existing Slice
1. In the PowerOLAP ribbon, select Slice tab, Open Slice command. The Open Slice dialog appears. 2. Click OK to open the selected Slice. 3. Press F9 to update data view.
The Manage Slices command on the Slice tab also allows you to rename a Slice. You may want, for example, to change the name of a Slice to describe its contents after entering new data. To modify the name of a Slice: 1. In the PowerOLAP ribbon, select Model tab, Manage Slices command. The Slices dialog box is opened. 2. Select a Cube. In this example, choose the Future Year Model cube from the drop-down list. Available Slices for the selected Cube are shown. 3. Click a Slice whose name you want to change. Select the pre-existing slice, 4. Enter the <New Slice name> in the Slice text box. Change the name to read Region by Months. 5. Click the Rename button. This changes the name in the Slice list box, as shown in the figure below. 6. Click OK when complete to close the dialog.
The Manage Slices command on the Slice tab allows you to delete a Slice. You may want, for example, to delete a Slice that is no longer needed.
A Slice must be closed in order for you to delete it. To delete a Slice: 1. In the PowerOLAP ribbon, select Model tab, Manage Slices command. The Slice dialog box is opened. 2. Select a Cube. Available Slices for the selected Cube are shown. 3. Select a Slice to delete. 4. Click the Delete button. 5. Click OK when complete to close the dialog box.
Close an active Slice as follows: 1. In the PowerOLAP ribbon, select Slice tab, Close Slice command. 2. Click Yes if you want any changes made to the Slice to be saved.
All changes made while PowerOLAP® is open—including new Slices and data entered into Slices—are saved only once you have saved the database. |