The Measurement dimension

In the cube there is a measurement dimension, which corresponds to the two value columns in the fact table; amount and transamount. In the target this dimension will have three members, with the option to add more in the future.

The members are as follows:

  • YTD - corresponds to the amount column in the XDBxx table. This is a year to date (YTD) value in the source.
  • Transaction YTD - corresponds to the transamount column.
  • Monthly - this is a computed period value. For the first period in a year: the period value = the YTD value. For all other periods: period value (period) = YTD (period) - (YTD (period-1). This calculation is implemented as a cube rule.
  • Weekly - similar to monthly, this is also a computed value.
  • Comment - for accounts (not journals).
  • Transaction Comment - for IC transactions (likely always empty).
  • Comment Count - this is a computed value created as the summary of all comments on leafs below. If there is a comment or transaction comment on a leaf, the comment count gets the value of 1.