My time dimension has week wise planned data. user want to compare month data(planned data) with any day(actual data) of that month.
Eg: 2013.MAY(planned data) with MAY 23 2013(actual data).
i have week level planned data and day wise actual data.
here, i want to add one more dimension which contain days.
is there any better idea???
Thanks and Regards,