Aggregate Creation Settings
You can view and modify the cube-level settings for speculative aggregates.
aggregate.speculative.allmember.enabled
: Set to True (default) to enable the AtScale engine to create, for each fact table, a speculative aggregate that contains only the measures in the corresponding fact table.aggregate.speculative.allmember.rerun.schemaupdates.enabled
: Whether or not to rerun all-member speculative aggregates on schema updates. The default value is True.aggregate.speculative.dimensional.enabled
: Set to True (default) to enable the AtScale engine to define dimension-only speculative aggregates, which are used to populate filters in BI-client software.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. The default value is 10.aggregate.speculative.dimensional.rerun.schemaupdates.enabled
: Whether or not to rerun dimensional speculative aggregates on schema updates. The default value is True.aggregate.speculative.enabled
: Set to True to activate the other aggregate.speculative. settings. The default value is True.aggregate.speculative.superaggregate.compression
: Compression of super aggregate against the data set on which gets created. The default value is 2.0.aggregate.speculative.superaggregate.enabled
: Set to True to enable building a super agg consisting of dimensions & measures as long as the row count is below a threshold. The default value is False.aggregate.speculative.superaggregate.rerun.schemaupdates.enabled
: Whether or not to rerun super aggregates on schema updates. The default value is True.aggregate.speculative.updatedstatstrigger.delay
: Time to allow stats updates to queue before re-running speculative aggregator. The default value is 10 seconds.