Skip to main content

Other Model Settings

The following settings configure other model behavior.

metadataExport.driver.type​

  • Type: string
  • Default:

The type of driver metadata files such as Tableau .tds or LookerML files should be generated for.

Supported values:

  • thrift
  • postgres

xmla.discover.properties.daxdialect​

  • Type: string
  • Default:

The base version of properties to return.

Supported values:

  • legacy
  • superdaxmd
  • tabular

schema.userDefinedMember.defaultExcelPivotTableProperty​

  • Type: boolean
  • Default: true

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.

tableau.rawSqlAggs.enabled​

  • Type: boolean
  • Default: false

When set to true, AtScale wraps metrics and calculations in the Tableau type-specific rawsqlagg_* function call, which prevents Tableau from aggregating data on the client-side when collapsing the hierarchy.

This setting is only applied when the query.language.sql.preventClientSideAggregation global setting is set to true. For more information, see Query Settings.

Important

If you use AtScale's calculation groups feature with Tableau, it is highly recommended that you enable this setting to avoid client-side data aggregation that will produce incorrect results.