Hi
I am trying to connect to Mondrian through XMLA from MS excel using SimbaO2X drivers, I succeeded with initial connection and I could see Cubes as well but when I select a cube to form Pivot table it gives me a eroror:
SOAP-ENV:Server.00HSBE02
Fault String: XMLA Discoverer unparse results error

When I checked Pentaho log i could see error: mondrian.olap.MondrianException: Mondrian Error:Internal error: Unknown database 'SteelWheels' but I can use the same cube in Pentaho user console using Analyzer

I searched all over but could not find a solution, I feel we need to define something very specific to XMLA in datasource.xml of Pentaho, for reference here my datasource.xml entry for SteelWheels catalog:
<DataSources>
<DataSource>
<DataSourceName>Provider=Mondrian;DataSource=Pentaho</DataSourceName>
<DataSourceDescription>Pentaho BI Platform Datasources</DataSourceDescription>
<URL>http://localhost:8080/pentaho/Xmla?userid=joe&amp;password=password</URL>
<DataSourceInfo>Provider=Mondrian;DataSource=Pentaho</DataSourceInfo>
<ProviderName>PentahoXMLA</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
<Catalogs>
<Catalog name="SteelWheels">
<DataSourceInfo>Provider=Mondrian;DataSource=SampleData</DataSourceInfo>
<Definition>solution:steel-wheels/analysis/steelwheels.mondrian.xml</Definition>
</Catalog>