topic Re: Accessing Microsoft OLAP cubes (server side) without SAS/ACCESS interface to OLEDB in SAS Enterprise Guide

Accessing Microsoft OLAP cubes (server side) without SAS/ACCESS interface to OLEDB

CPAZ — Wed, 07 Nov 2012 17:12:17 GMT

Hello All,

Currently in Enterprise Guide (4.3), I can use the OLAP viewer to connect to and view Microsoft OLAP cubes. No issue there. However I want to be able to submit the MDX code on the server side to return the sliced data. In the documentation I have seen this can be achieved through SAS/ACCESS interface to OLEDB. Can this be done without SAS/ACCESS, The cost for this license is just a little too much. Here is what I have available on the server:

---Base Product

---SAS/STAT

---SAS/GRAPH

---SAS/CONNECT

---SAS Enterprise Miner

---SAS Integration Technologies

---Enterprise Miner Server

---Enterprise Miner Thin Client

---SAS/ACCESS Interface to PC Files

---SAS/ACCESS Interface to ODBC

---SAS Workspace Server for Local Access

Thanks for any input.

Chris

Re: Accessing Microsoft OLAP cubes (server side) without SAS/ACCESS interface to OLEDB

SASKiwi — Thu, 08 Nov 2012 22:50:08 GMT

I see you are licensed for SAS/ACCESS Interface to ODBC. Have you tried that? You can pretty much submit any valid SQL Server code if you use SQL pass-thru.

Re: Accessing Microsoft OLAP cubes (server side) without SAS/ACCESS interface to OLEDB

CPAZ — Sat, 17 Nov 2012 05:44:16 GMT

I have tried ODBC but with no luck. SAS technical help states the only way to connect is with SAS/ACCESS to OLEDB. It has built in functionality for MSOLAP. Thanks.