Hi, Experts

I need help on custom rollup. Say I have a cube
that tracks the book checkout for a library. I creatd a
fact table that cross joins between the time table and the
books table. When a book is out for a particular day, the
value '1' is assigned in the fact table. This way, I can
find out how many books are out for a particalar day
simply by adding up the '1's . Now, how do I find out how
many books are out for a week? Any ohter way beside
custom roll up?

Thanks

-ken

One of the ways to solve your problem would be to add a
week column in your "Time Table" and populate it with
week numbers (you can use one of the sql functions and
have it as formula for this field). Then you can use the
week number in your time dimension to track weekly counts.

Please let me know if you need further clarifications.

Thanks,
Abhinav Kumar
akumar (AT) itmag (DOT) com.au