BookmarkSubscribeRSS Feed
mikersas
Obsidian | Level 7
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.
2 REPLIES 2
ShaneGibson_OptimalBI
Fluorite | Level 6
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
Tourmaline | Level 20
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 2 replies
  • 1414 views
  • 0 likes
  • 3 in conversation