New in version 1.8

  • Synchronized to Mondrian 3.0.0 code base
  • Fixed several bugs (see changelog for details)
  • User can choose which properties shall be displayed (contributed by kunarief)

New in version 1.7

  • Synchronized with Mondrian, fixes a couple of compatibility Problems (Mondrian API changed)
  • Currently requires JDK1.5 because Mondrian 2.3.2 requires it. Probably future versions will run with 1.4 again
  • Groovy Scriptable Datasources - thanks to Luca Barozzi, Engineering Ingegneria Informatica S.p.A.
  • XMLA did not work with Mondrian in 1.6 (thanks to Richard Emberson)

New in version 1.6

  • Contains new Mondrian version 2.2.1
  • Custom PDF Font Support (provided by Ati)
  • 2006-11-09 14:11 - synchronized with tonbeller cvs changes
  • 2006-10-26 11:34 - fixed Date Header bug
  • 2006-10-19 12:31 - Calculated Members whose name starts with a '.' are not displayed in the navigator
  • 2006-09-19 15:18 - SplitQueryTag
  • 2006-06-23 07:22 - Fix bug in Propertis
  • 2006-06-02 15:56 - Member properties with null value can be used as parameter
  • 2006-05-05 13:10 - new Tree mode which fetches children only when they are needed
  • 2006-05-04 08:50 - Dont try to understand the query, take values from result
  • 2006-04-28 13:54 - Hide ALL-Member in "level mode" unless its on an axis
  • 2006-04-05 12:07 - fix ClassCastEx with parameters
  • 2006-03-10 09:05 - fix typo in taglib uri
  • 2006-02-06 14:39 - more logging
  • 2006-02-06 14:09 - no message
  • 2006-02-06 13:04 - fixed the way the jdbc driver, datasource etc is found
  • 2006-02-06 12:38 - new Bookmark test
  • 2006-02-02 17:42 - fix bookmark and topcount

New in version 1.5

  • Full support for Websphere and BEA
  • Contains new Mondrian version with great performance optimizations
  • installable as Portlet (see CVS)
  • many bugfixes, see changelog for details

New in version 1.4

  • Runs with BEA now (most likely)
  • Open CVS
  • Many more WCF Tests available

New in version 1.3

  • native XMLA access, i.e. no Mondrian required
  • Mondrian: Error message on resultset overflow: when the resultset exceeds some limit defined in, an error message is displayed and the previous state is restored. default is mondrian.result.limit=50000
  • Mondrian: new formatter attributes allows to format members and cells via java code
  • Mondrian: other improvements, removed CachePool (it did not do anything useful), made SmartMemberReader the default (ignores largeDimensionThreasHold)
  • wcf improvements and new features, including sql tables

New in version 1.2.1

PDF Improvements

Bugfix & more options from Print Property dialog are supported

Mondrian Improvements

NON EMPTY Crossjoin optimization included. Crossjoin of large sparsed sets resulted in OutOfMemoryException before.

New in version 1.2.0

Excel and PDF Support

contributed Excel/PDF by Ati (uramisten) - thanks a lot. Includes other fixes too, see forum.

OLAP Navigator

The navigator now groups large amounts of Members, e.g. the custmer names in the foodmart example.

Integration with JavaServer Faces

WFC (and JPivot) interoperate with JavaServer Faces. See examples in WCF download for details.

EL Syntax changed

The Syntax of the WCF Expression Language (actually its based on jakarta BeanUtils) has changed from ${expr} to #{expr} so it cooperates from the expression language available in Tomcat 5 / JSP 2.0.

So with JSP 2.0 you should use #{} notation to define expressions for WCF attributes and ${} to define JSP EL expressions.

JSP EL expressions can not be used with WCF tags currently, all tag attributes have their rtexprvalue set to false. There may be a twin library supporting JSP EL expressions in the future (similar to the twin libraries in JSTL, e.g. core and core_rt).

Static accessor for RequestContext

RequestContext has a static instance() method that returns the current instance (using java.lang.ThreadLocal). This seems to be safe since JSF uses this mechanism too

actionReference in XML form descriptions

Form handling has been simplified, see example. In the XML file describing the HTML form, the <button ...> element accepts an element named "actionReference". The value of this attribute is interpreted as the name of a function, which is called when the user presses the button. The signature of the function is void foo(RequestContext context) throws Exception;

New in version 1.1.0

Mondrian improvements

Uses the up-to-date Mondrian version with many bugfixes and improvements:
  • uses less memory (only needs 1/5 of previous Mondrian versions)
  • Mondrian is 2 times upto 20 times faster depending on the query. Most speed improvement when using aggregate
  • new caching strategy - new cache keeps as much items as possible in memory
See installation notes about how to set the JVM parameters -Xms and -Xmx.

New navigation Code

The new navigation code fixes some bugs and shortcomings. Also it reduces dependencies to mondrian. So with the new navigation code it should be easier to support other OLAP servers like XMLA and JOLAP.

Drill Thru

Individual Columns maybe selected in drill-thru table.

Bookmark Support

com.tonbeller.wcf.bookmark.BookmarkManger has static Methods to collect and restore the state of all objects in the session. Support is provided for the query with its navigations, the table settings and chart via its configuration dialog. All properties from configuration dialogs may be stored in a bookmark if the bookmark attribute of the <wcf:form...> tag is set to true.

Parameter Support

MDX Parameter may be passed as HTTP Parameters. The new JPivot tag clickable is nested inside the table tag and specifies a dimension, level or single member that shall be clickable (i.e. members are rendered with hyperlinks). The setParam tag maybe used to extract the HTTP parameter, parse its value and update a parameter of the MDX query. Finally its possible to display the current parameter values via JSTL tags. See jpivot taglib docs and example in test subdirectory for details.

Version 1.0.2

Charting Support

Robin has integrated jfreechart into jpivot with support for many different chart styles (bar chart, pie chart etc, 2D 3D). There is also a dialog to configure the chart. See screenshots for an example.

Drill Thru support

Does not seem to work with MS Access?

Member Properties

JPivot supports member properties now. There is a toolbar button that enables / disables display of properties in the table. Also there are a few predefined properties that are rendered in a special manner:
Name Value Description
style red|green|yellow renders the Member in that color
link an url creates a hyperlink on the member
arrow up|down|blank paints an arrow image
image an uri. If the uri starts with "/" the context name will be prepended paints image

Tag Library Documentation

All WCF and jpivot tags have been documented (see table of contents on the left).