WITH
MEMBER [AgencyName].[fap] AS
'[AgencyName].CurrentMember.Properties("Agency Code")'
select NON EMPTY Crossjoin({[DepartureSeason].[All DepartureSeason], [DepartureSeason].[All DepartureSeason].[Winter], [DepartureSeason].[All DepartureSeason].[Summer]}, Crossjoin({[DepartureFiscalYear].[All DepartureFiscalYear].[2009], [DepartureFiscalYear].[All DepartureFiscalYear].[2010]}, {[Measures].[Nbr Passengers], [Measures].[Invoice YE], [Measures].[Invoice YTD], [Measures].[% su YTD], [Measures].[% su YE], [Measures].[Margin]})) ON COLUMNS,
  NON EMPTY Crossjoin({[AgencyRegion].[All AgencyRegion].[2-CentroSud].Children}, Crossjoin({[AgencyDistrict].[All AgencyDistrict].Children}, {[AgencyName].[All AgencyName].Children})) ON ROWS
from [Bookings]
where ([AgencyCategoryEnabled].[All AgencyCategoryEnabled].[Y], [AgencyExcluded].[All AgencyExcluded].[N], [AgencyPromoter].[All AgencyPromoter].[Jimmy])