topic Re: Can SAS Process a Microsoft Cube? in Microsoft Integration with SAS

Can SAS Process a Microsoft Cube?

mikersas — Thu, 07 Apr 2011 21:10:14 GMT

We have microsoft cubes which are impractical to replicate in SAS.
Yet we would like to be able to use SAS BI tools (ie WRS) to slice and dice them.

Re: Can SAS Process a Microsoft Cube?

ShaneGibson_OptimalBI — Sat, 09 Apr 2011 03:38:38 GMT

Ive used SAS Enterprise Guide to access SQL Server Analysis Services, but never tried WRS etc.

Im thinking that EG is using OLEDB for OLAP as a local client side connection and this connection isn't available server side, so WRS, IMS etc won't be able to access the cubes.

Re: Can SAS Process a Microsoft Cube?

LinusH — Fri, 06 May 2011 10:10:33 GMT

On the server side you could use SAS/ACCESS to OLEDB.
It lets you access OLEDB for OLAP cubes using SQL/MDX-queries.
Which in turn can be defined as SAS SQL views.
So theoretically, you should be able to access these trough an information map.
Never tried it myself though.

/Linus