Setting New Slice Options
Expand Children Below Parent
1. Click on an aggregate member (e.g., 1st Quarter).
2. By clicking on the menu item PowerOLAP in the Add-Ins tab of the Excel ribbon, and choosing Options menu command, the following dialog box appears:
Changes are activated when a new Slice has been opened.
3. By choosing the Expand Children Below Parent checkbox and clicking OK, then expanding the aggregate member, the children of the Hierarchy are listed below the parent as shown in the figure below.
Indent Children on Rows
Aggregate Label Formatting
Detail Label Formatting
Use OLAPReadWrite formulas
Center Column Labels
Hide Nested Members
Example Slice with Nested Members
Example Slice with Nested members and using the Hide Nested Members option
“Leave PowerOLAP Add-Ins installed after closing sheets” Option:
When this option is selected, it improves speed performance when opening published Excel worksheets.