Saturday, February 4, 2012

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


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.
 
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)

No comments:

Post a Comment