Creating a Slice View
PowerOLAP® provides a method for looking into a Cube to view and input data. This means of viewing and inputting data is known as “creating a Slice.” A Slice is a two-dimensional view of a Cube that arranges data in a grid, just as a spreadsheet does. You can create Slices “on the fly” to see any view of a Cube, or you can save and re-open Slices for ongoing data viewing or inputting. Finally, as you will see, you can instantaneously create an Excel spreadsheet from any Slice view.
To create a Slice called Regions by Accounts:
1. From the PowerOLAP ribbon, go to Slice tab then in the Slice control group select the New Slice command.
The following New Slice dialog box is opened.
2. With the Current Year Budget cube selected, click OK.
3. In the Slice tab of the PowerOLAP ribbon, go to the Worksheet control group and and select the Recalculate command; Alternatively you may press F9.
4. From the PowerOLAP ribbon, go to the Slice tab and in the Slice control group select Save Slice As command to save the slice.
5. Type the in the Slice Name text box. For this exercise, name the slice as Regions by Accounts.
6. Click OK.
You are returned to the Slice—note that both the Cube name, Current Year Budget, followed by the Slice name, Regions by Accounts, appear in the title bar, boxed in the succeeding figure.
You can also use the Save Slice Icon whenever you want to save the changes or modifications you made into the Slice.
PowerOLAP’s default calculation mode is set to Manual. Thus, when you make changes to a Slice, you will need to Press F9 (or the calculator button on the menu bar) to see those changes reflected in the Slice.
You can change the calculation mode to Automatic by accessing the Options dialog from the Home tab then enabling the Automatic option as the calculation mode.
7. From the PowerOLAP ribbon, go to Home tab then in the Edit control group, select the Options command. Then in the General tab, go to the Calculation mode section and enable the Automatic radio button.
8. Click OK to return to the main application window.