Does anyone know how to get the value of a measure from the first day
of every year.
I tried the mdx query below, however I get the opening balance for 2006
for every year. What I would like is the opening balance for every year
I have in my time dimension.

(openingperiod([Day],[2006]), [Measures].[Net Front End Cash Fee Amt])

Thanks,
John C

Hi John,

You didn't describe the time hierarchy, but maybe:

Ancestor([Time].CurrentMember, [Time].[Year])),
[Measures].[Net Front End Cash Fee Amt])

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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