13. Context awareness

Inforiver provides built-in context awareness i.e., any comments, notes, data input, or even headers that you add will be updated dynamically based on external filter or slicer selection. You can even select writeback payload with Power BI filters.

When users enter comments or manually input data, the visual is unaware of the context, which can be set by a filter or a slicer in the report. In the example, notice how the comment entered for 'APAC' is still visible even after changing the filter to 'EMEA'.

With Inforiver, you can configure filter context, which ensures that Inforiver visuals are aware of context changes and responsive to changes in filters i.e. the comments, data input, writeback payload, etc are dynamically updated. Let's look at how to set up filter context.

Step 1: Click on the Filter Context button in the Insert ribbon.

Step 2: In the popup window, enter the table and field name for which context awareness is being set up. You can enter multiple tables and categories using the Add new link. In this case, we are setting up filter context for Subregions.

Step 3: Inforiver automatically generates the DAX code based on the tables and categories entered. Click on the Generate Dax button and copy the DAX.

Step 4: Create a new measure in your data model using the DAX generated in Step 3.

Step 5: Add the new measure to the Others (OM) visual parameter. It gets displayed in the report as well.

Step 6: Open the filter context configuration from the insert ribbon. You will now be able to select the new FILTERCONTEXT measure from the dropdown. You can enable/disable context awareness for notes and comments using the toggle switches. Click on save.

Let's see the context awareness feature in action by adding a notes column and setting a filter on APAC subregions.

Notice how the note is removed when we change the filter from APAC to EMEA.

1. Context awareness in report headers

Slicer selections will be reflected in header presets as well, if your report has been configured for filter context.

2. Context awareness in writeback

The filter selections are captured in the writeback table as separate columns. In the example below, the Segment and Region selections are captured as part of the writeback.

When the Segment and Region selection is changed to Corporate + Central, the notes and comments are inserted as separate rows in the snowflake destination and tagged against the changed categories.

3. Context awareness for data input fields

With Inforiver, manual data entry fields like textboxes, dropdowns, or numeric input will also be responsive to slicer selections. Notice how the data inputs change according to the filter selections in the gif below.

When working with context awareness, you need to select a category(ies) in the external filters for writeback and data input to be enabled.

4. Context awareness for writing back data input fields

The data input cells that are written back will also be determined based on filter selections. In the screenshot below, the report has 3 data input columns: Benchmark, Progress, and Status. Notice how the data input fields were written back to the snowflake destination for the Consumer + January + First Class selection.

When the selection is changed to Home Office + October + Standard Class, the data inputs corresponding to the selection are written back as shown below. The data input fields for each filter selection are captured as separate rows in the destination.

Last updated