Period dimension hierarchy:
Period has the children: BegBalance, YearTotal
YearTotal has the children: Q1, Q2, Q3, Q4
Q1 has the children: Jan, Feb, Mar
Q2 has the children: Apr, May, Jun
Q3 has the children: Jul, Aug, Sep
Q4 has the children: Oct, Nov, Dec