Listing 1

<cfquery datasource="QBIC1SQL" name="MSOLAP_Query">
	SELECT = FROM OPENQUERY( FOODMART_2000, '
		SELECT
		NON EMPTY ( [Store].[Store State].Members ) ON COLUMNS
		FROM Sales
		WHERE [Measures].[Store Sales]
	')
</cfquery>
<cfdump var="#MSOLAP_QUERY#">