Stack or Nest Dimensions


You can show more than one Dimension as row or column headings. This is referred to as Stacking or Nesting Dimensions.

Create stacked Dimensions as follows:

1.   Click and drag more than one dimension to the Rows or Columns,
e.g., click and drag Product to the Page section, Region to  Columns, and Month above Sales Account in Rows.

2.   Press F9 to recalculate.

The following figure illustrates stacked Row dimensions. Notice how the slice shows all three Members for Sales Account within each of the Month members (you will see more dimension members if you expand the box or scroll down the grid).

3.    In the PowerOLAP ribbon, select Slice tab, Close Slice command to close the slice.

A dialog box will ask if you want to save the changes made to this slice.

4.   Click No.

Now when you reopen the Slice, it will have its last-saved Page, Columns and Rows configuration of dimensions.


Performing a constrained calculation on a Slice forces an immediate calculation of every possible data point in the data range requested, including those which will result in a constrained value. This differs from a non-constrained Slice in that a non-constrained Slice only calculates data points that are currently displayed in the PowerOLAP user interface. The successful completion of sizable constrained Slices is greatly impacted by design techniques and efficiencies within the database model.

To continue with the example, re-open Sales Account by Months.