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 Category].[PK APPLICATION CATEGORY].CHILDREN}*

{[Dim Application Category].[APPLICATION CATEGORY DESC].CHILDREN} ON ROWS

FROM FACT_APPLICATIONS

I have verified the numbers against the TSQL script and the numbers at least check out. If someone could critique the logic that would be great!

Eventually, I would like users to be able to be able to select the dates and terms for comparison via SSRS and or Excel. Any tips moving forward would be helpful.

Thanks.