Business Intelligence Properties
This topic provides a description of the OLAP 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.
The following OLAP BI properties display 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.
For more information about dimensions and star and snowflake schemas, see Introduction to Dimensions (SQL Server 2005 Books Online). |
|
AnalysisIdentifier |
Specifies the table field that is referenced as the dimension instance identifier. |
|
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
IsLookup property set to No
|
|
SingularLabel |
Specifies the caption for the dimension generated for the table. If you do not specify a value for the SingularLabel property, the Label property setting is used. |
The following OLAP BI 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.
|
|
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.
|
The following OLAP BI properties display 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 automatically 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.
|
|
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.
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. |
The following OLAP 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 automatically 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.
|
The following OLAP 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.
|
The OLAP BI 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.
Note