QlikView – Access Data from SSRS

March 3, 2015

Since QlikView can’t access certain data sources like MS Analysis Services (SSAS) or other exotic data sources (SAP NetWeaver BI, Hyperion, TERADATA) natively.

We can fall back on the perfect middleware for this being MS SQL Reporting services


The approach is a simple as can be. Setup an SSRS server (can even be the MS SQL Express (Free) Edition & SSRS add-on)

The SSRS report server has natively a web service interface, exposing a SOAP and URL Interface.

Next develop your SSRS reports (which can handle multi data sources in 1 report Smile)


Like for example a SharePoint List combined with an Oracle database, or anything else.

Simular to PowerPivot that can access an SSRS Data Source. We can do the same with QlikView.

Use a Web File connection as Data Source


Fill in your report URL link and add the rs:Format=XML parameter to get an XML output from you report


If all goes well you will get the Report XML output and see the SSRS TABLIX and FIELDS Smile


That’s it, now you are ready to build your QlikView GUI

Once you know this technique you can as well use this to access an SSRS in the MS Azure cloud.Winking smile



MS SQL – SSAS Connecting to Analysis Services in Another Domain

October 6, 2014

There are several tools available on the next to query an SSAS OLAP instance using MDX queries.

But most of the time you have the OLEDB drivers on your machine.


But some tools lack the authentication mechanism to poke into an OLAP cube that is not in your domain.

Like this MDX Query generation for QlikView


It allows you to connect but you can’t send across any authentication to connect remotely.



runas.exe /user:YourDomain\User /netonly “C:\Program Files (x86)\MDX Query Generator for Qlikview\QlikviewMDX.exe”

And it will just do fine ! Smile