Data model of the dimension in AX 2012

In this post I will describes the data model of the ledger dimensions and we will a scenarios that how the data is stored on the these tables

Data Model

Scenario: How an offset account (10110-D10-CC2) in the Lines Journal saved in the dimension.

Segmented control works with the DimensionStorage class to create the combination

So; we break apart the combination into each structure[10110 - D1] [CC2}. We first save the Account Structure portion of the combination. Then we save the Account/Advanced Rule structure portion (as there could be multiples added thru multiple rules). In the end, this is what that combination will look like across all 4 tables shown in the combination storage block in the Data model bound to the LedgerDimension.

Configure an account structure that looks likethis:Main Account + Department

Create an advanced rule attached to account structureto say that when you enter 10110 - D1 you also need to specify a CostCenter.

1. An Segmented entry control will look like this

2. As account structure configure there are 2 segments that must be filled.

3. Type 10110 and tabit looks like this:10110 -

4. Type D1 in the second segment and tab

5. As tab press we pick up the fact that a rule is attached and a 3rd dimension must be added to the combinationso it looks like this:10110 - D1 -

6. Now the user enters CC2and tabs from the control 10110 - D1 - CC2

DimensionAttributeValueCombination:

DisplayValue: "10110 - D1 – CC2"
RecId: 400

DimensionAttributeValueGroupCombination:

DimensionAttributeValueCombination: 400
DimensionAttributeValueGroup: 500
RecID: 201

DimensionAttributeValueGroupCombination:

DimensionAttributeValueCombination: 400
DimensionAttributeValueGroup: 501
RecID: 202

DimensionAttributeValueGroup:

DimensionHierarchy: AccountStructure(MA+DEPT)
RecID: 500

DimensionAttributeValueGroup:

DimensionHierarchy: AdavancedRule (CC)
RecID: 501

DimensionAttributeLevelValue:
              DimensionAttributeValueGroup: 500
              Ordinal: 1
              DimensionAttributeValue->10110
                RecId: 601

DimensionAttributeLevelValue:
              DimensionAttributeValueGroup: 500
              Ordinal: 2
              DimensionAttributeValue->D1
              RecId: 602

DimensionAttributeLevelValue:
              DimensionAttributeValueGroup: 501
              Ordinal: 1
              DimensionAttributeValue->CC2
              RecId: 602

To insert: [10110 - D1] [CC2] we need to insert above all records as summarized below.

· 1 record in DAVC
2 Records in DAVGC (to link the full combination to each sub-group)

· 2 records in DAVG (one for each grouping)

· 3 records in DALV (one for each segment)