When I run the following query against the Foodmart database, the
result rowset contains #Err values. But if I change EXCLUDEEMPTY to
INCLUDEEMPTY, the correct value os returned.

Does anyone have any ideas?

Leroy.

WITH MEMBER [Measures].[No Locations]
As
'
COUNT ( [Warehouse].[City].members , EXCLUDEEMPTY )
'

SELECT

{ [Measures].[No Locations] } ON COLUMNS,
{ [Product].[Product Family].members } ON ROWS
FROM [Warehouse]

If you double-click the #ERR cells in MDX Sample App, the error message
identifies infinte recursion. This is because,
with EXCLUDEEMPTY, a measure is tested to see if it is empty. But
because Count() is used in a calculated measure, that measure becomes
the default measure, unless another measure is explicitly specified.

So try this version of EXCLUDEEMPTY instead:

'COUNT ( [Warehouse].[City].members
* { [Measures].[Units Ordered]}, EXCLUDEEMPTY )'

SELECT
{ [Measures].[No Locations] } ON COLUMNS,
{ [Product].[Product Family].members } ON ROWS
FROM [Warehouse]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***