Hello everybody.
I have a problem since two days.
I have to create locals cubes from existing cubes and I want to exclude
some data (a member of a dimension for example).

I try this syntax :
CREATE CUBE xxxx
Dimensio xxx
Insert Into xxx
xxx
Select [MyCube].[myDimension] from MyOnlineCube where [MyOnlineCube].
[myDimension] <> 'A value'

But its fails. The symbol '<>' is not allowed. Does anybody know which
syntax I have to use to exclude a member ?
Thanks!

--
Message posted via http://www.sqlmonster.com

And I try the symbol '!=', the except function etc... but it doesn't work
too.

--
Message posted via http://www.sqlmonster.com