error for analysis view

Hi,

I have some problem to creating analysis view on Jasper Server using Mondrian connection. Let me inform you what I have processed. Would you please provide some advice?

select {[Measures].[Total Amount]} ON COLUMNS,
NON EMPTY {[Vendor Name].[All Vendor]} ON ROWS
from [VendorAnalysis]

1. Environment. (I tried to use two table)

   • - plab_ap_trial_bal_gt_tmp(table): vendor_id, remaining_amount
   • - po_vendors(table): vendor_id(pk), vendor_name
   • - Schema xml file is below

   ---

   <Schema name="apps">
       <Dimension name="Vendor Name">
           <Hierarchy hasAll="true" allMemberName="All Vendor" primaryKey="vendor_id">
               <Table name="po_vendors"/>
               <Level name="Vendors" column="vendor_name" uniqueMembers="true"/>
           </Hierarchy>
       </Dimension>
       <Cube name="VendorAnalysis">
           <Table name="plab_ap_trial_bal_gt_tmp"/>
           <DimensionUsage name="Vendor Name" source="Vendor Name" foreignKey="vendor_id" />
           <Measure name="Total Amount" column="remaining_amount" aggregator="sum" formatString="#,##0"/>
       </Cube>
   </Schema>

   ---

2. During creating analysis view, the procedure seems okey without error message on JasperServer. But when I click new view, I got error message as below

   javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy
   at org.apache.commons.el.Logger.logError(Logger.java:484)
   at org.apache.commons.el.Logger.logError(Logger.java:588)
   at org.apache.commons.el.ArraySuffix.evaluate(ArraySuffix.java:318)
   at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)....