pcmobile:userguide:designer:8

Filter Block

A Slicer dropped on another slicer (already on the Canvas) will build a filter block and will automatically show its default representation and connect to the Page Parameter Group.
Filterblock

This menu will appear if you right click on a filter block on the Canvas.


This menu option is only available on single filter blocks. When creating a Miller Column, drag the boarders to get an appropriate size. This is an alternative design of the filter where the hierarchy always is exploded on the canvas.
Horizontal Miller Columns


This menu option is only available on single filter blocks. When creating a Miller Column, drag the boarders to get an appropriate size. This is an alternative design of the filter where the hierarchy always is exploded on the canvas.
Vertical Miller Columns


This menu option is only available when Miller Columns are chosen. This is the default design of the filter when the hierarchy is manually exploded.
Default filter layout


Initial selection / Gem settings

  • Show relevant members only - When checked, only members that have values for the selected measure will be visible.
  • Cubes - The cube the slicer is built upon
  • Measures - The measure to check if there are any values for the different members.

Initial selection / Slicer settings

  • Select Slicer - Select which slicer to work with. (Relevant in a Multi filter block).
  • Filter selection type - Choose between Filter selection (hardcoded), Default member (from the cube), Custom selection (defined by an MDX statement)
  • MDX Editor - Define the MDX statement to use, (valid for Custom selection)
  • Filter selection - Shows the hard coded value, (valid for Filter selection)


This feature is relevant when having lot of slicers in one filter block.
Configure grouping

To save space on a Canvas it is possible to group specific slicers into the group Others. It is just to check the slicers that should be grouped together.
Configure grouping

In this example Geography, Product and Salesperson are grouped together. When clicking on Other a menu will appear where it is possible to select which slicer to change. By combining a grouped filter block with a textbox it is possible to display all chosen filters.


Removes the filter block from the Canvas.

  • pcmobile/userguide/designer/8.txt
  • Last modified: 2014/07/17 08:12
  • by pcevli