Manage inserted measures & columns
Last updated
Was this helpful?
Last updated
Was this helpful?
Measures and columns inserted in the visual such as calculations or data input columns can be managed using the Manage Measures option.
Similar to the Manage Rows option, the Manage Measures option displays a list of inserted columns/measures with options to edit, delete, or hide them. All the measures created in a visual can be viewed in the Measures tab. Visual columns can be viewed and managed in the Columns tab.
In addition, there is also an 'Insert New' option which lets you insert calculated columns or data input columns right from this panel.
The Manage Measures side panel has a Settings tab that lets you control and configure important settings concerning the rows and measures, such as user permissions, time interval mapping, and row ID mapping.
Inforiver enterprise allows setting explicit read/write access for specific users on data input and forecast columns.
To set it, click Insert -> Manage Measures -> Settings -> Manage in the Data Input Access. You can add the required users in the pop-up window.
You can also choose whether to use Power BI sorting or Inforiver sorting. When the Sort toggle is enabled, any sorting changes made at Power BI level will not be reflected in the visual. In the example, notice how the Power BI sorting is not applied on the Quarter when the Sort toggle is enabled.
Inforiver automatically assigns a dimension ID to each row dimension to uniquely identify them. This mapping helps to track and manage them, especially during operations like writeback. Visual components such as formatting, notes, comments, and data inputs added to the rows are also linked to the dimension IDs.
When row dimensions are renamed/changed, we might lose these visual elements added. To avoid this, Inforiver allows us to map the row dimensions to a constant dimension ID.
In the example below, we’ve applied formatting, added notes, and comments, and added data inputs to the products, Juices and Tea & Coffee.
The visual elements were lost after the product names were renamed to Fruit Juices and Chai & Coffee respectively.
To avoid this, let us map the dimension IDs to a constant dimension, such as the Product ID instead of the Product Name. To do so, navigate to Insert -> Manage Measures -> Settings -> Row ID mapping -> Manage.
The image below shows the default row dimension ID mapping.
Let us map the 'Product Name' to the constant dimension, 'Product ID' as shown below. Click Apply.
Note that changing the mapping removes all the initial formatting and visual elements associated with it.
Any formatting, notes, comments, and data inputs added after mapping with the constant dimension ID are retained as shown below, including during the writeback.
Updates due to skipped row ID dimensions reflected in writeback data
After mapping the row IDs to a constant dimension, not only the visual formatting, data changes, notes, comments, etc., are retained in the report but also captured in the writeback data promptly.
The report below shows the default mapping, followed by the results of the writeback data.
After manually mapping the row dimension to a constant ID like the Product ID, any changes made in the report are also effectively captured in the writeback. In the image below, you can see the updated records in the report that are also reflected in the writeback data.
You can retain point-in-time measure values with the new scheduled backup feature. The measure values are captured as separate read-only visual columns within the same visual. With this feature, you can easily calculate historical variances and analyze fluctuations in your numbers.
Navigate to Manage Measures > Settings > Schedule Backups for Measure to create monthly, weekly, or daily schedules.
Start and End date: Specify the time frame during which the measure should be backed up.
Schedule Time: The time and timezone at which the backup job should be triggered.
Frequency: Opt for daily/weekly/monthly schedules.
For daily backups, you can specify the number of backups to create. For weekly schedules, you can select the day of the week to take a backup. For monthly schedules, you can specify which day of the month to take a backup on and additionally opt to take a backup on the last day of the month as well.
Measures: Select the measures that need to be backed up.
Backup name: Enter the name of the backup field.
You can run ad-hoc backups by clicking the Run now icon.
Measure backups will work only after the report is saved in Power BI. The report should also be created in a common workspace.
The image below shows a report with backed-up measures:
Measure backup jobs have dedicated logs that show the status of the backup, milestones, and the backups that are deleted when the limit is reached. Click the View jobs option from the Schedule Measure Backup side pane.
Scheduled measure backup logs:
When you have a date hierarchy in your rows/columns, you can use the time interval mapping to verify the formats that Inforiver auto-detects. Hover over theicon to view all the supported date formats.