Get Free Trial

Implementing Authentication for OLAP Cubes in Flexmonster Pivot

PLEASE NOTE: Since we update Flexmonster Pivot with new features biweekly, the information might become 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.

    <dataSource type="MSOLAP">
		<dataSourceInfo>Provider=MSOLAP; Data Source=extranet;</dataSourceInfo>
		<catalog>Adventure Works DW Standard Edition</catalog>
		<cube>Adventure Works</cube>
		<proxyUrl>http://olap.flexmonster.com/olap/msmdpump.dll</proxyUrl> 
		<credentials>
			<username>username</username>
			<password>password</password>
		</credentials>
	</dataSource> 

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:

   <dataSource type="Mondrian">
        <dataSourceInfo>Provider=Mondrian;DataSource=Foodmart;</dataSourceInfo>
        <catalog>Foodmart</catalog>
        <cube>Sales</cube>
        <proxyUrl>http://127.0.0.1:8088/yourserver/xmla</proxyUrl>
        <credentials>
            <hash>amFzcGVyYWRtaW46amFzcGVyYWRtaW4=</hash>
        </credentials>
    </dataSource>