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'.

Context unaware

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.

Filter context navigation

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.

Add table and category

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.

Generate DAX

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

Create new measure

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

Add measure to others parameter

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.

Filter context configuration

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

Add notes

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

Filter context in action

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.

Filter context for header presets

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.

Writeback for Home Office + West selection

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.

Writeback for Corporate + Central selection

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.

Data inputs changing in response to filter selections

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.

Writeback for data input columns based on external filter 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.

Writeback for data input fields after changing the selection