SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Can SAS Process a Microsoft Cube?

Reply
Contributor
Posts: 20

Can SAS Process a Microsoft Cube?

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.
Frequent Contributor
Posts: 80

Re: Can SAS Process a Microsoft Cube?

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.
Esteemed Advisor
Posts: 5,199

Re: Can SAS Process a Microsoft Cube?

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
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 559 views
  • 0 likes
  • 3 in conversation