AnsweredAssumed Answered

Who connect XMLA in Pentaho 5.4?

Question asked by elsa santos on May 22, 2018

Hi,

I'm trying to connect XMLA provider working with the Pentaho 5.4 version and mondrian-3.10.0.1.

 

In the Manage Data Source my schema have the property

EnableXmla = true.

 

In the web.xml I have the configuration:

  <servlet>

    <servlet-name>Xmla</servlet-name>

    <servlet-class>org.pentaho.platform.web.servlet.PentahoXmlaServlet</servlet-class>

    <init-param>

      <param-name>DataSourcesConfig</param-name>

      <param-value>${pentaho.solutionpath}${pentaho.olap.xmladatasources}</param-value>

    </init-param>

    <init-param>

      <param-name>CharacterEncoding</param-name>

      <param-value>UTF-8</param-value>

    </init-param>

  </servlet>

 

The datasource.xml:

<?xml version="1.0" encoding="UTF-8"?>

<DataSources>

  <DataSource>

<DataSourceName>Provider=Mondrian;DataSource=Pentaho</DataSourceName> 

<DataSourceDescription>Pentaho BI Platform Datasources</DataSourceDescription> 

<URL>http://localhost:8081/pentaho/Xmla?userid=joe&password=password</URL> 

<DataSourceInfo>Provider=mondrian</DataSourceInfo> 

<ProviderName>PentahoXMLA</ProviderName> 

<ProviderType>MDP</ProviderType> 

<AuthenticationMode>Unauthenticated</AuthenticationMode> 

<Catalogs>

  <Catalog name="SCHEMA TEST">

<DataSourceInfo>Provider=mondrian;DataSource=DW;Locale=pt_PT;DynamicSchemaProcessor=mondrian.i18n.LocalizingDynamicSchemaProcessor;EnableXmla=true</DataSourceInfo>

<Definition>solution:/system/schemaSynchronizer/resources/logical-model/BI_TEST.xml</Definition>

  </Catalog>

</Catalogs>

  </DataSource>

</DataSources>

 

For test the client I use REX and when try to connect with http://server/pentaho/Xmla?userid=joe&password=password but return

 

[Fatal Error]:XML document structures must start and end within the same entity.

ERROR [AWT-EventQueue-0] <s.java:66> - XML document structures must start and end within the same entity.

DEBUG [AWT-EventQueue-0] <s.java:47> - ERROR<discoverDataSources>:java.lang.NullPointerException

 

Anyone?

 

Tanks,

Outcomes