hkjang Posted January 22, 2008 Share Posted January 22, 2008 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]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>During creating analysis view, the procedure seems okey without error message on JasperServer. But when I click new view, I got error message as belowjavax.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).... Link to comment Share on other sites More sharing options...
kkelleher Posted February 13, 2008 Share Posted February 13, 2008 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now