Can SAS Process a Microsoft Cube?

[mikersas]

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.

[ShaneGibson_OptimalBI]

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.

[LinusH]

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