Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: mondrian olap4j xml/a

  1. #1
    Join Date
    Apr 2008
    Posts
    18

    Default mondrian olap4j xml/a

    Hello,

    with olap4j I want get information of mondrian server with using XML/A. So I have established mondrian as the XML/A provider how it is describe in the installation guide of mondrian.
    I use Access as database and want connect me from a java application to mondrian.
    But I get the SOAP message with contains the following error message:

    Mondrian Error:Internal error: no data source is configured with name 'MondrianFoodMart'

    The content of my datasource.xml is

    <?xml version="1.0"?>
    <DataSources>
    <DataSource>
    <DataSourceName>MondrianFoodMart;</DataSourceName>
    <DataSourceDescription>Mondrian FoodMart Data Warehouse</DataSourceDescription>
    <URL>http://localhost:8080/mondrian/xmla</URL>
    <DataSourceInfo>Provider=mondrian;Jdbc=jdbcdbc:MondrianFoodMart;JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver;</DataSourceInfo>
    <ProviderName>Mondrian</ProviderName>
    <ProviderType>MDP</ProviderType>
    <AuthenticationMode>Unauthenticated</AuthenticationMode>
    <Catalogs>
    <Catalog name="FoodMart">
    <Definition>/WEB-INF/queries/FoodMart.xml</Definition>
    </Catalog>
    </Catalogs>
    </DataSource>
    </DataSources>


    The content of mondrian.properties is:

    # Allow the use of aggregates
    mondrian.rolap.aggregates.Use=true
    mondrian.rolap.aggregates.Read=true
    mondrian.native.topcount.enable=true
    mondrian.native.filter.enable=true

    # mondrian.properties
    mondrian.result.limit=50000

    # For XML/A JSPs
    mondrian.test.connectString=Provider=mondrian;Jdbc=jdbcdbc:MondrianFoodMart;JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver;Catalog=/WEB-INF/queries/FoodMart.xml;

    The xmla properties in web.xml are:

    <servlet>
    <servlet-name>MondrianXmlaServlet</servlet-name>
    <servlet-class>mondrian.xmla.impl.DefaultXmlaServlet</servlet-class>
    </servlet>

    <servlet-mapping>
    <servlet-name>MondrianXmlaServlet</servlet-name>
    <url-pattern>/xmla</url-pattern>
    </servlet-mapping>


    The call to get a connection from the Java application is:

    Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
    Connection connection =
    DriverManager.getConnection(
    "jdbc:xmla:"
    + "Server=http://192.168.0.224:8080/mondrian/xmla;"
    + "Catalog=FoodMart");


    Have I forgetton something? Is somewhere a mistake?

    Best regards
    cakbulut

  2. #2
    Join Date
    Apr 2008
    Posts
    18

    Default

    Hello,

    I have found my mistake. It was the semicolon (red marked) in the fourth line of the datasources.xml

    <DataSourceName>MondrianFoodMart;</DataSourceName>

    Best regards
    cakbulut

  3. #3
    Join Date
    Nov 1999
    Posts
    1,618

    Default

    Thanks for the feedback. I had to go through that process today, and it's certainly tricky to configure. Trying to think of ways we can simplify the format of datasources.xml and the connect-string options for the XMLA olap4j driver.

    Julian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.