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.