Export (0) Print
Expand All

How to: Specify Dimensions and Attributes for a Cube

Dynamics AX 2009

The following procedures illustrate how to specify dimensions and attributes for a cube.

To specify a table as a dimension

  1. In the AOT, expand the Data Dictionary node.

  2. Do one of the following:

    • To specify a dimension directly on a table, expand the Tables node, right-click the table that you want to specify as a dimension, and then click Properties.

    • To specify a dimension on a perspective, expand the Perspectives node, expand the node for the perspective, expand the Tables node, right-click the table that you want to specify as a dimension, and then click Properties.

  3. In the Properties sheet, specify the following properties.

    Property

    Value

    IsLookup

    Combines the attributes defined in the table into a dimension based on a table that has relationship with this table and has been marked as a dimension table.

    AnalysisIdentifier

    The dimension instance identifier.

    AnalysisDimensionType

    The type of dimension to create.

For a detailed description of the Business Intelligence properties and their options, see Business Intelligence Properties.

Now that the dimension is defined, you need to add table fields to the dimension.

To specify a table field as an attribute on a table dimension

  1. In the AOT, expand the Data Dictionary node.

  2. Do one of the following:

    • To specify a dimension attribute directly on a table field, expand the Tables node, expand the node for the table, expand the Fields node, right-click the table field that you want to specify as a dimension attribute, and then click Properties.

    • To specify a dimension attribute on a table field in a perspective, expand the Perspectives node, expand the node for the perspective, expand the Tables node, expand the node for the table, expand the Fields node, right-click the table field that you want to specify as a dimension attribute, and then click Properties.

  3. In the Properties sheet, specify the following properties.

    Property

    Value

    AnalysisUsage

    Attribute

    AnalysisLabel

    A label for the measure. Only specify a label for this property when the label supplied for the Label property is not appropriate.

For a detailed description of the Business Intelligence properties and their options, see Business Intelligence Properties.

Now that the dimension is created, you can add it to a perspective for a cube. For more information, see How to: Create a Perspective for a Cube.

Community Additions

ADD
Show:
© 2014 Microsoft