I have seen several references to using dimension hierarchies with a
standard and fiscal calendar as examples. I have created these and added to
a cube and am now attempting to make use of the multiple time dimensions.

In the calculated members, I need to use the lag function to get a total of
"last 4 weeks" or "last 8 weeks". Now that I have a choice of time
dimensions, do I need to have multiple versions of each calculated member
that is coded to each of the time dimensions like this?

Measure: Last 4 Weeks - standard
Sum([Time.standard].CurrentMember.Lag(3):[Time.standard].CurrentMember,[Measures].[POS
Qty 1 Period])

*******************************

Measure: Last 4 Weeks - fiscal
Sum([Time.fiscal].CurrentMember.Lag(3):[Time.fiscal].CurrentMember,[Measures].[POS
Qty 1 Period])



someone tell me there is a better way! Please!

Jim