Share via


Business Intelligence Properties

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

This topic provides a description of the Business Intelligence (BI) properties in Microsoft Dynamics AX that are used to define cubes that can be deployed to a SQL Server Analysis Services database. Property descriptions are divided into the following categories.

Table Properties

Table Field Properties

Extended Data Type Properties

Enumeration Properties

Perspective Properties

Perspective Table Properties

Table Properties

The following properties are in the Properties sheet when a table is selected in the Application Object Tree (AOT).

Property

Description

IsLookup

Determines whether to generate a consolidated dimension or a distinct dimension. You can specify one of the following values.

  • Yes - Indicates that attributes from the table are to be consolidated into the parent dimension (star schema).

  • No - Indicates that a separate dimension is to be generated for the table (snowflake schema).

Note

If a perspective contains a table that has a surrogate foreign key and the IsLookup property is set to Yes, the dimension usage between the measure group and dimension will not get generated in the perspective. Instead, use a view to retain the relationship.

For more information about dimensions and star and snowflake schemas, see Introduction to Dimensions (SQL Server Books Online).

AnalysisIdentifier

Specifies the table field that is referenced as the dimension instance identifier. The AnalysisIdentifier property sets the NameColumn property on the key attribute of the dimension. The Name property determines the value that is displayed by the key attribute.

The key attribute is inferred from the indexes of the table where AllowDuplicates is false and all the fields in the index are in the view or table of the perspective.

AnalysisDimensionType

Determines the type of dimension created based on the IsLookup property setting. You can specify one of the following values.

IsLookup property set to Yes

  • Auto - Specifies that the table may contain factual as well as dimensional data. The BI Wizard will extract dimensional data and create dimensions and attributes while factual data will be extracted to create measures. One child dimension is created with attributes from the parent table.

  • MasterInner - Specifies an inner (full) join to create relationships with this table to the child table. Each record combination for this table and the child table are generated in the dimension.One child dimension is created with attributes from the parent table.

  • MasterLeftOuter - Specifies a left outer join to create relationships with this table to the child table. Dimensions will have additional attributes based on values in this table that can also be empty. One child dimension is created with attributes from the parent table.

  • Transaction - Specifies that the table should strictly be used to generate factual data (measures). This setting should be used when a table only contains transactional data. One child dimension is created containing only enumeration fields from the table.

IsLookup property set to No

  • Auto - Specifies that the table may contain factual as well as dimensional data. The BI Wizard will extract dimensional data and create dimensions and attributes while factual data will be extracted to create measures. One parent and child dimension is created.

  • MasterInner - Not applicable. Same as Auto.

  • MasterLeftOuter - Not applicable. Same as Auto.

  • Transaction - Specifies that the table should strictly be used to generate factual data (measures). This setting should be used when a table only contains transactional data. One child dimension is created containing only enumeration values from the table.

AnalysisDimensionLabel

Names the dimension that is generated. If this property is not specified, the label of the table or view is used to name the generated dimension.

AnalysisKeyAttributeLabel

Names the key of the dimension that is generated. If this property is not specified, the label of the dimension is used to name the key attribute.

AnalysisMeasureGroupLabel

Names the measure group that is generated. If this property is not specified, the label of the table or view is used to name the generated measure group.

TitleField1

The key field for the records in the table to use as the fallback of the ID of the dimension. If you do not set this property, fields set as measures will not be included in the cube and the table will not be included in the data source view and after the cube is generated.

Table Field Properties

The following properties display in the Properties sheet when a field from table is selected in the AOT.

Property

Description

AnalysisLabel

Specifies the label for the field when it is used as a dimension attribute or measure. Only specify a label for this property when the label supplied for the Label property is not appropriate.

AnalysisUsage

Identifies the role of the field in the cube. You can specify one of the following values.

  • Attribute - The field is a dimension attribute.

  • Measure - The field is a measure.

  • Both - The field is both a dimension attribute and a measure.

  • None - The field is not a dimension attribute and not a measure.

  • Auto - The value of the AnalysisUsage property for the extended data type or enumeration that the field is based on is to be used.

