Connect to Penatho BI Suite

[Roberto]

Dear All

first of all thanks for your work, I really appreciate it.
I am connecting with Excel 2013 (32 bit) on a Pentaho Bi suite (default configuration) following your tutorial (https://sourceforge.net/p/xmlaconnect/wiki/Mondrian:%20Create%20Connection/) but when clicking for cuve retrieve i receive a Msgox with this error
"XMLA Discover unparse result error".

How can I connetc?
Thanks

Roberto

[Alexandra Davidoiu (Iancu)]

We need to know the exact version of the BI suite you use. So far we have tested with 4.5 and 5.0. Looks like something we don't expect in the response from the BI suite.

[Roberto]

Hi,
thanks for the response first of all. I am working with 5.0.7.1 releases.

Roberto

[Sándor Polyák]

Same is happening for me, Pentaho 5.0.1 CE, but Excel 2010 64 bit

[Sándor Polyák]

This is the answer I got, captured by Wireshark:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> <SOAP-ENV:Header> </SOAP-ENV:Header> <SOAP-ENV:Body> <SOAP-ENV:Fault> <faultcode>SOAP-ENV:Server.00HSBE02</faultcode> <faultstring>XMLA Discover unparse results error</faultstring> <faultactor>Mondrian</faultactor> <detail> <XA:error xmlns:XA="http://mondrian.sourceforge.net"> 00HSBE02 The Mondrian XML: Broken pipe </XA:error> </detail> </SOAP-ENV:Fault> </SOAP-ENV:Body> </SOAP-ENV:Envelope>

[Alexandra Davidoiu (Iancu)]

There is something wrong with your general systems and (most probably ) Mondrian cannot access the DB server.

On our systems we use MySQL as DB and are able to reproduce it by shutting down MySQL and then starting Pentaho.

By default, Pentaho comes with SteelWheels as a demonstration catalog. The pictures attached here show how this works in our case:

1. There is a schema called SteelWheels (type=Analysis). This one links to SampleData.
2. SampleData (type=JDBC) is configured for MySQL. In this case there should be a database called sampledata in your (local) MySQL.

In the case you still heed help post here and we-ll try to find some good documentation for setting up Pentaho BI.

[Sándor Polyák]

Thanks, but Pentaho and MySQL are up and running.
I found a Pentaho error ticket saying that there is Mondrian bug about the discovery command, but it is fixed in 5.1. I will give it a try.

[Sándor Polyák]

I confirm that this is a Mondrian bug, but it is corrected in the version 3.7, used in Pentaho 5.1. So, just upgrade 5.0.x to 5.1 and it will be fine.

The XMLA Connect works smoothly, nice job Arquery, thank you very much :-)

[Roberto]

Thanks to all for the help.

Roberto

[christopher68]

Penatho BI Suite is a comprehensive business intelligence platform designed to empower organizations with data integration, analysis, and visualization capabilities. To connect to Pentaho BI Suite, you typically need to integrate it with your data sources, such as databases, data warehouses, or cloud services, using Pentaho's Data Integration (PDI) tool. Once connected, users can transform and prepare data for reporting and dashboards within the Pentaho Business Analytics interface. The suite supports various data formats and sources, ensuring seamless data flow and enabling real-time insights. Proper configuration, including setting up JDBC connections or utilizing APIs, ensures a reliable connection green card medical exam Los Angeles, providing businesses with the tools to make data-driven decisions efficiently.

[jhone smith]

Connecting to Pentaho BI Suite enables organizations to harness powerful business intelligence capabilities, including data integration, reporting, dashboards, and analytics of calculador de amor. By establishing a connection to Pentaho, users can integrate data from multiple sources—such as databases, spreadsheets, and cloud services—into a centralized environment. This empowers decision-makers with real-time insights through interactive visualizations and customizable reports.