BookmarkSubscribeRSS Feed
Ant
Calcite | Level 5 Ant
Calcite | Level 5
I have found a way to connect to sas olap service, but I am using ms olap service 2005, how to connect to it and run mdx query ? thx.
3 REPLIES 3
Cynthia_sas
SAS Super FREQ
This is a question that is best answered by Tech Support. Generally speaking, as described in this Tech Support sample, queries against an OLAP cube need to be made within a SAS 9 session that has access to a SAS OLAP Server and that contains OLAP cubes already defined:
http://support.sas.com/ctx/samples/index.jsp?sid=1615&tab=code

To contact Tech Support for more detailed help on OLAP cubes and connecting to OLAP servers in general and for what you're trying to do specifically, refer to this site:
http://support.sas.com/techsup/contact/index.html
Good luck!
cynthia
Ant
Calcite | Level 5 Ant
Calcite | Level 5
This sample just shows me to connect to sas olap server, but I want to know whether I can connect to ms analysis service and run some mdx query in sas stored process.
Cynthia_sas
SAS Super FREQ
You're trying to do something beyond what is normally done with a stored process on the BI platform. In these instances, Tech Support is your best bet for a definitive answer. Anything else from me, at least, would be a guess. And I don't like to guess.

This SUGI paper was the only other thing I found, but again, it talks about connecting to a SAS OLAP server: http://www2.sas.com/proceedings/sugi31/219-31.pdf

Tech Support is really your best bet for an answer to this question.

cynthia

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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