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