Releases

From OpenI Wiki

This page contains specific technical, design documentation and features for each release.

Table of contents

OpenI 2.0


OpenI 1.3.0

New Features

OpenI 1.3
Feature Lead Status Description
Filter Multple Selections Dipendra beta multiple tuples in the WHERE clause seems to be only supported by sql2005, or can we use the WITH MEMBER clause
I18n Pedro beta
Customizable Groups dipendra beta
Dashboard enhancements plucas beta Dashboard as a link in the nav
Live EDA plucas beta next iteration of Autogenerate
Printable Dashboard plucas beta
direct link to analysis dipendra beta
Queued Drillthrough dipendra beta Need to migrate some closed source code into openi
Menu Management dipendra beta
Project Upload dipendra beta for deploying and uploading new projects, in zip format
Segment Generator plucas beta
Enhanced Security dipendra beta
Spring Updates dipendra beta update to spring 2.0 release
Feed Services dipendra beta
JFreeChart jar updates dipendra beta - updated to 1.0.0 need to update jar for jfreechart, since some chart types do not work
User Profile pedro beta part of i18n
Usage Log plucas removed delim file fact table friendly, to track site/project/individual usage
Jdk_1.5_Upgrade plucas beta can you call it an upgrade when it was released 30 years ago?
JTDS_1.2_Upgrade dpokhrel beta update JTDS JDBC driver to version 1.2
JPivot_1.6_Upgrade dpokhrel beta update jpivot to 1.6 version
JSTL_1.1_Upgrade dpokhrel beta merge the updates done by pedro
Pedro_Updates_Merge dpokhrel beta merge the updates done by pedro including fixes
Hide_DT_button_on_calc_member dpokhrel beta need to hide drillthrough link in cell for the slicer with calculated member

Pushed Features - not this time

Application_Admin_Project create a separate app admin project, instead of each project with the manage application link. Just a separate openi-project/admin
User_Preferences
Hideable Left Nav
Dashboard Sort Configuration plucas not started
Jdbc Connection Pool not started
Create_New_Project
Properties Tab Enhancements move properties toolbar buttons to properties tab, always enable properties tab, layout options: deck of cards? control panel? minitoolbar?
User Management jagan deploy problems, still in branch branch: Autogenerated_Growth_Over_Previous_Period
Autogenerated Growth Over Previous Period jagan removed from release unstable version of jpivot, unstable isolation from jpivot,

Bug fixes and enhancements

    • 1273480 - jpivot+mondrian xmla - problem with some foodmart cubes
    • 1288919 - drillthrough unique results?
    • 1339400 - Multiple menu entry
    • 1396544 - Chat scale value does not match with table data
    • 1403441 - cannot browse calculated measures w mondrian
    • 1449283 - add new permissions - delete personal content
    • 1503034 - filter multiple - create toggle for backwards compatibility
    • 1503090 - analysis "direct link"
    • 1504862 - remember drill replace
    • 1505558 - AnalysisAdapter - dupe code
    • 1508930 - sql2005 autogenerate - multiple hierarchy problems
    • 1511087 - Live EDA - mondrian measures discovery
    • 1511089 - dashboard performance
    • 1511443 - updated spring jars
    • 1512862 - project upload exception
    • 1522151 - rdbms permalink
    • 1522160 - dashboard permalink
    • 1522223 - Menu configuration - link label
    • 1522234 - Nav link in Dashboard - only when there's an analysis
    • 1522235 - Dashboard nav link - change to img
    • 1522239 - Dashboard nav link - children expands
    • 1524872 - feed services: filesize units
    • 1524873 - feed services - date format
    • 1524874 - feed services - feed selection
    • 1528709 - autogenerated growth - formula wrong
    • 1529161 - project download/upload - documentation needed
    • 1529208 - feed services - remote directory
    • 1529254 - feed services - header alignment
    • 1529258 - feed services - navigation
    • 1529260 - printable=true in model.jsp
    • 1529264 - feed services - system parses header
    • 1529281 - feed services - feed selection sort order
    • 1529511 - Jasper throws an exception in absence of net connection
    • 1532112 - queued drillthrough documentation
    • 1544959 - feed services - header formatting
    • 1548186 - feed services - InvocationException
    • 1549631 - discover measures - mondrian
    • 1550185 - chart subtitle - add to jsp
    • 1553512 - upload file does not handle invalid upload
    • 1553519 - Menu filters needs to be on userid not username
    • 1554266 - Live EDA - cancel does not remove prev state
    • 1554305 - menu - dashboard links should include projectId
    • 1554330 - segment designer - show sql option
    • 1554509 - Double quote give wrong column count in manage feeds
    • 1554515 - More file extensions needed for manage feeds
    • 1558835 - drillthrough db connections
    • 1559563 - list pull - lower batch size
    • 1559597 - tree nav - sub.jrxml not hidden
    • 1561667 - drillthrough and with members
    • 1561669 - chart title property display to subtitle
    • 1561676 - Multiple filter selection - then dimension
    • 1563059 - tree nav - IE display problems
    • 1565792 - debug page
    • 1565991 - powered by openi footer - make it configurable
    • 1568132 - ???edit_application.applicationSubtitle???
    • 1569357 - jpivot build - post 9/29
    • 1574171 - website copyright
    • 1641309 - List pull (Drill through) bug

