error for analysis view

[hkjang]

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 ROWSfrom [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.OlapModelProxyat 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)....

[kkelleher]

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