error for analysis view

0

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)....
Attachments: 
hkjang's picture
3
Joined: Jan 13 2008 - 2:38pm
Last seen: 11 years 8 months ago

1 Answer:

0
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:
http://downloads.sourceforge.net/jasperserver/JasperAnalysis_workbench-1.0.zip?modtime=1178902969&big_mirror=0



Thanks,

Kristen
kkelleher's picture
301
Joined: Jul 19 2006 - 4:59am
Last seen: 4 months 1 week ago
Feedback