error for analysis view


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"/>
        <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"/>

  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(
    at org.apache.commons.el.Logger.logError(
    at org.apache.commons.el.ArraySuffix.evaluate(
    at org.apache.commons.el.ComplexValue.evaluate(
hkjang's picture
Joined: Jan 13 2008 - 2:38pm
Last seen: 15 years 2 months ago

1 Answer:

I'm not an expert on Mondrian schemas, so the best advice I can offer is to try loading this up in the JasperAnalysis workbench and troubleshooting it there. You can get the workbench from:


kkelleher's picture
Joined: Jul 19 2006 - 4:59am
Last seen: 3 years 10 months ago