Period dimension hierarchy:
Period has the children: BegBalance, YearTotal
YearTotal has the children: Q1, Q2, Q3, Q4