We used dimensions for CurrentDay, CurrentWeek, CurrentMonth, etc. to make this easier for the user to display the Children.

This worked very well for Production and Sales Reports.

For example, YTD, MTD, along with the Current Week in daily buckets to see the progression throughout the week.

A little extra work on the backend can simplify things quite a bit sometimes.

We also had a Future Time dimension, to allow for Production Plan (or other strategic plans) to measure how you are tracking to expectations.