JPivot |

JPivot Home Project Page Changelog Architecture Overview News XML/A Screenshots Contribute FOP Fonts Howto Groovy Scriptable DS WCF Unit Tests Java Doc JPivot Tags WCF Tags Mondrian Schema Plugin | ## News ## 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 2.3.2.8944, 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 mondrian.properties, 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).