Create Cube Where Clause

#1

Hello.
I'm trying to create a local cube from Analysis Service using Create Cube
Syntax.
Everithing works perfectly except one thing. I can't put in the select
WHERE clause the '<>' symbol. But the '=' symbols works fine.

Example :
'CREATE CUBE xxx'
'INSERT INto xxx'
'Select xxx FROM MYCUBE WHERE {[MYCUBE].[myDIMENSION] <> 'USA')

Could anyone tell me which symbol I have to use to exclude 'USA' dimension
from my Local Cube.

Thanks!

#2

the symbol correct is ' != ' ( sqlserver 7.0)
god luck

"Ernesto LEITE via SQLMonster.com" <forum (AT) nospam (DOT) SQLMonster.com> escribió en
el mensaje news:9e870b3208f44d33a599497a534a2169 (AT) SQLMonster (DOT) com...

Quote:

Hello.
I'm trying to create a local cube from Analysis Service using Create Cube
Syntax.
Everithing works perfectly except one thing. I can't put in the select
WHERE clause the '<>' symbol. But the '=' symbols works fine.

Example :
'CREATE CUBE xxx'
'INSERT INto xxx'
'Select xxx FROM MYCUBE WHERE {[MYCUBE].[myDIMENSION] <> 'USA')

Could anyone tell me which symbol I have to use to exclude 'USA' dimension
from my Local Cube.

Thanks!

#3

Thank you for your answer.
I have tried this symbol too but its fails.

Do you have another idea?
Thanks

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

#4

Thank you for your answer.
I have tried this symbol too but its fails.

Do you have another idea?
Thanks

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Create Cube Where Clause

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Create Cube Where Clause - 05-02-2005 , 11:00 AM

Re: Create Cube Where Clause - 05-02-2005 , 11:51 AM

Re: Create Cube Where Clause - 05-03-2005 , 03:06 AM

Re: Create Cube Where Clause - 05-03-2005 , 03:07 AM