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>
Subject: Re: SAS OLAP Cubes creation on SQL Server Database
Content-Type: text/plain; charset="iso-8859-1"
> 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?
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.