Known Issues

  • For MSAS 2000, hiding drillthrough in cell for calculated member in slicer works only when the calculated member is created by 'WITH MEMBER' clause. It does not work if calculated member is defined in OLAP. This is not a bug but the limitation on MS-XMLA. So in this cae, you will get olap exception, if the MDX contains OLAP defined calculated member in slicer.
  • Mondrian and JPivot have several bugs
    • List of bugs:
      • Drill through raises an exception. Even this is fixed, the slicer is not active.
      • When a filter is use on a dimension, the slicer doesn't print it. Also in the navigator we can't see the filter set.
      • Several "hard coded" texts.
      • Calculated measures are not visible in the navigator. However, they can be used directly in the MDX sentence.
    • Workaround: make sure you have installed mondrian 2.2.2. Then, download the openi-1.3.0-i18n-pack.zip file. It contains four jar files (mondrian.jar, wcf.jar, tbutils-wcf.jar, jpivot.jar). Unpack it and replace this files both in <OpenI home>/WEB-INF/lib and <mondrian home>/WEB-INF/lib.

OpenI 1.2.1 - 2006/6/21

  • bug fix release
  • branch: branch_1_2
  • tag: stella_branch_1_2_20060621_1640_16
  • jpivot version: HEAD from 2006-03-14 (unchanged)
  • OpenI_1.2.1_Release_Notes

Feature Enhancements

  • Read_Only_Access - add a new user access level, which allows read only access to analyses, no admin directory visible.
  • Improved jasper functionality:
    • export features
    • subreport features
    • parameterizable reports
  • Multiple_Hierarchies_Issues

Bug Fixes

1473128  RDBMS - buffer overflow problems
1473691  sql2005 compat problems - adventure works
1473732  header problems in IE/ff
1473748  read only toolbar
1475313  Clicking SQL toolbar button doesn't show SQL Editor
1477949  download project exception on windows
1480672  Configure dashboards in IE
1480675  Manage files, when a file has no extension
1481276  mysql create foodmart script on 5.0, win
1491318  jasper - hide sub reports
1491319  jasper browser back button and params
1493894  dash board - sort order
1493896  dashboard - missing analysis throws exception
1495147  jasper - allow subreports
1495252  jasper (menu) hide subreport - sub.jrxml
1497793  dashboard - autogenerated
1504851  avoid ie flicker
1508930  sql2005 autogenerate - multiple hierarchy problems

Known Issues

  • Problem with header on firefox 1.0x

OpenI 1.2 - released 4/14/2006

  • OpenI_1.2_Release_Notes
  • CVS Tags
    • branch: branch_1_2
    • alpha: stella_HEAD_20060307_1702_15, 3/7/2006 (problem with some versions of sql2000)
    • alpha2: stella_HEAD_20060308_1542_34, 3/8/2006 (fixed compat with sql2000, 2005, various service packs)
    • alpha3: stella_HEAD_20060316_1116_22, 3/16/2006 (Stable sql2005 integration)
    • beta: alpha3
    • final: stella_HEAD_20060414_0123_26, 4/14/2006
  • jpivot version: HEAD from 2006-03-14
  • Release Date: 14 Apr 2006

New Features

OpenI 1.1.1 - released 11/30/2005

  • release based on:
    • openi 1.1
      • branch: branch_1_1
      • beta release tag: stella_branch_1_1_20051117_1658_52
      • RELEASE tag: stella_branch_1_1_20051129_1428_58
    • jpivot version: HEAD: 2005/11/03 20:15:00 + customized XMLA_SOAP.java
    • mondrian version: HEAD: 2005/10/25 21:30:00

