Filtering Documents and Reports Using New Interactive Report Filters

To insert a new interactive report filter, use the Quick Access, Build, and Main panels.

In the Build panel→Report Element Format tab→Specific sub-tab, you can set in the Filter Properties section some parameters based on the filter type.

The available parameters change depending on the selected filter type:

• Operator (Calendar, Double Slider, Entry Field, Mono Combo, Multi Combo): Defines the operator that filters the targeted blocks.
• Minimum value, Maximum value, Increment (Slider, Double Slider, Spinner): Defines the filter range and its increment when the values are changed.
• Default value (Slider, Spinner): Defines the filter default value.
• Show search (Mono List, Multi List): To display a Search field to search the values.
• Show footer (Multi List): To display an button to confirm the selected values.
• Show week numbers (Calendar): To display week numbers before the week rows.
• Show input field (Calendar): To display an entry field where the user can manually enter the date.
• Start date label, End date label (Date Range): Defines the labels used to identify the two dates.
• Display All button (Toggle Buttons): To display a button to select all values.
• Number of buttons (Toggle Buttons): Defines the maximum number of buttons to display.

Other sections contain parameters that are supported by all filters.

• Title: To display a label on top of the filter. By default, it is the name of the object used as a filter, but you can modify it in the Text text field. You can select this title justification through the Alignment buttons.
• Filter Target: To select the report elements, including other filter reports elements, in the report to filter. By default, they are all selected.
• Font: To define the fonts of all strings displayed by the filter.

When you select values in the new interactive report filter, the report updates to display only the selected targets.

To clear your selections, select the Reset button in the filter’s floating toolbar.

For more information about this topic, please read SAP BusinessObjects Web Intelligence User's Guide

You can use the Show/Hide element to hide or show other elements in your report by adding a group of buttons.

To insert a Show/Hide element, use the Quick Access panel.

In the Build panel→Report Element Format tab→Specific sub-tab, you can select the Add Group icon to add a new button.

In the Create Group dialog box:

• Enter the text to display in the button.
• Select the report elements to display when this button is clicked.

You can add as many buttons as you need. To change the order of the buttons, use the arrow buttons or move them by dragging.

When you click a Show/Hide button in the report:

• The report elements linked to that button appear.
• The report elements linked to other buttons are hidden.
• The report elements not linked to any button always appear.

For more information about this topic, please read SAP BusinessObjects Web Intelligence User's Guide

You may need to share an interactive Web Intelligence document with someone who does not have access to BusinessObjects. You might also want to send a dashboard that works offline.

The WIDX format helps you do this. This section explains what WIDX is and how you can use it.

A WIDX file is an export format that combines your report and its data into one secure file.

The WIDX export format offers these advantages:

• You do not need to install any application. You only need a Chrome or Edge browser.
• You do not need access to a SAP BI server to open the file.
• You can use the file without an internet connection.
• You do not need an extra license to use these features.
• You can interact with the file in the same way as with a Web Intelligence document (.WID).

You can create a WIDX file in a several common places like the Web Intelligence export dialog box, the BI Launch Pad schedule feature, or the BI Launch Pad publishing feature.

Web Intelligence then bundles everything into a single ZIP file for easy download.

To open it, unzip the file and double-click the shortcut inside.

An interactive application opens on your screen.

You can fully interact with this report:

• Apply filters and explore the data.
• Interact with charts and scroll through tables.
• Follow hyperlinks to external websites.

You can use all features even when you are offline.

WIDX has the following limitations in the initial release:

• You can view only one report, and only its first page.
• WIDX supports all new report elements, but does not support classic tables and charts.
• WIDX does not support links to other reports within the same document.
• WIDX does not support custom tooltips.
• You cannot refresh data saved in WIDX.

• Add interactive report filters, such as calendars, sliders, and combo lists, to create dynamic and user-friendly reports.
• Use Show/Hide elements to display or hide report sections with customizable buttons for improved report navigation.
• Export reports as WIDX files to share interactive documents that work offline and do not require additional software.
• Understand WIDX limitations, including support for only one report page and no data refresh or classic table/chart support.