Has any one tried this plug-in with a pivot table powered by Simba MDX?
We are trialing the Simba MDX provider with Oracle 11.2 OLAP database and found that Excel is lacking quite a few features, mainly in search and filtering. Fortunately Excel 2010 includes search on the filter but it is not flexible enough.
I installed the plug in and created my query, but when using the Search or Filter List tab I get the following message:
A connection cannot be made. Ensure that the server is running.
at Microsoft.Analysisservices.AdomdClient.XmlaClient.GetTcpClient(Connectionlnfo connectionlnfo)
at Microsoft.Analysisservices . AdomdClient . xmlaClient OpenTcpConnection(ConnectionlnIo connectionlnfo)
at MicrosoltAnalysis5ervices.AdomdClient.xmlaClientConmnect(Connectionlnfo connectionlnlo, Boolean beginsession)
at Microsoft.Analysisservices.AdomdClient.AdomdConnection.xmlaCientProvider .Connect(Boolean toIxMLA)
at MicrosoFt.AnalysisServices.AdomdClient.AdomdConnection.ConnectToxMLA(Boolean create5ession, Boolean isHTTP)
at Microsoft.Analysisservices. AdomdClient . AdomdConnection.Open()
at OlapPivotTableExtensions.MainForm.worIerFiIterList DoWork(Object sender, DoWorkEventArgs e)
We would love to get this plug in working with our Simba MDX pivot tables, any idea how we can achieve this?