Skip to main content

Schema Settings

AtScale supports the following schema configuration settings.

schema.queryDataSets.allowed​

  • Default: true
  • Restart: Yes

Whether to allow Query Datasets.

schema.softPublish.aggs.enable​

  • Default: false
  • Restart: No

If enabled, system-defined aggregates may be built for catalogs that are soft deployed. (Soft deploying is primarily used by the Data Preview feature.)

schema.userDefinedMember.defaultExcelPivotTableProperty​

  • Default: true
  • Restart: No

Determines the default value of the is_excel_pivot_table_property SML property for secondary attributes that do not have it set:

  • true: is_excel_pivot_table_property is set to true when the model is deployed. The secondary attribute can be added to Excel pivot tables.
  • false: is_excel_pivot_table_property is set to false when the model is deployed. The secondary attribute cannot be added to Excel pivot tables.

For more information, see Using MDX User-Defined Member Properties and the AtScale SML Object Documentation on GitHub.

schema.validate.calculations​

  • Default: true
  • Restart: No

Whether to validate calculations.

schema.validate.defaultMembers​

  • Default: true
  • Restart: No

Whether to validate default member expressions.