Use the Anaplan XL Reporting add-in for Excel to connect to Mondrian and run queries with Mulitideminsional Expressions (MDX). You can use Mondrian to create grids, small multiple charts, and slicers similar to Analysis Services connections.
Server Configuration
The Mondrian server must have the XMLA servlet enabled and configured.
Client Configuration
In the connections screen, choose the Mondrian connection type. Enter the XMLA address as the server name, usually in the form: http://server_name:8080/mondrian/xmla.
If you need to enter credentials, or get an Unauthorized message, select the Requires Logon checkbox, and enter your username/password.
Mondrian requires an older version of the ADOMD.Net database drivers that aren't provided with Anaplan XL. These can be downloaded and installed from https://www.microsoft.com/en-gb/download/details.aspx?id=44272
You must install the ASADOMD10 drivers. There are 32 and 64-bit versions. It's easiest to install both.
