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