Hi all,

I have a 2 level time dimension: Month, Week
The week level has an associated member property Interest
Rate. I'm hoping to take the average of the week's
respective interest rates and make that the month total.

Thanks in advance.

Mark

Use a custom member formula for the Month members. First, create a
calculated member in the cube equal to the following:
CREATE MEMBER [Measures].[Interest Rate] AS
'CDbl([Time].CurrentMember.Properties("Interest Rate"))'

Then, for the month members, the Total Interest Rate will be the following:
AVG( { [Time].[Month].CurrentMember.Children }, ( [Measures].[Interest
Rate] ) )

I'm guessing, but it should be close enough to get you started.
HTH,
Martin

"Mark Frank" <mark.a.frank (AT) wellsfargo (DOT) com> wrote