# Connecting to Microsoft SSAS OLAP cube

**URL:** <https://forum.knime.com/t/connecting-to-microsoft-ssas-olap-cube/27418>\
**Category:** KNIME Analytics Platform\
**Created:** [September 16, 2020, 10:36am UTC](https://forum.knime.com/t/connecting-to-microsoft-ssas-olap-cube/27418 "2020-09-16T10:36:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Polestar01](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/7993a0/32.png) [@Polestar01](https://forum.knime.com/u/Polestar01)\
**Post date:** [September 16, 2020, 10:36am UTC](https://forum.knime.com/t/connecting-to-microsoft-ssas-olap-cube/27418/1 "2020-09-16T10:36:16Z")

</div>

I am trying to connect to Microsoft SSAS OLAP cube at my company, however I have not found a way to do so yet. I have asked internally for help from application managers but without any success so far. I have also looked into the links below however I am unable to figure out how to connect. I would really appreciate some insights or help on this matter.

> [@Help connecting KNIME to a SQL Server Analysis Services Olap Cube](https://forum.knime.com/t/help-connecting-knime-to-a-sql-server-analysis-services-olap-cube/4569/13):
>
> Thanks for this. The only issue I am having is that I can’t find any location that resembles \<KNIME INSTALLATION\>jre/lib/ext Has this changed or are you able to clarify? I am using KNIME 3.5.2

> **[Enable the SQL Analysis Services JDBC Driver in KNIME](https://www.cdata.com/kb/tech/ssas-jdbc-knime.rst)**
>
> Use standard data access components in KNIME to create charts and reports with SQL Analysis Services data.

---

<div class="post-metadata">

**Author:** ![stratlytic](https://forum-cdn.knime.com/user_avatar/forum.knime.com/stratlytic/32/36961_2.png) [@stratlytic](https://forum.knime.com/u/stratlytic)\
**Post date:** [September 16, 2020, 10:59am UTC](https://forum.knime.com/t/connecting-to-microsoft-ssas-olap-cube/27418/2 "2020-09-16T10:59:50Z")

</div>

This continues to be a major issue for me as well Polestar01. Hopefully there’s some better answers than I am going to suggest.

The way I worked round this was to set up the SSAS server as a **Linked** Server on a on-prem SQL Server instance. Then you can connect (from KNIME) to a database on the same server as the Linked Server using a normal KNIME Microsoft SQL Connector node and use SELECT \* FROM openquery(’[LinkedServer]’, ‘MDX/DAX as appropriate’) to query your cube or tabular model.

If you need more help, let me know.

---

<div class="post-metadata">

**Author:** ![Polestar01](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/7993a0/32.png) [@Polestar01](https://forum.knime.com/u/Polestar01)\
**Post date:** [September 17, 2020, 11:30am UTC](https://forum.knime.com/t/connecting-to-microsoft-ssas-olap-cube/27418/3 "2020-09-17T11:30:40Z")

</div>

Thanks, I will try to see if this works.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [March 18, 2021, 11:31pm UTC](https://forum.knime.com/t/connecting-to-microsoft-ssas-olap-cube/27418/4 "2021-03-18T23:31:06Z")

</div>

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.