MDX Filter or Except

[petersJazz]

hi,

In a report (SSRS) users choose Country (a dimension) to get out some measures. Now I need to take away some Companies (another dimension) from the list. There is no relation between the dimension.

I have done some simple tests for doing this but I dont understand how to do it.

with member [company].ExcludeSolvency as 
'except([company].[All],
        {[Company].[00130],[Company].[00131]})'
select {[measures].[Actual local month]} on columns,
        [country].members on rows
from [QBDWDB2]
where ([company].ExcludeSolvency)

First, without the where clause, every company was included. With the where clause nothing is included.