Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Microsoft SSAS Cube access

Reply
Regular Learner
Posts: 1

Microsoft SSAS Cube access

Hi,

 

We have Microsoft SSAS cubes deployed on our SQL Server. I read that SAS Visual Analytics using SAS/Access can access the OLAP cube. My question is that: Does it need a MDX expression to query the cube.

 

In other data visualization vendor products, the access to the SSAS cube is seamless i.e. i don't have to write a MDX query and access to dimension or fact is seamless.

 

Any feedback on the above is really appreciated. 

 

Thanks,

Sunil

Esteemed Advisor
Posts: 5,063

Re: Microsoft SSAS Cube access

Access to OLAP data uses the SAS/ACCESS to OLEDB licence.

As I understand it, you could either use MDX in SQL pass through (like any other ACCESS engine).

You could also use views, but they need to be created on the SQL Server side by using MDX. If you already have those, then it's seamless...Smiley Wink

 

http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#p0yn2t1wybwsshn1a4...

Data never sleeps
Post a Question
Discussion Stats
  • 1 reply
  • 88 views
  • 0 likes
  • 2 in conversation