Jump to content

Recommended Posts


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)....

Link to comment
Share on other sites

  • 3 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...