Time dimension: have both calendar month and weekly
We are looking to create a model where one can see both weekly and calendar month data for all measures. What is the best way? For instance we could create a week-based (e.g. 4-4-5) model, then insert formulas for time, e.g. January 2015 = (Week1 * 5/7) + Week2 + Week3 + Week4 + (Week5 * 6/7). Thanks upfront for the inputs. Sebastien.