Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement