   Select \[1997\]. Children on Columns, Filter(\[Store
Name\].Members,  Store.CurrentMember >       
LookupCube("Warehouse", "Avg(\[Warehouse Name\].Members,
(Warehouse.CurrentMember, \[Warehouse Sales\]))" )) on Rows from
Sales where (\[Unit Sales\])  The answer to this puzzle uses the
new, useful LookupCube function, which is similar to the nested
query capability of SQL Server 7.0. This MDX query uses the
LookupCube function to retrieve the average Warehouse Sales of
all warehouses in the Warehouse cube. The value then filters all
the stores in the Sales cube. The results are displayed on rows,
with the quarters of 1997 displayed on columns.