A new option for comparing current value to the moving average has been added. In this case, current values are compared to default or custom moving average.

To access the new setting, go to Metric Editor > Charting tab > Value Display > Show percent change from.

The Data Preview drawer that shows sample result set has been added to the Report Editor. It allows checking out the Report content before publishing it.

Depending on the Data Source used, the Data Preview drawer is opened by clicking Show data right after you generate a command or choose the Dataset View that should serve as a Report basis.

In previous versions, when sharing a snapshot report via email, only the latest iteration of this report was sent by design.

Starting from Version 5.1.1. the instance which is active in the report viewer at the moment of Report the sharing is going to be sent in the email along with a URL pointing to that specific historical instance. For example, if your Report is updated daily and today is Tuesday, but you open the Friday instance, the Friday instance is going to be sent when you share this Report.

In previous versions, when sharing a snapshot report via email, only the latest iteration of this report was sent by design.

Starting from Version 5.1.1. the instance which is active in the report viewer at the moment of Report the sharing is going to be sent in the email along with a URL pointing to that specific historical instance. For example, if your Report is updated daily and today is Tuesday, but you open the Friday instance, the Friday instance is going to be sent when you share this Report.

The Display Masks applied to numeric fields of a Dataset at the Dataset Editor > Data tab > Dataset Columns table are automatically applied to all Reports built from this Dataset.

We are gradually improving design and functionality for Pivot Tables which can be created for any Report at Report Editor > Report Content tab > Report Tables and Charts > + Pivot.

A new Data Source has been added to the Dimension Editors. All Datasets created in the system are saved as SQL tables. This functionality helps to build Dimensions that span multiple Datasets.

NOTE: In order to grant Power users access to this feature (create Metrics / Reports / Datasets from the "Existing Datasets - SQL" Data Source), grant this user a Privilege via User or Group Editors > Create Content Using Datasets.

A new mechanism for defining dimension access has been added to synchronize it to a User Map.

When users create a Dataset based on a User Map and then subsequently create Dimensioned Metrics from the Dataset using the same columns as are in the User Map, the Dimension security model can be defined via the User Map and have that information automatically synchronized with the user/dimension access mapping so that no manual access re-assignment is required.

To access a new feature, go to the Dimension Editor > Access tab. Two options are available there:

1. (Introduced in 5.1.2) Set Permissions via User Map: This option chnages page content dynamically allowing you to define a User Map from the drop-down list and Synchronize users who should be granted access to this Dimension.

2. Manual Permissions: Represents a traditional way of granting access to the Dimension via assigning individual Users or Groups to it. For more details, see:

[Group Access] Grant (View / Edit) Access to a Dimension

[User Access] Grant (View / Edit) Access to a Dimension

When sourcing data for Metrics, Reports, External Reports, Dimensions and Datasets from Sisense dashboard, you can pre-filter data before fetching it. This function allows focusing on the slice of data that you really need and exclude those values that are currently irrelevant for you and your research.

Filters can be added at Element Editor > Data tab.

In previous Versions, the PowerBI plugin functionality was limited to creating External Reports (collecting image upon the Trigger). We've extended its functionality to allow you extract data from PowerBI Tiles and PowerBI Datasets. You can now create Metrics, Reports, and Datasets sourced from PowerBI plugin.

Additionally, a Visual Editor has been added to the Microsoft PowerBI Plugin Editor > Data tab for an easy way of constructing Plugin commands.

Instead of constructing a command manually, a Visual Editor fetches all available fields from the source system, so all you have to do is choose those fields which are needed for collecting the data you are going to need for this element.  

Filters: We are gradualy updating all Metric Insights pluging with the functionality allowing to pre-filter the source data. In Version 5.1.2 this feature became available for Cognos and Business Objects.

Embedding visualizations into regular Reports: In the versions prior to 5.1.2,  we offered an ability to include external charts using links to other objects with an ability to adjust width and height of External Image. We have extended this functionality and it is now possible to combine Internal Report of any source and Cognos ot Business Objects Visualizations in a single Viewer. When configured with Bursts or Alerts, these mixed data can be delivered to users by email.

Our plugin collection has been expanded with a new Google Drive plugin. You can access your google drive files directly from Metric Insights.

To establish between Metric Insights and Google Drive, you should:

1. Create a Google Service Account
2. Share your Google Drive files with the newly created Service Account
3. Create a plugin in Metric Insights.

Each step is described at this article: Establish Connectivity to Google Drive

The New menu:

• Datasets and Dimensions can now be created from the Templates or in a regular way by choosing the "Custom" option.

The Content menu:

• Access to the full list of Datasets created in the system has been moved from the Admin menu.
• Alert Workflows: represents a new system feature: Managed Alerting

The Admin menu

• Object Templates is a new system function.
• Access to the full list of Datasets created in the system has been moved from the Content menu.

My Preferences menu:

