Pentaho

 View Only

 Who connect XMLA in Pentaho 5.4?

  • Pentaho
  • Pentaho
  • Pentaho Server
elsa santos's profile image
elsa santos posted 05-22-2018 15:51

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,


#PentahoServer
#Pentaho