Hi All,

The following query (which runs against a AS2005 server) returns 9 rows. If
I remove the calculation from the WHERE clause and re-run it, or replace the
calculation in the WHERE clause with [Container].[Container Type].[All], I
get 15 rows returned (in all cases, the rows returned have the number '1' in
them, as I would expect).

WITH MEMBER
[Container].[Container Type].[AllCalc] AS [Container].[Container Type].[All]
SELECT
([Measures].[Container Load Count]) ON COLUMNS,
NON EMPTY
[Trade].[Trade].&[EAST_AFRICA] * [Container].[Container
Number].[All].Children ON ROWS
FROM [DW_SM]
WHERE (
[Voyage Date].[Calendar Week].&[Week 40, 2006],
[Intermodal],
[Import Booking],
[Container].[Container Type].[AllCalc]
)

I'm fairly new to MDX, but felt that these two expressions _should_ return
the same results. Ignore the fact that the calculation is redundant - it's
the fact that such a calc. affects the results that concerns me.

Any and all help much appreciated!

Thanks,

Will Alber.