Hi,

Are there any synergies between SAS ETL environment & Microsft Analysis
Services?

I am looking at a way to build Cubes using Microsft Analysis Services from
the data sets produced through the SAS ETL environment.

One way, i am thinking is to build *.CSV from SAS and use the Microsft Text
File Driver" to build cubes.

Any Comments are welcome. Any references to such implementations would be
helpful.

Thanks,

Prasad.

Hi Prasad,

On a few occasions, I've worked with business analysts who had developed
SAS progams to implement their business logic. The results were
typically stored as SAS data sets, then downloaded to Excel pivot tables
for further analysis and reporting.

Of course, they turned to the option of an AS OLAP cube when they either
ran out of rows (65K) or columns (255). We would typically start by
converting the SAS Data Sets to (huge) .CSV files, as you mentioned. I
was able to load these into SQL Server 2000, using DTS and Text Driver
without problems (haven't tested with SSIS yet). Once the cube was
stabilized, we would eventually try to convert the SAS ETL logic
completely into DTS packages (if cube loading needed to be automated for
the long term).


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***