CREATE SUBCUBE syntax in 2K5B2

#1

In SQL Server Books Online I find this definition for SUBCUBE:

CREATE SUBCUBE
Subcube_identifier
AS
Subcube_expression

Which is the syntax for 'Subcube_expression'?

Thanks,
Valter

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

#2

Sucube_expression means <select statement>. For example,

CREATE SUBCUBE UsaSales
AS
SELECT (Customer.Country.Country.Usa, *) FROM Sales

Ohjoo Kwon

"Valter Paiotti via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Quote:

In SQL Server Books Online I find this definition for SUBCUBE:

CREATE SUBCUBE
Subcube_identifier
AS
Subcube_expression

Which is the syntax for 'Subcube_expression'?

Thanks,
Valter

--
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 SUBCUBE syntax in 2K5B2

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

CREATE SUBCUBE syntax in 2K5B2 - 03-18-2005 , 03:20 AM

Re: CREATE SUBCUBE syntax in 2K5B2 - 03-18-2005 , 10:15 AM