Skip to main content

What's new in 6.0

6.0​

ActivePivot is now called Atoti Server.

New features​

  • DirectQuery:

    • Atoti can now work on top of an external databases. It is no longer mandatory to load the data in a Datastore.
    • A new Database API has been added to allow Atoti to transparently work on a Datastore or an external database.

  • Java version: Atoti Server is compatible with Java 11 and Java 17.

  • Partial Aggregate Providers: They can now be defined on a slice of data. One can specify values on a level to filter the facts that will be pre-aggregated.

  • Aggregation Functions: The POP_VAR, POP_STD, SAMPLE_VAR, and SAMPLE_STD aggregate functions have been added to the core. They are used to calculate the variance and standard deviation using the population and sample formulas. They can be used in dynamic aggregations by using the UserDefinedAggregationPostProcessor. A complete list of natively supported aggregation functions is available here, as well as guides on how to write your own functions.

  • Virtual Hierarchies: This is now fully available in 6.0. A virtual hierarchy is a new hierarchy implementation that does not store members in the cube. It represents a trade-off between a smaller memory footprint and faster commit times versus offering a slightly reduced set of features. At the moment:

    • member navigation between hierarchy members, as performed in Lead and Lag measures, are not allowed
    • MDX expressions including a virtual hierarchy must include the NON EMPTY keyword. In addition, if the expression describes a member expression the full member path must be provided
    • A virtual hierarchy cannot be slicing
    • Virtual hierarchy levels cannot be used as distributing fields.

  • Copper in distributed cubes (experimental) Copper calculations can now be defined in Query cubes. See documentation.

Improvements​

  • REST services were migrated to SpringMVC

  • Datastore Housekeeping:

    • The datastore API now provides additional operations to rebuild indexes, allowing to reduce their size and thus memory usage.
    • Empty partitions will be dropped automatically by the datastore at the end of transactions.

  • Distributed cubes: New option to disable the replication on distributed count, available when defining a query cube. This can speed up the evaluation of Mdx formulas.

  • New Content Server Rest Bulk API: API to do several operations in one call to reduce the latency.

  • Tracing: Tracing has been removed from APM and is now part of the core product. Please refer to the tracing documentation for the new API usage and details.