Date:         Mon, 8 May 2006 07:41:18 -0700
Reply-To:     minion <andrew.farrer@CIBC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         minion <andrew.farrer@CIBC.COM>
Organization: http://groups.google.com
Subject:      Re: SAS OLAP Cubes creation on SQL Server Database
Comments: To: sas-l@uga.edu
In-Reply-To:  <1147084924.354528.144020@u72g2000cwu.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Ankit wrote:
> Hi All,
>
> Does anyone have any idea on whether SAS OLAP Cube studio can create
> OLAP cubes on SQL server database. While creating the repositories via
> SAS Management Console, the database for the repositories can be
> specified as Base, Oracle, DB2. The tables in this repository may then
> be used as input for the OLAP Cube Studio.
>
> However, is it possible to create OLAP Cube using SAS OLAP Cube Studio
> on SQL server databases?
>
> Thanks!
> Ankit

I would think not.
OLAP Cube Studio primarily generates proc olap statements which are SAS
specific. Metadata Repositories have a tightly defined structure and
are unrelated to cubes.