New Features

  • Drillthrough_Stream - Drillthrough results are no longer stored in memory! This enables much much larger drillthrough results sizes. Of course, you are still limited by sql performance, but that is another story.
  • Improved_Error_Handling - New and improved error pages that print out more reliably without wreaking havoc on your page layouts.
  • Xmla security - Old feature updated for use with tomcat 5.5 - can secure xmla datasource with basic authentication. This current version now supports xml sucurity for both tc5.0 and 5.5.
  • We have eliminated the "busy" page, which caused more user experience problems than it solved.
  • Folder_Security - Folders security can now be configured per folder - specify all, or any specific set of users who can view a certain directory.

Bug Fixes

RequestID  Summary
1359461    save as - saves both old and new
1358603    analysis does not persist drillthrough enabled
1339020    image map needs to be configurable
1338054    dimension member in nav - NullPointerException
1329682    secure folders feature
1329678    login valve refactoring
1329677    integrate 1.1.1 with latest mondrian

OpenI 1.1 - released 9/19/2005

This release contains integration with mondrian, through it's xmla implementation. Both mondrian and jpivot versions contained in this release are based off of pre-released versions, but have been tested within openi.

  • status: released
  • OpenI_1.1_Build - improved build, no longer forced to http download jpivot version
  • OpenI_1.1_Install - install docs for mondrian, mondrian xmla, mysql foodmart.
  • CVS:
    • branch: branch_1_1
    • beta release tag: stella_branch_1_1_20050902_1458_33
    • final release tag: stella_branch_1_1_20050919_1506_46
  • Mondrian version: HEAD @2005/08/25 04:30:12. (For build instructions see OpenI_1.1_Build)
  • Jpivot version: mondrian_xmla_2005_08_25

New Features

Bug Fixes

The following sf.net bugs have been addressed and closed in this release:

1293132           foodmart splash
1292709         Duplicate personal folder list in save as
1292699         Sub folders within public modules are not allowed
1290343         persist hide spans in analysis
1289174         splash.jsp link
1289155         drillthrough download formatting
1288423         Download All link in download drillthrough page
1285478         export to pdf
1282071         Error in manage files
1277264         "Diagnostics" link
1277262         Copyright message shouldn't be customizable from web UI.
1277258         Copyright message
1277198         Contact support icon
1277192         Analysis export problem.
1277190         BG color doesn't persist
1277189         JPivot new features in help page.
1277187         New analysis member order problem
1273700         Redo jpivot modifications based off of HEAD
1273526         Spring and WCF documentation
1273491         all new analyses, change rows/columns
1273487         mondrian xmla - new analyses have two measures
1273440         Document mondrian version, build process
1273429         document Mondrian install verification steps
1273389         updating jpivot jar in build - broken
1254439         Pie chart exceptions
1252086         AuthFilter - need htm mappings?
1246292         openi footer missing dot
1240003         configure invalid datasource

OpenI 1.0 - released 7/1/2005

  • initial sourceforge release
  • release date: 7/1/2005
  • CVS
    • branch tag: r1_0_branch
    • release tag: stella_r1_0_branch_20050801_1137_18


Proposed Features

  • Jboss_Deployment_Support
  • Portal_Integration
  • Certified_BI_Stack
  • ETL_Integration
  • UI_Improvements_1_2
  • Communication_Features
  • Tomcat_5.5_Upgrade - can you call it an upgrade when it was released 30 years ago? Am I repeating myself? Am I repeating myself?
  • Email_Document_Delivery
  • Excel_Connector
  • Writeback Capability
    • Allow writeback to Analysis Services Cubes
  • Disjointed Reports
    • Ability to create reports containing data from multiple sources - eg a report which contains data from two different cubes
    • A report which contains data from one cube and also from a relational source
    • note: dashboards can use any number of olap datasources (as of openi 1.2)
  • AJAX Support for drill down / up
    • To be able to drill down / up and just refresh the relevant part of the table / screen without the need to submit the whole page
  • Export cubes from MSAS to mondrian
  • Separate Application Admin project
  • Exclude_Members - similar to the multiple filter members, but specifically exclude members from view. MDX does have this function available called Except
  • Report locking
  • Failed analysis - need to allow edit of MDX
  • show totals in tables, but suppress in chart (ask jim)
  • Maintenance - report of analyses by cube. Over time maintenance of cubes becomes necessary, and it's essential to know which ones are in use and how many times.
  • Data Extracts - we typically need to extract large datasets for predictive analytics. Would be useful to at least queue up the extract, and have the results output to a user defined directory. Notification should be sent out when complete.
  • Usability enhancements
    • dual axis chart, move to other axis
    • need improved time series handling - read properties for date format
    • "up a level" "down a level" for chart/table separately
    • "down a level, show all peers"