Hi,
Can I exclude a single member in a calculation subcube. I have a
structure like this

Countries
USA
UK
Germany
Turkey

I have to exclude one of this countries from the calculation sub cube.
But when I write a mdx with except function I got an error.

Any comments. ??

What does the MDX look like, and what does the eroor say?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

this works : {[Limit Or Risk].[Limit Or Risk].&[L]},
{[Companies_Not_Shared].[Group Name].&[GRUBU MEVCUT DEGIL]}

but when I write with except function
{[Limit Or Risk].[Limit Or Risk].&[L]},
except({[Companies_Not_Shared].[Group Name].AllMembers
},{[Companies_Not_Shared].[Group Name].&[GRUBU MEVCUT DEGIL]})

I got this error.

Unable to create calculated cell.

Formula Error - The subcube expression must be one of the following:
descendants(...) function,<level>.members, <dimension>.mmebers or a
single mmeber. in the calculated cell condition.

What can I do. To except the Group Name "GRUBU MEVCUT DEGIL"

Instead of excluding in the subcube, how about adding this to the
condition clause of the calculated cell:

'Not([Companies_Not_Shared].CurrentMember is
[Companies_Not_Shared].[Group Name].&[GRUBU MEVCUT DEGIL])'


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

It is working. Thanks.