Skip to main content
Version: I2023.4.1

Settings for Prediction-Defined Aggregates

These settings enable the AtScale engine to create prediction-defined aggregates.

To access these settings:

warning

Restriction: Your user ID must be a super user.

  1. Choose Settings from the main navigation, select Engine. Use your browser Find to search for each setting.

Settings

AGGREGATE.SPECULATIVE.ENABLED
Set to True to activate the following settings that are related to prediction-defined aggregates.

The default is True.

AGGREGATE.SPECULATIVE.ALLMEMBER.ENABLED
Set to True to enable the AtScale engine to create all-member aggregates for the current organization when new projects are published for the first time and when projects are republished.

The default is True.

AGGREGATE.SPECULATIVE.DIMENSIONAL.ENABLED
Set to True to enable the AtScale engine to create dimension-only aggregates for the current organization when new projects are published for the first time and when projects are republished. This type of aggregate is used for populating filters in client BI applications, such as Tableau and Microsoft Excel.

The default is True.

AGGREGATE.SPECULATIVE.DIMENSIONAL.MINCOMPRESSIONRATIO
Specify the ratio as the number of rows in the full dimension dataset divided by the number of rows in the proposed aggregate for a level in the dimensional hierarchy.

For example, for a Date dimension, the lowest level in the hierarchy might be Day. The number of rows in an aggregate defined on Day would be the same number of rows in the dataset overall. There would be no aggregation. However, an aggregate defined on a higher level in the hierarchy, such as Quarter, would aggregate the data and therefore have a compression ratio. The level Year would aggregate further and have a higher compression ratio.

The default compression ratio is 10.

AGGREGATE.SPECULATIVE.SUPERAGGREGATE.ENABLED
Set to True to allow the AtScale engine to define and create instances of super aggregate tables. Super aggregates, a type of prediction-defined aggregate, contain all keys in a fact dataset. They also contain all degenerate dimensions for which a fact dataset contains values at all levels in the dimensional hierarchies.

Whether or not a super aggregate is defined from a fact table is determined by calculations that are based on AGGREGATE.SPECULATIVE.SUPERAGGREGATE.COMPRESSION.

AGGREGATE.SPECULATIVE.SUPERAGGREGATE.COMPRESSION
Specify a value of the Double data type. The AtScale engine, when it considers whether to define a super aggregate table for a fact dataset, divides the number of rows in the dataset by the value that you specify for this setting. If the estimated number of rows in the super aggregate table is less than or equal to the resulting quotient, then the engine defines the super aggregate table.

The default value is 2.0.

Related concepts
Types of Aggregate Tables in AtScale