Select NON EMPTY {[Measures].[Gross Sightseeing Revenue], [Measures].[Commission], [Measures].[Net Sightseeing Revenue], [Measures].[PAX]} DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON COLUMNS , NON EMPTY Subset(NonEmpty(Crossjoin(NonEmpty(Crossjoin(NonEmpty(Crossjoin(NonEmpty(Crossjoin(Hierarchize({DrilldownLevel({[Dim Agents].[Agent Name].[All]})}), Hierarchize({DrilldownLevel({[Dim Agents].[SAP Code].[All]})})), {[Measures].[Gross Sightseeing Revenue], [Measures].[Commission], [Measures].[Net Sightseeing Revenue], [Measures].[PAX]}), Hierarchize({DrilldownLevel({[Dim Sales].[Sale No].[All]})})), {[Measures].[Gross Sightseeing Revenue], [Measures].[Commission], [Measures].[Net Sightseeing Revenue], [Measures].[PAX]}), Hierarchize({DrilldownLevel({[Dim Products].[Product Name].[All]})})), {[Measures].[Gross Sightseeing Revenue], [Measures].[Commission], [Measures].[Net Sightseeing Revenue], [Measures].[PAX]}), Hierarchize({DrilldownLevel({[Dim Ticket Types].[Ticket Type].[All]})})), {[Measures].[Gross Sightseeing Revenue], [Measures].[Commission], [Measures].[Net Sightseeing Revenue], [Measures].[PAX]}), 1, 100000) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON ROWS FROM (SELECT
{	
	[Measures].[Gross Sightseeing Revenue]
	, [Measures].[Commission]
	, [Measures].[Net Sightseeing Revenue]
	, [Measures].[PAX]
} ON COLUMNS,
(
	[Dim Agents].[Agent Name].[Agent Name] *
	[Dim Agents].[SAP Code].[SAP Code] *
	[Dim Sales].[Sale No].[Sale No] *
	[Dim Products].[Product Name].[Product Name] *
	[Dim Ticket Types].[Ticket Type].[Ticket Type]
) ON ROWS
FROM
(
	SELECT
	(
		{[Dim Products].[Branch ID].[11]}
	) ON COLUMNS
	FROM
	(
		SELECT 
		(
			{[Dim Agents].[Branch ID].[11]}
		) ON COLUMNS
		FROM
		(
			SELECT 
			(
				{[Dim Sales].[Branch ID].&[11]}
				, {[Dim Sales].[Sale Date].&[2017-01-03T00:00:00]}
				, {[Dim Sales].[Sale Type UID].[{9B3A82AF-98F8-4A12-8B91-9906CBC4D5D9}]}
				, {[Dim Sales].[Financial Type UID].[All]}
				, {[Dim Sales].[Agent Type UID].[All]}
				, {[Dim Sales].[Voided].&[0]}
			) ON COLUMNS
			FROM [GeneralReportingCube]
		)
	)
)) CELL PROPERTIES VALUE