Implementing Authentication for OLAP Cubes in Flexmonster Pivot

Volodymyr Yatsevsky posted on March 19th, 2012
PLEASE NOTE: As soon as we update the Component with new features every new week the information might be outdated, please check our latest news.

In one of our previous blog posts we have mentioned that Flexmonster Pivot can connect not only raw OLAP data such as CSV, but also OLAP cubes such as Microsoft Analysis Services, Pentaho Mondrian, JasperReports Server and icCube.

Flexmonster Pivot connects to these servers using XMLA protocol, which is usually enabled for all of the mentioned BI solutions.

A common task for BI implementation analytics is to secure the XMLA endpoint, as it is open on the network by default. While Flexmonster Pivot can connect to OLAP cube by just having the necessary credentials specified, the integrators can also include authentication for security reasons. Feel free to copy the Configuration XML snippets below for your specific OLAP provider.

		Provider=MSOLAP; Data Source=extranet;
		Adventure Works DW Standard Edition
		Adventure Works 

However, since passing username and password in an open text is not a best practice, you can also pass credentials as hash, encoded with BASE64 in the form of “username:password”. See another snippet below for Mondrian:


Have also a moment to look at complete reference for specifying your
data source in Flexmonster Pivot

Recent Posts