Hi there,

I have an Inventory Cube. It has an inventory fact table and a time
dimension. The time dimension has a hierarchy as show below:

[Year]->[Quarter]->[Month]->[Day]

What I want to do is to show inventory information whenever users
drilldown. The inventory report logic is as this:
Year's inventory equal last Quarter's inventory; Quarter's inventory
equals last Month's inventory; Month's inventory equals last Day's
inventory.

I think I can apply a custom rollup formula, ex
[Time].CurrentMember.LastChild. But I don't know how to add this custom
rollup formula to my Time dimension in AS 2005. I read the tutorial,
however it really a little bit hard to understand. Could anyone give me
a guideline to accomplish this job?

Best Regardly.