I am trying to filter along a dimension and it comes up with Open
Cellset error for the following MDX query against the FoodMart Cube.

Select {[Customers]} on Columns,
Filter ([Store].[Store Name].Members,[Store].Currentmember) ="Store 2"
) on Rows
from SALES


Can somebody please clarify how I can resolve this.

Thanks
Simon

Select {[Customers]} on Columns,
{Filter ([Store].[Store Name].members,[Store].currentmember.name = "Store
2")} on rows

from sales


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Simon Lenn" <simonlenn (AT) yahoo (DOT) com> wrote