Error when using calculated members in filters area

[Shab]

In AdventureWorks database, I cretaed a calculated member as following:

CREATE MEMBER CURRENTCUBE.[Product].[Product Categories].[Subcategory].&[26].Product1
AS [Product].[Product Categories].[Product].&[483],
VISIBLE = 1 ;

Product1 is equal to Accessories-->Bike Racks-->Hitch Rack - 4-Bike. When use the cube browser tab to look at data, I use the top most filter section to filter on product categories hierarchy. If I choose [Hitch Rack - 4-Bike], I see the numbers for this product. But if I choose Product1 from the list, I get the following message:

"Unable to apply filter. A set has been encounterd that cannot contain
calculated members."

This happens for all calulated members regardless of hierarchy and dimension used. However, if you use the filter in the lower part of the screen, it works fine.

If I write a query using SQL Server Management Studio, the numbers come back alright.

select [Measures].[Reseller Extended Amount] on columns
from [Adventure Works]
where ([Product].[Product Categories].[Subcategory].&[26].[Product1])

This query works fine.

It is just the BIDS cube browser and Excel that throw the error. Unfortunately my front end tool is Excel and I have to get this to work with Excel.

Any ideas?

Thanks,

SHW