Insert measure from bridge
Last updated
Was this helpful?
Reporting & Writeback Matrix Docs
Last updated
Was this helpful?
Just like we inserted rows, we can also insert data input measures from one visual into another visual. We will demonstrate this with an example.
Consider two reports: one that has the employee salary details at the lowest hierarchical level (Org > Dept > Job Title > Employee > Salary) and another that has the aggregated salary data rolled up to the department level (Org > Dept).
Let us assume we want to include the data input measure 'Additional Bonus', from the first visual to the second visual. Here are the steps involved:
STEP 1: Create a bridge with the source visual using the steps illustrated here. The bridge is created as below:
STEP 2: Perform the required transformations on the bridge source, if necessary.
In this example, we need to remove the row categories from the source that are not present in the target visual. Click on Pivot Table, remove the categories and click Apply.
The result is shown below. Note that we need to insert the highlighted data input measures into the target visual.
STEP 3: Map the dimensions between the source and the target visuals for integration. The steps are illustrated here.
STEP 4: Using Insert Measure option, insert the measures into the target visual.
Click on InfoBridge -> Insert Measure In the target visual. You can also use Data Input -> Import from Infobridge to insert an Infobridge measure.
In the side panel, select the required mapping from the dropdown, the measure to be included, and click Create.
The measure is now inserted. It can be managed similar to Inforiver data input measure.
Measures sourced from a bridge are read-only and cannot be directly edited. Values can be updated via the adjustment workflow.
Navigate to Manage Columns and click the icon to view and directly navigate to the source bridge and query. This enables you to trace and manage rows inserted from different bridges.
