Layout Filters and Slicer Filters

This video shows how to create Layout Filters and Slicer Filters in Web Channel Dashboards. Layout Filters pass their values down into all the sub content when the submit button is clicked.

In the example a Company and Period range is passed to all reports and charts below them by using the same Filter name.  In addition Filter Slicers are demonstrated by clicking on a Customer Name to refresh the dashboard content to show just that Customer or Customers selected. Towards the end some styling options are shown ​

Sample files require SAP Business One Datamodel and sample database
Publisher – Import
TrainF4.pbqlist

Dashboard – Import
TrainF4.dbplist

Sample Dashboard

Notes:

When creating a Layout Filter the height of this area will usually be quite narrow around 40px.  This means that there will no be enough height to display lookup values if the default lookups are used.   To get around this convert the filter lookup to Dropdown Picklist or Lookup Windows.

Query Builder Filter Options – Dropdown Picklist

Publisher General Lookup settings – Lookup Window

Video