Releases‎ > ‎

OpenI 1.x

OpenI 1.x

OpenI 1.3.0

  • Release: 7 Feb 2007
  • branch : branch_1_3
  • tag : stella_branch_1_3_20070206_0138_40
  • jpivot version: 1.6 
  • [[OpenI 1.3 Feedback]]
  • [[OpenI 1.3 Release Notes]]
  • [[OpenI 1.3 Integration]]

New Features

  • [[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]]
  • [[Jdbc Connection Pool]]
  • [[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

  • Released: 2006/6/21
  • * bug fix release
  • * branch: <code>branch_1_2</code>
  • * 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

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

New Features

  • * [[Sql_2005_Integration]]
  • * Sql2000 sp4 compatibility
  • * [[Folder_Management_UI]]
  • * [[Enhanced_Chart_Support]] - supports 2006.January and 2006.Q1 formats
  • * [[Configurable_Admin_Menu]]
  • * [[RDBMS_Reporting]]
  • * [[Dashboard]]
  • * [[R_Integration]]
  • * [[Project_Download_Zip]] - Application admins can download the project contents as a zip file.
  • * [[Autogenerator]] - auto generate a set of reports for a cube, by dimension

OpenI 1.1.1

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

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

  •   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


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. 
  •  - released 9/19/2005 =
  • * 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: <code>branch_1_1</code>
    • ** beta release tag: <code>stella_branch_1_1_20050902_1458_33</code>
    • ** final release tag: <code>stella_branch_1_1_20050919_1506_46</code>
  • * Mondrian version: <code>HEAD @2005/08/25 04:30:12</code>. (For build instructions see [[OpenI_1.1_Build]])
  • * Jpivot version: <code>mondrian_xmla_2005_08_25</code>

New Features

  • * [[Spring_Implementation]]
  • * Project configurable header message
  • * [[Mondrian_Integration]] - integration with xmla
  • * [[Jpivot_Integration_1.4.0]] - integration with latest jpivot, including modification to support mondrian xmla.
  • * [[Time_Series]]

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: <code>r1_0_branch</code>
  • ** release tag: <code>stella_r1_0_branch_20050801_1137_18</code>

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"
Comments