New Features in 4.2
With the release of Incorta 4.2, there are a few new features in the platform that will have a tremendous amount of benefit for our customers. A few of these key features are enumerated below.
- Level Based Measures - A level based measure is a measure evaluated based on one or more predefined levels of aggregation (i.e. grouping dimension). Starting with Incorta Analytics 4.2, users can evaluate a measure for one or more aggregation levels in the same table Insight. For more info please refer to this article.
- Define Incorta Materialized Views (MV) with SQL - In previous version of Incorta, Materialized Views had to be defined using python. Often this meant creating a python script just to pull data into dataframes and run the dataframes through Spark SQL just to build a derived table. As of Incorta 4.2, users can just put in any ANSI-compliant SQL in their MV definition. For these straightforward MVs, there is no longer a need to write a PySpark program.
- Incorta derived tables - Users can now create derived tables using the familiar Incorta analyzer. Simply select Incorta as the table type and in the bottom pane create an insight by clicking on the pencil icon. Please refer to the screenshot below
- Top/Bottom N% functions - The Top/Bottom N% function represents the position of the current row relative to the set as a percentage. The following example displays the customers who contribute to the top 80% of revenue.
Incorta version 4.2 certainly touts other additional features, but these four are among those most requested by our customers. Please reach out to us on this community site with any questions or comments -- we'd love to hear from you.