I have a time analysis utility dimension called Period that has a member of
current. I created a few calculated members such as MTD, YTD, QTY, YearTtl,
MonthTtl. I also have 5 measures: M1, M2, M3, M4, M5. The time dem is Year,
Month, Day.

How do I create a calculated member that is:

(MTD of M1)/(MonTtl of (M1 + M2 + M3 + M4))
(YTD of M1)/(YearTtl of (M1 + M2 + M3 + M4))

Thanks for any help.

Do I need two calculated members for that?
Any thoughts, please.

"christy" wrote:

You could implement it as a single calculated measure, depending on how
you determine which of the 2 expressions to use - is it based on the
level of [Time].CurrentMember?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Yes. It is based on [Time].CurrentMember

If the currementmemeberis 02/23/2006 then

MTD(02/01/06 to 02/23/06) of M1 divided by MonthTtl(whole month of 02/2006)
of (M1 + M2 + M3 + M4).




"Deepak Puri" wrote:

Then try this calculated measure expression:

[Measures].[M1]) /
Sum({[Time].Parent},
[Measures].[M1] + [Measures].[M2]
+ [Measures].[M3] + [Measures].[M4])

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***