Merge rows from dataset

Create rows within the Inforiver visual and merge the rows when the same dimension category becomes available in the source dataset.

In real-world scenarios, you may be expanding to new regions or adding new product lines - with the Static Row, Insert Rows(s), and Row Hierarchy options, you can add dimension categories on the fly. When the same category exists at the visual level and in your semantic model, you will be able to merge the rows from your dataset.

The icon indicates a manual input row. It will be replaced bywhen a row dimension category is available in the source system. Click the icon to merge the row, and then click Proceed in the Merge rows dialog box.

Data input fields will be locked for editing until the row is merged.

In this example, the LATAM and MENA hierarchies were created within Writeback Matrix. After the hierarchies were created at the visual level, the same hierarchies were added to the source - hence the merge rows icon is enabled.

Merge rows dialog box

Notice how the merge icon disappears and the data input field becomes editable after merging the EURIBOR row. When you merge rows, static rows are replaced with native rows; however, data input values are retained.

Merged row