I'm looking to add a time dimension or to group on weeks automatically
which produce stats based on accounting periods which are sometimes 4
weeks long sometimes 5 weeks long but which always end on the last
Friday of each month.
(preferably to be done in OLAP cube but if not then in Excel after
weekly data extracted)


I wonder if anyone can point me in the right direction.

This is one of many reasons that it is essential to roll your own time
dimension. Meaning: Treat it like any other dimension; create a dimension
table that defines the hierarchy; don't derive the dimension from a
date/time column. Then you get to decide what date rolls up to what period.

tom @ the domain below
www.tomchester.net


"Brian Hyam" <brian (AT) huntertraining (DOT) com> wrote