Hi

I am trying to filter a set of measures based on those measure being
assigned to a dimension.


I am trying to filter this
{[Measures].[Cost],[Measures].[Actual Cost]}

when this
{[Resource].[All Resource].[Capital Risk Cost]}, {[Resource].[All
Resource].[Capital Standard Cost],[Resource].[All Resource].[Capital
Standard Cost],
[Resource].[All Resource].[Revenue Risk
Cost],[Resource].[All Resource].[Revenue Standard Cost]}


I have played about will lots of syntax and cannot get anything to
work.

The only thing i can do is a NONEMPTYCROSSJOIN and then setup loads of
extra field in sql reporting to be the totals.


I am asking too much of MDX or am i just doing it wrong?????

If you are using AS 2005 you can do this:

{[Measures].[Cost],[Measures].[Actual Cost]}
FROM <Cube>
WHERE {[Resource].[All Resource].[Capital Risk Cost], [Resource].[All
Resource].[Capital Standard Cost],[Resource].[All Resource].[Capital
Standard Cost], [Resource].[All Resource].[Revenue Risk Cost],
[Resource].[All Resource].[Revenue Standard Cost]}
If you are using AS 2000 you cannot put a set in the where clause and
you would need to create an aggregated member to slice on.

MEMBER [Resource].Slicer as 'AGGREGATE({[Resource].[All Resource].
[Capital Risk Cost], [Resource].[All
Resource].[Capital Standard Cost],[Resource].[All Resource].[Capital
Standard Cost], [Resource].[All Resource].[Revenue Risk Cost],
[Resource].[All Resource].[Revenue Standard Cost]}
)'
SELECT
{[Measures].[Cost],[Measures].[Actual Cost]}
FROM <Cube>
WHERE ([Resource].[Slicer])

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1146583037.752950.83930 (AT) v46g2000cwv (DOT) googlegroups.com>,
pbuzzby (AT) gmail (DOT) com says...

Thanks a lot i will give that a try.

I found a bodge way of doing it but your way makes sence now.

The more i read the more i wish i was using AS2005