Dimension Slicers

dimension slicers which simplify this process and make the creation of cube dynamic drop downs simple. Four display options are provided: • In cell tree view • Combo Box • ListBox • Buttons Grid Slicers: To add a slicer to a grid, right-click on the relevant dimension member , and choose XLCubed – ‘Add Dimension Slicer’. Note that grid slicers can be positioned where required (not restricted to the grid area). The default will be an in-cell treeview with the last active member selected. Once inserted, right click on the slicer and choose ‘Edit’ for configuration and design options. Choose the required slicer display type, and then using the member selector on the right choose the set of members to enable selection from. These can be either static lists of members, or dynamic selections such as children or / descendants at level, Level ‘x’ or even ranked lists etc. 3 Note that the slicer content can also be driven from an Excel cell (e.g. Children of E11’). A slicer which has been added to an individual grid can be used as the selection mechanism for multiple grids through the ‘Grid Links Dialog’. It can also update a specified range with the uniquename of the member chosen, which could for example be used as the argument for XL3Lookup formulae. Standalone Slicers A standalone slicer can also be added using the slicer button on the Ribbon. Here the required hierarchy is chosen from the list of available hierarchies, and dragged into the ‘Slicer Hierarchy’ control. From that point the setup is the same as with Grid Slicers. Standalone slicers will need to be manually linked into grids as required. For performance this is best done in the linked grids dialog, rather than populating an Excel cell and having the grids selected based on the populated range. Alternatively you could use them to drive other XLCubed or Excel formulae and then other reports/query tables.