• My Bursts are removed from this menu but now they can be created from the New menu by all types of Users (Admin, Power, Regular)
• My Schedules item has been removed as well. The process of Burst creation allows defining a personal distribution Schedule. In other cases, new Schedules are created by Admin users at Admin > Notification Schedules.

1. My Content: a new folder has been added to the Homepage > Left Sidebar below the Show All option. Only those elements, where a user is designated as a Business or Technical Owner are shown. For details refer to Grant Users Element View and Dimension Access via Element Ownership
2. Filters: Filter options have been slightly rearranged in Version 5.1 but no significant changed has been made to the search/grouping logic.

Most Popular Folder: This folder is populated with the tiles, representing the elements which either have been recently added to some of your favorite folders or were viewed by you within the last days. We added two new variables which can be used for defining the number of tiles to be shown in this folder:

• The default number of tiles shown in this folder is 5, but you can increase it at Admin > Utilities > Config Variables > MOST_POPULAR_FOLDER_TILE_COUNT.
• The amount of days to consider while scoring the "Most Popular" folder can be defined at Admin > Utilities > Config Variables > MOST_POPULAR_FOLDER_VIEW_DAYS.

New prompts and details have been added to the Element Viewers:

1. Certified: The certification icon, which was previously shown only on the respective tiles on a Homepage and Preview, has been added to the element Viewer.  Certification is a means for Admin and Power Users to identify elements that have been approved as being valid and accurate.  To certify an element, go to the Element Editor > Info tab. For more details refer to: Certifying an Element
2. Tags (previously named "Topics". Are defined at Element Editor > Info tab.): All tags assigned to the element are displayed on the top panel of the Viewer. Upon clicking a specific Tag label, you are redirected to a Homepage with content filtered down to only those elements which are tagged with the same label. For details, refer to: Create a Topic / Tag

Summary section (to display the Summary, go to the Quick Edit > Show Summary or Metric Editor > Charting tab > Show Summary :

3. Business / Technical Owner: For more details refer to Grant Users Element View and Dimension Access via Element Ownership
4. Data refreshed: shows the date of the last collected data point.

The more elements you create, the better filtering options you should have for find them in a snap.

You are now able to filter out the Homepage content down to multiple element Tags.

If your Homepage is opened on a specific folder or Category, the Tags option list is going to be limited to those Tag options, which are assigned to the elements belonging to this folder/category. To access all available Tags through this drop-down list, choose the Show All view at the top of the Left Sidebar.

Grid and List Views have been removed from the default Homepage settings. Only Tile View and List View are now available by default.

To make Grid and List Views available on the Homepage, access Admin > Utilities > Config Variables and find the following variables:

• SHOW_NEWS_VIEW,
• SHOW_GRID_VIEW and set them to "Y".

In previous Versions, Metric Insights Data Dependency feature was tied to data loading analysis specifically. For example, it could check whether < 70% of data is loaded, and if this condition was satisfied - stop any downstream processes.

In Version 5.1.1 a new Date mode has been added for an easy scan aimed at determining whether the new data has been added. In this mode the system checks whether any new rows have been added since the last run, meaning whether there are any new rows with a newer date.  If data dependency is satisfied, the trigger runs and this new data is added to the elements. If data dependency is not satisfied (there are no rows with newer dates), the trigger doesn't run and the elements are not updated.

The "Measure of" setting is no longer required for creating system elements. It was used to identify what is being computed in a Metric or Report (for example, Revenue, Sales, Orders, Customers, etc).

Instead, Metrics can be designated as additive or non-additive across time periods. This setting is available at the Metric Editor > Data tab.

Due to this change the following functionality has been removed or changed:

• Metric auto-naming. A user should compose a descriptive name while creating a new Metric. The name is defaulted to 'New Metric (nn)' where nn is next consecutive number.
• The See related drop-down list in the Metric Viewer is now populated differently. This drop-down now includes elements linked with this Metric by Tags only (formerly, Topics).
• Metric's Associations (defined at the Metric Editor > Associations tab) do not include elements united by the shared measure criteria. Measurement Interval (daily, weekly, etc.) is now a key criterion.
• Sharing Annotation with other Metrics, which was based on Metrics' Measures is not available anymore.
• Event Calendars can be applied to Metric Charts individually, by adding Tags or to Categories.

The Status Monitor page provides details on how well your Metric Insights system is functioning.

We reorganized page components and updated page design to fit the tiles into the logical groups:

• Data Collection
• Messages
• System Configuration
• System Stats

The tiles which are colored in red represent certain error and should be fixed.

The Import / Export Utility is a tool to push elements and their related objects from one Metric Insights instance to another.

Due to introduction of Datasets and User Maps, Import / Export Utility has been upgraded  to interact with the new system entitties and bacame more robust and intutive.

NOTE: Whenever a user chooses a Report or a Metric sourced from a Dataset to  the export package, the original Dataset is automatically added to the export package as well. This automated procedure eliminates the data loss probability.

The tabs in the Alert Inbox page have been reorganized and renamed. See below for details: