Hi, I'm working with a server Time dimension which one of it's many purposes is to provide sales analysis by Reporting week. I'm using the property ReportingWeekToMonthPattern to divide the months in weeks but none of the default values is good to me {4-4-5 | 4-5-4 | 544}. According to the business rules, the pattern is not that regular and instead, I need this exact pattern that includes the 12 months of the year:
4-4-5-4-4-5-4-5-4-4-5-4
That is, the first half of the year with a 4-4-5 pattern, and the second half with a 4-5-4 pattern. Is this possible to set in the dimension?
Thanks in advance,
RAH
I don't think you can do this using a server time dimension. You would probably need to create a dimension table and build your time dimension off it. That way you can do pretty much anything you like.
No comments:
Post a Comment