Enterprise features

As mentioned in manual input columns, Inforiver Enterprise provides additional features compared to Inforiver Premium Matrix.

1. Data type - Person

2. Track changes at row level using the last updated at/by columns

3. List of values (LOV) from dimensions or other Power BI datasets

You need to sign in to access the Enterprise features.

Let's take a detailed look.

1. Person

In the 'Data input' dropdown, you can now see an additional type called Person. Once a data input column is added in Inforiver Enterprise, two columns – Last updated at and last updated by get enabled. These are covered in track changes at the row level.

Data input column type - Person

a) Click on 'Person'. The person column side panel is shown in the below image.

You can choose to insert as a visual measure or column. Entry can be enabled or disabled in the total/subtotal rows using the 'Allow entry on total/subtotal rows' checkbox. Input access can be configured using the 'Allow input' option.

Click 'Create'.

Person column properties

b) The person column gets inserted. Double-click on any of the cells. You can see a list of the users within the organization. Select any of the users.

List of users

c) Start typing a name or scroll to find the desired user. Click on the username.

Selecting a username

d) You can also select multiple users if required.

Selecting multiple users

e) Click 'Enter' to save the data. You can see the user's name displayed as shown below.

Person name captured

2. Last updated at/by

You can track changes at the row level using the two columns – 'Last updated at' and 'Last updated by' which capture metadata for changes in the data input columns.

These are enabled once you add a data input column and can be found in the data input dropdown. Select/deselect to show/hide columns. They can also be enabled/disabled from the ‘Manage columns’ dropdown.

Last updated at/by columns

3. List of values (LOV)

For the 'Single select' and 'Multi select' columns, a list of values (LOV) can be created from your Power BI datasets or from other dimensions like Master Data reference fields as shown in the below video.

List of values from Power BI datasets

Let's create a LOV from the datasets for a multi-select column.

a) In the multi-select column side panel, click on 'Datasets'.

Datasets option

b) You can see a dialog box as shown below.

Add options from datasets window

c) You can select the Power BI workspace from the 'Workspace' dropdown.

Workspace selection

d) The datasets available in the selected workspace are auto populated. You can select the desired dataset from the dropdown.

Dataset selection

e) Select the table from the 'Table' dropdown.

Table selection

f) All the columns available in the table are listed. You can select the column based on which the LOV is to be created.

Column selection

g) The unique elements in the selected column are listed as options. You can select all of them or unselect those that are not required. Click 'Apply'.

LOV created

h) The selected options are displayed in the side panel as shown below. Click 'Create'.

LOV created

i) Double-click on a cell in the multi-select column. Select the options as required and press 'Enter'.

Using the dropdown

j) The selections are displayed as shown in the below image.

Multi-select column

In the next section, we'll be covering quick formulas.