I've been experimenting and searching posts for a week and haven't been
able to figure out how to create a calculated member to show the the
following:

I've been asked to determine the average market value for an account
for the year to date. The average should be determined by summing the
market value on the first day of the year with the market value of the
most recent month end and then dividing by 2. I'm able to get the
ending market value using:
(ClosingPeriod([time].[Month], [time].CurrentMember ),
[Measures].[Market Value])

What I can't figure out is how to get the market value for Janauary of
the current time member.

I'm sure I'm overlooking the obvious (but I'm fairly new to Analysis
Services and MDX so nothing's obvious). I think I want something like
this:

topcount(descendants(time.currentmember,,leaves),1 )

Any help is greatly appreciated.

Phil Steffek

FYI - My time dimension is set up with the levels years, quarters,
months, days. [Market Value] is one of my measures.

How about something like:

(OpeningPeriod([Time].[Month],
Ancestor([Time].CurrentMember, [Time].[Year])),
[Measures].[Market Value])


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Outstanding! Works exactly as desired. Thanks Deepak! Progressive
must be an interesting place to work if they can keep you on staff!