Settings for Prediction-Defined Aggregates
These settings enable the AtScale engine to create prediction-defined aggregates.
To access these settings:
Restriction: Your user ID must be a super user.
- 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