Hi
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:
==
http://www.opensource.org/licenses/cpl.html.
== (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="
http://tempuri.org/XMLFile2.xsd
">
<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"/>
</Hierarchy>
</Dimension>
<Measure name="fleetnumber" column="fleetnumber" aggregator="sum" formatString="#,###"/>
<Measure name="rating" column="rating" aggregator="sum" formatString="#,###"/>
</Cube>
</Schema>
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://197.168.9.14/ald?user=user; password=X_XXXXXXX; Catalog=file:///d:/mondrian-0.4/demo/ALDCube_data.xml)