I checked out you suggestion but I don't think it will work because even though the start term itself has a start and end date, the time period that applicants...

Brilliant! Thanks.

The hard-coded dates are there just for testing. I am hoping to use the dates and start terms as parameters in SSRS reports.

However, I am...

I think I solved it!

WITH

MEMBER[Measures].[APPLICATIONS2013AY] AS SUM({NULL:[Dim Date 1].[CALENDAR].[full date].[2013-06-21 00:00:00.000]},[Measures].[EVENT])

MEMBER [Measures].[APPLICATIONS2012AY] AS SUM({NULL:[Dim Date 1].[CALENDAR].[full date].[2012-06-21 00:00:00.000]},[Measures].[EVENT])

SELECT

{([Dim Start Term].[APPL START TERM].[2013AY],[Measures].[APPLICATIONS2013AY]),

([Dim Start Term].[APPL START TERM].[2012AY],[Measures].[APPLICATIONS2012AY])}ON COLUMNS,

{[Dim Application...

Great help. I have played around with the code somewhat and came up with this...

WITH MEMBER [MEASURES].[COUNTAPPS] AS

(SUM(

PARALLELPERIOD([Dim Date 1].[CALENDAR].[Calendar Year Number],1 , [Dim...