I've got some troubles building a new analysis. Does anyone can tell me if my schema is correct?
== $Id: //open/mondrian/demo/FoodMart.xml#6 $
== This software is subject to the terms of the Common Public License
== Agreement, available at the following URL:
== (C) Copyright 2000-2002 Kana Software, Inc. and others.
== All Rights Reserved.
== You must accept the terms of that agreement to use this software.
<?xml version="1.0" encoding="utf-8"?>
<Schema xmlns="
<Cube name="Sales">
<Table name="data"/>
<Dimension name="country" foreignKey="country_id">
<Hierarchy hasAll="true" allMemberName="country" primaryKey="id">
<Table name="country" />
<Level name="country" column="name" uniqueMembers="true"/>
<Measure name="fleetnumber" column="fleetnumber" aggregator="sum" formatString="#,###"/>
<Measure name="rating" column="rating" aggregator="sum" formatString="#,###"/>
I'm trying this query
select {[Measures].[rating]} on columns
from Sales
And got this error:
Results: Error: Internal error: while creating RolapSchema (Provider=mondrian; jdbc:mysql://; password=X_XXXXXXX; Catalog=file:///d:/mondrian-0.4/demo/ALDCube_data.xml)