Period dimension hierarchy:
Period has the children: BegBalance, YearTotal
YearTotal has the children: TP1, TP2, TP3, TP4, TP5, TP6, TP7, TP8, TP9, TP10, TP11, TP12, TP13