BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
andreas_zaras
Pyrite | Level 9

Hello,

I have an OLAP cube in SSAS named "Prices Cube". The cube is stored in an SQL Server intance named "andreas-pc\datamart". SAS foundation is also installed on the same pc. I read in a paper that SAS can be connected to the SQL SSAS Olap cube throgh OLE DB. So i am trying to set up a library with OLE DB conncetion. I set the provider as "MSOLAP", the datasource as "Prices Cube" and i enter the username and password of the SQL Server instance and nothing on propeeties but i get "ERROR: trying to establish connection: Unable to initialize. Check SAS Log fpr possinble additional info". There is nothing at the Log.Is it somethign that i am missing? ANy ideas on how i could connect to the OLAP cube?

Thnaks in advance,

Andreas

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

To use OLE DB in SAS you need to have the SAS/ACCESS to OLE DB product licensed.

Run: PROC SETINIT NOALIAS; RUN; to confirm.

View solution in original post

5 REPLIES 5
SASKiwi
PROC Star

To use OLE DB in SAS you need to have the SAS/ACCESS to OLE DB product licensed.

Run: PROC SETINIT NOALIAS; RUN; to confirm.

TomKari
Onyx | Level 15

However, once you have this done, it is definitely possible to make this connection. We've done it a number of times.

Tom

DLanningham
SAS Employee

There are some topics in the SAS OLAP Server User's Guide that may also be of use. See the topics:


  • Accessing OLAP Cubes from SAS : SQL Pass-Through Facility for OLAP

  • Connecting to a SAS OLAP Server Using the OLEDB Protocol
BoelterBI
Calcite | Level 5

Hi, there

To set up an ODBC Data Source, select the Start Menu, click on Settings Æ Control Panel and choose Administrative Tools. From there, choose Data Sources (ODBC). This will open the Data Source Administrator.

See You

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 11220 views
  • 6 likes
  • 5 in conversation