Hi,
I have a series of Named Sets in a cube, but our front end application does
not support Named Sets. Each Named Set filters the Store dimension in
various ways i.e. southern stores only using the Filter() statement

I want to add them as Calculated Members attached to the Stores dimension
but get the message 'Cannot convert Set to Expression' I get the same
message if I try and make MDX Actions.

Is there a way around this?
Thanks!
Paul

Calculated Members must calculate to a single figure.

Try wrapping your Filter(..) expressions with the Aggregate() function

eg. Aggregate(Filter(...))

The Sum() function would work too, but only if all your measures are
fully additive.

--
Regards
Darren Gosbell
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <7B6AF618-D098-4E2B-81FD-7DEEA2910A14 (AT) microsoft (DOT) com>,
Paul (AT) discussions (DOT) microsoft.com says...