AnalysisDefaultTotal

Determines the aggregate function for a measure. Use this property when AnalysisUsage is set to Measure. You can specify one of the following values.

  • Sum - Returns the sum of all the values in a set.

  • Count - Returns the number of non-null items in a set.

  • CountDistinct - Returns the number of distinct non-null items in a set.

  • Min - Returns the minimum value in a set.

  • Max - Returns the maximum value in a set.

  • None - No aggregate function is applied.

  • Auto - Applies to derived extended data types. The value of the AnalysisUsage property for the parent extended data type is to be used.

Note

Count and DistinctCount are the only aggregate function settings allowed on String fields by Analysis Services. If you set the AnalysisDefaultTotal value to an unsupported value, the cube will not build.

ExchangeRateDateField

The date to use to calculate the value in the consolidation currency. This optional property is used only with MST fields.

Extended Data Type Properties

The following properties are in the Properties sheet when an extended data type is selected in the AOT.

Property

Description

AnalysisUsage

Identifies the role of the extended data type in the cube. This setting is propagated to all table fields that reference the extended data type. However, the setting can be overridden on the table field. Specify one of the following values.

  • Attribute - A field that references the extended data type is a dimension attribute.

  • Measure - A field that references the extended data type is a measure.

  • Both - A field that references the extended data type is both a dimension attribute and a measure.

  • None - A field that references the extended data type is not a dimension attribute and not a measure.

  • Auto - Applies to derived extended data types. The value of the AnalysisUsage property for the parent extended data type is used.

    Note

    Extended data types that are based on enumerations cannot be measures.

AnalysisDefaultTotal

Determines the aggregate function for a measure. Use this property when AnalysisUsage is set to Measure. You can specify one of the following values.

  • Sum - Returns the sum of all the values in a set.

  • Count - Returns the number of non-null items in a set.

  • CountDistinct - Returns the number of distinct non-null items in a set.

  • Min - Returns the minimum value in a set.

  • Max - Returns the maximum value in a set.

  • None - No aggregate function is applied.

  • Auto - Applies to derived extended data types. The value of the AnalysisUsage property for the parent extended data type is used.

The aggregate function can be overridden at the field level. That is, you can change the aggregate function for the field using the AnalysisDefaultTotal property for the field.

Enumeration Properties

The following BI properties display in the Properties sheet when an enumeration is selected in the AOT.

Property

Description

AnalysisUsage

Identifies the role of the enumeration in a cube. This setting is propagated to all table fields that reference the enumeration. However, the setting can be overridden on the table field. Specify one of the following values.

  • Attribute - A field that references the enumeration is a dimension attribute.

  • None - A field that references the enumeration is not a dimension attribute.

Perspectives Properties

The following BI properties display in the Properties sheet when a perspective is selected in the AOT.

Property

Description

Usage

Specifies the materialization options for a Microsoft Dynamics AX perspective. You can specify one of the following values.

  • AdHocReporting - The perspective will be used to generate a transactional Semantic Model Definition Language (SMDL) model.

  • OLAP - The perspective will be used to generate a cube in a SQL Server Analysis Services (SSAS) Business Intelligence project.

  • Both - The perspective will be to generate both a transactional SDML model and a cube in a SSAS Business Intelligence project.

  • None - The perspective will not be materialized.

SharedDimensionContainer

Determines whether to share items in the perspective. When true, the items in the perspective are added to all other perspectives that are in the project and no cube is created for the perspective.

Perspective Table Properties

The perspective table properties are the same as the BI table properties. The BI property settings in the Perspectives node override BI property settings on the table itself. Use table property settings in the Perspectives node when you do not want to set properties on the table itself, for example, when a table will be used in multiple perspectives.

Perspective View Properties

The view properties are the same as the table properties, except for the IsLookup property. The IsLookup property is not supported on views in perspectives.

See also

How to: Specify Measures for a Cube

How to: Specify Dimensions and Attributes for a Cube

Create a perspective for a cube

Walkthrough: Creating a cube

Properties of AOT Elements