The Production and Plan Cubes

Their database keeps information on production by day, but they only plan by month. Thus they have a pair of cubes, Production and Plan:

The key dimensional difference between these cubes is in their handling of time. Actual values in the Production cube are tracked by day in the Date dimension, but values in the Plan cube are tracked only by month in the Month dimension.

As the months go by, Fishcakes International executives want to see previous months data from the Production cube appear in the appropriate months in the Plan cube. Thus, January values from Production, which are consolidated, should appear as January values in the Plan cube, where January is a leaf element. The reason Fishcakes International maintains a separate cube for Plan data is not to see the monthly aggregates created in the Production cube (this you could easily do directly in the Production cube) but rather to allow for the manual entry of plan numbers at the month level directly into the Plan cube.