Documentation

icCube Release Notes

6.5.4

    Server

    • - Added report-path to audited MDX requests.
    • - Fixed loading schema w/ asynchronous processing for enterprise licenses (expect faster loads).
    • - Fix possible deadlock in complex evaluations where calculated members and STATIC sets are mixed.

    Reporting

    • - Internet Explorer critical bug fix.
    • - AmCharts library upgrade.
    • - Improved layout grid configuration.
    • - Sankey chart improvements.
    • - Multiple application manager improvements.
    • - New widgets positioning mode: fixed.
    • - New widgets header mode: hidden header.
    • - Updated widgets drag and drop between pages.

    Others

    • - Migrating from 6.5.3 : details.
    • - Several enhancements and bug fixes : details.

6.5.3

    Reporting

    • - Application manager reordering / grouping functionality added.
    • - Application manager fixes and improvements.
    • - TinyMCE upgraded.
    • - Google Charts integration improvements.
    • - Bulk reports deletion / migration fixed.

    Others

    • - Migrating from 6.5.2 : details.
    • - Several enhancements and bug fixes : details.

6.5.2

    Reporting

    • - Added applications for navigating reports.
    • - Added global filter that applies to all charts.
    • - Map widget : new data configuration (Lat\Lng as rows, Lat\Lng as rows' properties).
    • - Repetition widget : fixes and improvements.
    • - Improved balloon and configuration for charts.
    • - Improved French localization.
    • - Improved Sunburst chart logic.
    • - Added widget background configuration.
    • - Added "View as table" to widgets based on server data.
    • - Added quadrants support for XY charts.
    • - Two new D3 charts: Tree Map and Partitioned.
    • - Significant performance improvements.

    Others

    • - Migrating from 6.5.1 : details.
    • - Several enhancements and bug fixes : details.

6.5.1

    Server

    • - Improved facts index (e.g., paginated, hash) to reduce amount of memory required.

    Builder

    • - Fix a bug with exist on a dimension that mixes parent-child hierarchies with multilevel. If you have a schema with a dimension that mixes hierarchies we would advise checking this carefully.

    OLAP

    • - Create measures based on existing measures defined at schema level (doc).
    • - Added a few utility functions: contextMember() and contextMembers() that are similar to currentMember and varTypeName() and valTypeName() to retrieve type information of MDX entities.
    • - Extended support for Excel format string with thousand character at the end (e.g. "0.0," will format 1000 as 1.0 - dividing by 1000).
    • - Vector supports a new list of set functions : setUnion, setMinus and setIntersect (doc).
    • - dtDatesMfd,dtDatesYfd function family returns an empty set instead of an error if the level is above the function level (e.g. dtDatesMfd( [2016] ) will return an empty set ).
    • - Fix possible deadlock in complex evaluations where calculated members and sets are mixed.
    • - Improved MDX debugger.

    Reporting

    • - Add features to the Sunburst widget.
    • - Map widget can handle new data configuration.
    • - Overall performance improvements.
    • - Add compact view and mode configuration for discussions.
    • - Fixes for AmCharts and table widgets.
    • - Overall improvements to printing.
    • - Improve Constants dialog.
    • - Auto calculation for the table widget columns width.
    • - Add export to Excel for repetition widgets.

    Libraries

    • - Upgrade to POI 3.17 (from 3.10.1).

    Others

    • - Migrating from 6.5 : details.
    • - Several enhancements and bug fixes : details.

6.5

    Server

    • - Ability to rebuild MDX result cache (GVI/reporting results) after an incremental load.
    • - Introduced the DELETE_SCHEMA_BACKUP command for deleting schema backups.
    • - Introduced comments/discussions for reports.

    OLAP

    • - Perspectives improvement, it's possible to hide a hierarchy but have the level members visible (handy for some calculated members). Documentation
    • - Introduced native functions in MDX statement. A native function is not defined in MDX; it can be defined for example as a R script.

    Builder

    • - Time Wizard date formatter support QQ and HH for quarter and half year. So, "yyyy 'Quarter' QQ" will return "2015 Quarter 1" for the first quarter of each 2015.

    Reporting

    • - New layouts management system, new configuration settings, multiple pages support
    • - New layouts: printing, tablet, mobile. Layout autodetection
    • - Improved the printing configuration
    • - Page components configuration (basic header and footer configuration, but could be used to define other page parts)
    • - Design improvements- Repetition widget- Global filtering support using any filter(checkbox in the configuration)
    • - New "comments" module (discussions)
    • - New repetition widget: allows for repeating a chart/table for a set of tuples
    • - Text widget improvements
    • - Table events reworked
    • - MDX Sets In Widgets' data Wizard- Export to PNG / Excel improvements

    Libraries

    • - Upgrade to latest SQL Server, Oracle, Postgres and MySQL JDBC libraries (yes eventually we've a new MS driver !)

    Others

    • - Migrating from 6.2 : details.
    • - Several enhancements and bug fixes : details.

6.2

    Server

    • - Fix icCube IDE behind a reverse proxy changing the base URL (was Google serialization policy error). See icCube.xml fixModuleBaseURL configuration property.
    • - Added support for services that are accessible from the reporting. The first available service is serving geo location information.
    • - Added an optional directory to load icCube plugins from (see icCube.xml additionalPlugins property).

    Builder

    • - Added support for latitude/longitude member properties (i.e., @Ic3Lat, @Ic3Long) (www).
    • - Add two new views : RowToColumns and GeoLocation ( www )

    MDX

    • - The MDX function children when applied to a calculated member is returning calculated members.
    • - Add new date time functions: dtGetDayOfMonth,dtGetDayOfWeek,dtGetDayOfYear,dtGetMonthOfYear,dtGetWeekOfYear, GetYear.
    • - Add new Percentile MDX function.
    • - Fix limit cases for binary operators on booleans and dates ( greater, smaller, equal ...). For Booleans, NULL is converted to 0, true to 1 and false to 0( FALSE = NULL is true). For Dates NULL is the first date ever ( Today() > NULL and NULL < Today() are both true). Note, SSAS converts true to -1.
    • - Experimental : A measure can be a vector of strings, Vector aggregations methods can be used on a String column.

    OLAP

    • - Fix Google API usage (i.e., concurrency issue).
    • - R support is back and has been updated to the latest Renjin version (GPL license !)

    Others

    • - Migrating from 6.1.1 : details.
    • - Several enhancements and bug fixes : details.

6.1.1

    Server

    • - Build Java CLASSPATH using command line wildcard to make maintenance easier.

    Libraries

    • - Upgrade several Apache libraries.

    Reporting

    • - Improve performance of Table widget.
    • - Remove support to Simple and SlickGrid in Table widget (simple table has been moved to Html template).

    Others

    • - Migrating from 6.1 : details.
    • - Several enhancements and bug fixes : details.

6.1

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 5.x - please review the migration information.

    Server

    • - The Docs repository support DB implementation (see docsRepositoryDB in icCube.xml) for high availability setup.
    • - Improved deployment options for the Web Reporting application (check the migration document for more information).
    • - The Docs application supports both file-system (see fileSystemRootVisibleInDocs in icCube.xml) and Web public repository editing.

    Builder

    • - Added support for Array types on RDBMS supporting this type (Postgres, Oracle,...).
    • - Added support for many to many relations based on a bridge table.
    • - Added Measures type: vector.

    Libraries

    • - Upgraded Jetty to latest version 9.4.2

    Others

    • - Migrating from 6.0.3 : details.
    • - Several enhancements and bug fixes : details.

6.0.3

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 5.x - please review the migration information.

    Server

    • - The JCR implementation of the Docs repository has been dropped and replaced by a dedicated file and DB implementation (more details in the migration document).
    • - Due to important changes in many-2-many support, existing backups with many-2-many relations cannot be recovered in 6.0.3. Please discard them.
    • - Allows for auditing MDX requests elapsed time (see icCube.xml monitoring configuration).

    Builder

    • - Expect faster building time when having many-2-many relations.

    MDX

    • - Add Prod() function, similar to the Sum() function but using the product.
    • - Add SumOn() and VectorK() functions, for advanced and fast calculations.
    • - Categories can be created on fact-indexing dimensions. And category hierarchies defined at schema level can be dropped (previously only their category members were deleted).

    Libraries

    • - Upgrade MySQL, Postgres and Redshift JDBC drivers

    Others

    • - Migrating from 6.0.1 : details.
    • - Several enhancements and bug fixes : details.

6.0.1

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 5.x - please review the migration information.

    Server

    • - Backup improvements: allows for compacting backups and keeping the last backup only (see the backupConfiguration section in the icCube.xml file for more details).
    • - Add support for Google Cloud Storage (csv files), both single and multiple files for partitioning.

    MDX

    • - Our biggest MDX+ contribution ever. 45 new date/time functions for easier navigation on a Date hierarchy. All new functions start with dt for easier lookup with auto-completion (e.g., dtPlusMonths, dtFirstDayOfWeekOfMonth, dtDatesWtd, etc...).
    • - Aggregate( {...}, DISTINCT_COUNT ) replaced by Eval( {...}, DISTINCT_COUNT ) , aggregate will therefore return the distinct count over the set.

    XMLA

    • - Add support in hierarchy definition for TimeLine filter support in Excel.

    Others

    • - Migrating from 6.0 : details.
    • - Several enhancements and bug fixes : details.

6.0

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 5.x - please review the migration information.

    Reporting

    • - A fully new reporting (reports are not compatible; sorry).
    • - You can install Reporting 5.x in the 6.x Server.
    • - Migration tool is in the way but reports will still need a manual intervention.

    Server

    • - JAVA 8 or higher is required to run icCube.
    • - Support for schema backups for hot restart of icCube server (www).
    • - Introduced the UNLOAD_PARTITIONS command for unloading partitions.
    • - Introduced the CANCEL_ALL_REQUESTS command for cancelling all active requests.

    Builder

    • - Add table partitioning for CSV and FLAT files datasources.
    • - Add table for min/max dates in Time Wizard.
    • - Javascript View, add functions arr_contains (check if present) and arr_add (avoid duplicates).

    MDX

    • - Add 'Vector Unique' as an aggregation method for measures.
    • - Vector->sort() method does not create a new vector but sorts this vector. Add copy() method.
    • - The Replicate(), CoalesceNull() functions have been introduced.
    • - Declared function (i.e., CREATE FUNCTION f() as ... ) : introduced STATIC keyword for evaluation outside any current context (www).
    • - Introduced maximum number of cells and timeout in MDX evaluation profiles to limit both the result size and processing time (see icCube.xml).
    • - Support for NON_EMPTY_BEHAVIOR calculated measure property.
    • - Write Back (i.e., update cube) has been deprecated. Please contact our support for more details.
    • - The MDX profiler has been deprecated. Please contact us for more details.
    • - The calculated member cache does not work yet (will be available in a next release).

    Libraries

    • - Upgrade Apache Commons Codec library to 1.10
    • - Upgraded Jetty to latest version 9.3.11

    Others

    • - Migrating from 5.x : details.
    • - Several enhancements and bug fixes : details.

5.2.2

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    Server

    • - Introduced the LIST_SCHEMA_EX command for displaying information about loaded, loading and unloaded schemas.

    OLAP

    • - Div( 2 , 0 ) returns null as defined in MDX/XMLA specification (alternate value is blank by default)

    Others

    • - Migrating from 5.2.1 : details.
    • - Several enhancements and bug fixes : details.

5.2.1

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    Server

    • - JAVA 8 or higher is required to run icCube.

    Builder

    Reporting

    • - Google Treemap chart is using member unique names instead of names for building the structure (solved duplicated names issue). There is no need to add the parent unique name to the MDX query, so using the MDX wizard directly might work.

    Others

    • - Migrating from 5.2 : details.
    • - Several enhancements and bug fixes : details.

5.2

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    Server

    • - JAVA 8 or higher is required to run icCube.

    Builder

    • - Improved ETL: support for cached table in Javascript (e.g., join transform) (www).

    Reporting

    • - The "Community" edition is displaying a "powered by icCube" logo.
    • - New Google HeatMaps widget.

    Others

    • - Migrating from 5.1.8 : details.
    • - Several enhancements and bug fixes : details.

5.1.8

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    Builder

    • - Add support for Amazon Redshift DB server.

    OLAP

    • - Add statements to Google BigQuery datasource
    • - Add 'inverseSelection' in Columns to Rows view

    Libraries

    • - Upgrade Google API libraries to version 1.21

    Others

    • - Migrating from 5.1.7 : details.
    • - Several enhancements and bug fixes : details.

5.1.7

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    Server

    • - Introduced HTTP headers configuration for the Web Reporting application files (www).

    Reporting

    • - Introduced HTTP caching for the application related files (see icCube.xml).

    Others

    • - Migrating from 5.1.6 : details.
    • - Several enhancements and bug fixes : details.

5.1.6

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    Reporting

    • - Fix AmCharts undefined when opening the Web Reporting.
    • - icCube/Multi-Select filter are not automatically migrated. Note that the multi-selection is achieved using control key (use iPad-multi to get the old behavior).

    OLAP

    • - IsNan and IsInfinity function accept Empty/null as parameter (will return false).
    • - Several enhancements and bug fixes : details.

    Others

    • - Migrating from 5.1.5 : details.
    • - Several enhancements and bug fixes : details.

5.1.5

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    Server

    • - Alerts have been introduced. Alerts are MDX boolean expressions that can be scheduled to run at specific time and/or after schema data has been updated. When positive, a notification (eMail) is sent. This eMail can for example reference a report to open.
    • - The notification service has been extended to support alerts.
    • - Cron triggers are now supported in the load schema scheduler (as well as in the new alert scheduler).
    • - Introduced the LOAD_MEASURE_GROUP command for reloading measure group (aka. facts).
    • - New MDX function SchemaUpdateTime and changed meaning of the function SchemaRefreshTime.

    OLAP Engine

    • - Add two new fact aggregation types: Vector and Vector (Sorted). Both return a Vector and EMPTY if no rows have been aggregated.

    Libraries

    • - Upgrade MongoDB JDBC driver to version 3.2
    • - Upgrade MySql JDBC driver to version 5.1.38
    • - Upgrade PostgreSQL JDBC driver to version 9.4.1207 (JRE 1.7)
    • - Upgrade SQL Server JDBC driver to version 4.2
    • - Upgrade Apache Common Maths to version 3.3.5
    • - Upgrade JS Amcharts to version to 3.18.5

    Others

    • - Migrating from 5.1.4 : details.
    • - Several enhancements and bug fixes : details.

5.1.4

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.
    • - This is a maintenance release fixing bugs (see below).

    Others

    • - Migrating from 5.1.3 : details.
    • - Several enhancements and bug fixes : details.

5.1.3

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.
    • - This is mainly a maintenance release (fixing an evaluation bug, see below).

    Server

    • - Configuration: a new directory (audit) containing persistent audit information has been added to the section in the icCube.xml file.
    • - Monitoring: a new audit section has been added to the section of the icCube.xml file: auditing 'opened reports' is currently available. More details available here.

    Reporting

    • - New Calendar chart (Google Visualization integration).
    • - New DatePicker filter widget supporting range and HTML5 datepicker when available.
    • - New option for Amcharts widgets to set bar colors from MDX query (as Table and Pivot Table).
    • - HtmlWidget Template widgets support cell and legend click event.
    • - CellClick event support cellValue() and cellFValue() methods. They return the value and the formatted value of the clicked cell.

    MDX

    • - Vector and Matrix function have been split in Vector/VectorN and Matrix/MatrixN function. Use VectorN and MatrixN for scalar values, e.g. VectorN(2,3,4) and MatrixN( Vector(..) ).
    • - Power operator, A ^ B, returns NULL if A or B are null (before NULL was converted to 0 before applying the operator). This is more mathematically consistent.

    Builder

    • - Add support to merge multiple files (csv and flat files).
    • - Improved support for dates in Javascript ETL view.

    OLAP Engine

    • - Add //#User() annotation for impersonation (i.e., executing the request with a different role) support.

    XMLA

    • - Fix Excel 2016 connection.

    Others

    • - Migrating from 5.1.2 : details.
    • - Several enhancements and bug fixes : details.

5.1.2

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.
    • - This is mainly a maintenance release (fixing an evaluation bug, see below).

    Builder

    • - Add support for Hadoop/Impala datasource (you'll have to manually add the jar files).

    OLAP Engine ( *** Important ***)

    • - Fix bug when evaluating a tuple in a calculated member that overwrites a subquery/subselect hierarchy. This happens in certain scenarios. See issue for more information.

    Others

    • - Several enhancements and bug fixes : details.

5.1.1

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    MDX

    • - New Eval() function. We advise using this instead of Aggregate function as it handles many-to-many and aggregation types correctly.
    • - New Slicer(), SubSelectAxis(), and GetFilterInfo() functions.
    • - LookupByKey() accepts a set of members as second parameter (will return a set).

    OLAP Engine

    • - Fix bug in Aggregate function on measures with count aggregation type. Result might be wrong.

    Reporting

    • - Redesign widgets defaults so they are not longer fixed on widget creation.
    • - Widget Navigation improved with new modes and add a new filter visualization (check examples )
    • - Add support for Gantt and Bullet charts ( Gantt )
    • - Add behaviour option to Actions/Buttons widget so it can behave like a choice or a button.
    • - Remove onClick/css-style option from Actions/Buttons widget.
    • - Update libraries amchart to version 3.14.5 and d3 to version 3.5.6.

    XMLA Commands

    • - LOAD_SCHEMA_FROM XML command: the 'write' parameter allows for saving the schema definition into a file.

    Others

    • - Several enhancements and bug fixes : details.

5.1

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    Web Reporting

    • - Migrate to latest amchart version 3.14.1
    • - Support for NON EMPTY in Navigation Strategy is back.

    Builder

    • - Add sorting View supporting parent/child sorting.
    • - Union View supports table with different columns.
    • - Javascript View allows for redefining forwarded column type.

    OLAP Engine

    • - Introduced support for storing index in files.

    MDX

    • - TopCount like functions support string as value expression (fix bug in Excel's slicer).
    • - LookupByKey accepts a member as second parameter.

    Others

    • - Several enhancements and bug fixes : details.

5.0.2

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    Web Reporting

    • - Printing report fix.

    OLAP Engine

    • - Add option to measure to zero instead of empty in aggregations.

    MDX

    • - Add SubCubeOthers MDX function (www).

    Others

    • - Several enhancements and bug fixes : details.

5.0.1

    Compatibility Notes ( *** Read Carefully *** )

    • - Migrating from 4.8.x - please review the 5.0 migration below in this document.

    Builder

    • - ETL support: several fixes (see list below).

    Others

    • - Several enhancements and bug fixes : details.

5.0

    Compatibility Notes ( *** Read Carefully *** )

    • - The Web Reporting has been upgraded : please ensure your existing reports are properly migrated and ensure to backup your production environment before upgrading the Web Reporting.
    • - The Web Reporting repository on the server (i.e., JCR) has been upgraded : please ensure to backup your production environment before upgrading icCube.
    • - Roles (aka. security profiles) have been extended to support perspectives authorization (i.e., allowing/denying perspectives). Please check the migration document for more details.

    Web Reporting

    • - The Web Reporting is now available in all icCube editions including the Community edition.
    • - Add new navigation menu for widgets, giving more flexibility to end users to navigate on data.

    Server

    • - Roles (aka. security profiles) have been extended to support perspectives authorization (i.e., allowing/denying perspectives).
    • - JAVA MDX configuration : active with minimal support (icCube OO extensions).
    • - Added MDX execution profiles to control CPU resource allocation when processing MDX requests. See the mdxEvalConfiguration within the icCube.xml file for more details.

    Builder

    • - ETL support (www) : added data table views that allows for transforming data tables (e.g., union, columns 2 rows denormalization, ad-hoc processing using javascript code, etc...). The javascript code view requires a JRE 1.8.x.
    • - Add option, 'ignore collision name' in hierarchy levels. This allows to load bad quality data, where the same id/key has several names for the same member (e.g. 'Men's Springblade Running Shoe', 'Springblade Running Shoe'). Nonetheless, we strongly advise not using this flag in production and keeping it during POC and development phase.
    • - JDBC table : (re)activate automatic cleanup of not used columns.

    Scheduler

    • - Improved DAILY scheduling: allows for defining a list of days of month; e.g., '1,-1' is scheduling a job for both the first and last days of month.

    OLAP Engine

    • - Introduced configuration properties : icCube.dimMemBufferSize and icCube.factMemBufferSize (icCube.xml) that allows for defining the size of internal buffers used for storing dimensions and facts data for better memory management. Note that the default value is lower than the previous icCube internal value.

    MDX

    • - Add new MDX functions: UpperCrossjoin, Reverse, IsUnknown and RemoveUnknown.
    • - Vector and VectorA are using parallel processing. Vector( Unorder(x), ) will take into account the unorder flag and be faster mostly with the EXCLUDEEMPTY flag active.
    • - Category members can be added to any hierarchy (not limited to category hierarchy anymore).

    Libraries

    • - Upgraded Jackrabbit JCR (Docs) to version 2.8.0
    • - Upgraded Jetty to latest version 9.2.9
    • - Upgraded to Apache commons math 3.4.1 (from 3.3).

    Others

    • - Migrating from 4.8.2 : details.
    • - Several enhancements and bug fixes : details.

4.8.2

    Compatibility Notes ( *** Read Carefully *** )

    • - Autoexist on calculated members is using the parent member and not longer the 'all' member (www )
    • - Fix calculated member tuple completion on certain scenarios (www )
    • - Drillthrough: when drilling through a single measure cell, all the measures of the measure group of this measure are returned.

    UI

    • - Refresh the look and improved load schema management.
    • - Update Text editor and MDX Result Pivot Table to latest versions.
    • - Added a banner to distinguish icCube environments: DEV, PROD, QA, etc... (icCube.xml : environment).

    Server

    • - Improved on-the-fly authorization support (e.g., IDE).
    • - Introduced the LOAD_PARTITIONS command for loading (and reloading) partitions (www).

    Builder

    • - Add web file support for CSV and File datasources ( http://myServer/logs/MyLog.cvs )
    • - Improved loading time for models with partitions.

    OLAP Engine

    • - Important performance improvement for SELECT with WHERE clause defined with large sets.
    • - Important performance improvement for SELECT with NON EMPTY axes (can be a few order of magnitudes).
    • - Important performance improvement for SELECT with axes containing vector of [Measures]. E.g., [Measures].members.
    • - Parallel and improved processing on TopCount like statements.

    MDX

    • - Introduced DEFINE_DEFAULT_MEMBER statement to redefine a hierarchy default member from scripts (www).
    • - Introduced 'default' to define the hierarchy default member at Perspectives level (www).
    • - Rename of columns for DRILLTHROUGH statement (www) and improved support for [Measures] in single-cell mode (the whole measure group is returned and added the possibility to return a set of measures).
    • - New SELECT annotation (//#Prop) that allows for overriding values of read/write OLAP properties as defined in the icCube.xml file (www).

    XMLA

    • - Massive speed improvement for discovering larger models on an Excel discover requests (discover on members).

    Configuration file icCube.xml

    • - Add support for server environment definition (icCube.xml : environment).
    • - Add new settings for performance tuning (icCube.mdxEvalFastNonEmptyAxis, icCube.mdxEvalMeasureVector and icCube.mdxEvalLambdaProcessingMode)

    Libraries

    • - Upgrade Oracle JDBC driver to version 12.1.0.2 (JRE 1.7)
    • - Upgrade SQL Server JDBC driver to version 4.1 (JRE 1.7)
    • - Upgrade MySql JDBC driver to version 5.1.34

    Others

    • - Migrating from 4.8.1 : details.
    • - Several enhancements and bug fixes : details.

4.8.1

    Compatibility Notes ( *** Read Carefully *** )

    • - Password hash for SMTP configuration needs to be recalculated (icCube-notification.xml). This new version uses a more robust hash technique.

    OLAP Engine

    • - Faster aggregation engine (especially when using facts-on-files).

    XMLA

    • - Support for 1024 (0x400) locale identifier (user default).

    Web Reporting

    • - Pivot table export to Excel: improved support for data format (MDX FORMAT_STRING), added cell color and text color (MDX BACK_COLOR/FORE_COLOR), locked headers, column width. Switched to Excel 2007 format (xlsx files).

    Others

    • - Migrating from 4.8 : details.
    • - Several enhancements and bug fixes : details.
    • - Upgrade SQL Server JDBC driver to version 4.0.2206.100

4.8

    Compatibility Notes ( *** Read Carefully *** )

    • - New more secure hash algorithm for users passwords and data sources (RDBM & MongoDB) has been introduced (IcCubeAuthenticationService). The old definitions will automatically be migrated. As usual before upgrading, please backup your production installation before starting icCube.
    • - Matrix rows / columns have been switched to be consistent with MDX(e.g. value(2,0) it's now value(0,2) ).
    • - Offline snapshots are escaping internal table IDs; this should have no impact when icCube IDs are used but you might experience some compatibility issues when reading old snapshots. Contacts us in case of problems.
    • - Standard MDX does not allow a tuple to contain several members of the same hierarchy. The new property icCube.dimensionalityCheck is relaxing this condition during the evaluation of axis, calculated members, and set formula; this flag is set to false by default. For the same behaviour as previous versions of icCube or SaaS you can switch the flag to true.
    • - Uploading manually old schemas through the GWT interface might generate some validation errors in Dimensions/Facts Links; please change manually 'Not Specified' to 'Not Mapped'.

    Server

    • - Improved password security. New more secure hash algorithm for passwords for IcCubeAuthenticationService. See icCube.xml for further information and configuration settings.
    • - Added the possibility to configure Jetty Web App init parameters (e.g., renaming JSESSIONID cookie to avoid collisions if icCube is behind a J2EE server as Tomcat); more details can be found in here.
    • - Warning notifications (e.g., eMails) are sent when the license is about to expire (30 days, 15 days, and 1 day); more details can be found in the configuration of the notification service.

    OLAP Engine

    • - Release constraint to allow to have the same hierarchy on different axis ( dimensionalityCheck property in icCube.xml ).
    • - The MDX function current behaves like currentMember. If dimensionalityCheck is set to false, both might return a set of members if the tuple has two members of the same hierarchy.
    • - Add new MDX functions to handle matrices and vectors : MatrixA, VectorA, SetAxes, ElementValue.
    • - Possibility to expand a MatrixA and VectorA rows and columns ( SELECT .. ON AXES FROM [MyCube]. Check examples MatrixA.
    • - Add new functions to Vector (pMin, pMax, pDif, pAbs, corr, fft, value) and Matrix (min, mean, max and sum, round, value).
    • - The MDX function LookupByKey is now supporting multi-value keys.
    • - DivN, PercN and MinusN MDX+ functions have a third optional parameter that behaves like a CoalesceEmpty (if the result is null use the third parameter).
    • - MDX result cache : XMLA cache has been added, before only GVI requests were cached. New cache uses compression that increases by a factor of 5/10 the number of requests that can be cached.

    Builder

    • - Improved dimension/facts links use case : explicit types of links and a new wizard that is suggesting a default mapping.

    Web Reporting

    • - New pivot-table able : handle large amount of data and better rendering (e.g., locked headers).
    • - Introduced request compression for faster response time with large MDX, large amount of data to export to Excel, etc...

    Libraries

    • - Upgrade to Apache common-math-3.3 (from 3.2) and POI 3.10.1 (from 3.10).
    • - Upgrade to postgresql-9.3-1102.jdbc41

    Others

    • - Migrating from 4.7 : details.
    • - Several enhancements and bug fixes : details.

4.7

    Compatibility Notes ( *** Read Carefully *** )

    • - MDX functions StringToDate and StringToDateTime : add an optional parameter to define the locale ('us', 'fr', ..). Previously the locale of the Java server was used always. From now on, the locale is taken from the XMLA/GVI request; if not available at request level, it is taken from the user's locale and eventually from the Java server. On top we're using a Java formatter that is case insensitive as opposed to the one of the Joda library (it's possible there are several very minor differences).
    • - MDX categories : introduced STATIC vs. DYNAMIC category members for category members created within a SELECT statement. Previously the behavior was equivalent to STATIC; the new default behavior is now DYNAMIC.

    OLAP Engine

    Builder

    • - Generate an error if one of the values of a multiple key is null.
    • - Change sort order for boolean columns. {true,false} -> {false,true} so it's consistent with Java.
    • - Google Data sources define a timeout value for Google Drive, Analytics and BigQuery.
    • - Switch data table : handy when developing a model.

    Web Reporting

    Libraries

    • - Upgrade to visualization-datasource-1.1.1.jar, joda-time-2.3.jar
    • - Upgrade Google API libraries to 1.18.

    Others

    • - Migrating from 4.6(.1) : details.
    • - Several enhancements and bug fixes : details.

4.6.1

    Builder

    • - Fix MongoDB plugin class loader error.

4.6

    Server

    • - Official support for on-the-fly authorization (aka. role) definition; more details can be found here.
    • - Updated authentication service to support on-the-fly authorization.

    OLAP Engine

    • - Configuration property : icCube.selectCellMaxCount (icCube.xml) that allows for defining the maximum number of cells generated by a SELECT statement to prevent an out-of-memory error.
    • - Improve Distinct Count calculation on dates and dates times type, fact columns of those two types are not longer optimized by default (you might use Aggressive optimization to have the same behaviour as on former versions).
    • - Improve Distinct Count Fact Column optimization algorithm and add an option at schema level to apply this optimization to all columns. This optimization might reduce column size as well as improve performance.

    XMLA

    • - MDSCHEMA_MEMBERS : support for custom member property.
    • - New LOAD schema commands adding support for reading / writing OFFLINE snapshots.

    Builder

    • - MongoDB support introduced (www).
    • - Optional table cache to speed up schema load (i.e., when tables are used both in dimension and facts building).
    • - Add support for array types in data source tables (used to define fact many-to-many relations).
    • - Excel plugin. Introduce initial row skip, support empty rows in the middle of the table and allow numbers in header.

    Libraries

    • - Upgrade to Apache POI library to version 3.10

    Others

    • - Migrating from 4.5 : details.
    • - Several enhancements and bug fixes : details.

4.5

Since version 4.2, several important changes have been introduced to support the new Web Reporting. If migrating from a version prior to 4.2 please review carefully the migration document here.

    Web Reporting

    • - AmCharts officially supported.
    • - Highcharts supported via an external plugin; contact us for more details.
    • - Bootstrap improved for better 3rd party libraries configuration (www).

    Server

    • - Migrate to the latest version of Jetty (9.1.2).

    MDX

    XMLA

    Libraries

    • - Upgrade to the latest version of Guava (16.0.1)

    Others

    • - Migrating from 4.2.1 : details.
    • - Several enhancements and bug fixes : details.

4.2.1

The Web Reporting is not ready for production : please do NOT upgrade your icCube production server if you're using the icCube Web Reporting (see migrating document for more details).

    MDX

    • - CoalesceEmpty fix (was not performing its parameter .value call).
    • - CONST FUNCTION : when a set is returned it is always materialized (better performance)
    • - Add IndexOf() MDX function
    • - Redesign the matrix object to support basic algebra (calculate inverse, solve linear equations...).
    • - Introduce an additional mode to fact table data aggregation : 'Update On Same Cell', the cube is updated with the table latest value.
    • - Add 'Sum Square' measure aggregation type (handy for doing variance calculations).

    XMLA

    • - Dates (for measures & keys) are returned in XMLA as DateTimes (with 00:00 as time). This fixes a problem with Excel that does not handle properly dates.
    • - MDSCHEMA_MEMBERS : fix for previously ignored LEVEL_NUMBER restriction.

    Builder

    • - Update & delete of rows are now supported.
    • - Add a flag to include a column with the row number for file and in memory data tables.

    Libraries

    • - Upgrade to latest version of Google API libraries (Analytics, BigQuery & Drive)
    • - Fix issues with Kosovo in Google Analytics data (depending on the year it's returning without continent and subregion)
    • - Upgrade to commons-math3.3-2 (Note if you're using Renjin you'll have to include manually commons-math-2 into the lib directory)

    Others

    • - Migrating from 4.2 : details.
    • - Several enhancements and bug fixes : details.

4.2

The Web Reporting is not ready for production : please do NOT upgrade your icCube production server if you're using the icCube Web Reporting (see migrating document for more details).

    Web Reporting

    • - Docs setup (/data is containing /shared and /users as its root directories).
    • - Support ic3report-local.js / css location has been changed and improved (www).
    • - Collaboration features : Notes, ...

    Server

    • - Migrate to the latest Jetty stable version (v9.0.6). See the migrating document for more details.
    • - JAVA MDX configuration (white-list).
    • - Handle UTF-8 with BOM files (e.g., users, roles, schemas, etc...).
    • - Introduce Ping to license Server with basic information (e.g. license name, CPU, available RAM, OS).

    MDX

    • - Fix tuple evaluation in Axis and Sets when defined with the same dimensionality as the slicer (colliding hierarchy) : ic3pub-45.
    • - Descendants(member,,LEAVES) : returns all leaves below the specified member when no level is specified.
    • - WITH [STATIC|DYNAMIC] SET : support for STATIC set at statement level (DYNAMIC is default).
    • - The engine property icCube.calcMemberDefinedUniqueName (see icCube.xml) allows for using as unique name the fully qualified name used in the calc. measure/member declaration.

    Excel

    • - Excel : display all sets (was only sets attached to a cube).
    • - Discover Dimension/Hierarchy : TIME dimension type is now specified.

    Libraries

    • - Upgrade to Commons-Logging 1.1.3 / Commons-IO 2.4
    • - Upgrade to HttpCore 4.3 / HttpClient 4.3.1

    Others

    • - Migrating from 4.1.1 : details.
    • - Several enhancements and bug fixes : details.

4.1.1

    Builder

    • - DB datasource with MySQL : Bug fix when handling several connections in parallel.

    Others

4.1

    Web Reporting

    • - Highcharts integration.
    • - New event : on-rows-click (e.g., connected drilldowns).
    • - New widget : textual MDX widget.

    MDX

    • - Category hierarchy/member introduced (www).
    • - Introduce Date & DateTime support for OLAP scalars (before all was DateTime). You might need to update accordingly existing schema.
    • - Declared function 'Value' typed parameter (www).
    • - New isAll, isDefault, Today, StringToDatetime, DaysBetween and VBA!Val functions.
    • - Add support for operation on dates ( date-date = number of days, date+n = add n days to date, double in millis.)
    • - Now() returns a datetime with time information ( Today() function behaves as the former now() function ).
    • - StringToDate() returns a date instead of a datetime as before ( you can use new StringToDateTime() function for dates )

    Builder

    • - New Dimension option to allow quick definition of ranged many-to-many relation.
    • - Improved 'Time Wizard' dimension : multi-hierarchy, time divisions support, usage of date as key if possible.
    • - Table columns with DATE type are not longer converted to DateTime (please check your model definition).
    • - Schema Validation does not check for JDBC datasource tables inconsistencies. This allows for more flexibility and faster load at the price of delaying errors. Nonetheless, you can validate all tables from the builder interface (Refresh All Datasources).
    • - Google datasources : BigQuery, Drive, Analytics introduced.
    • - Due to the datetime vs date change (see above) an existing offline snapshot might be broken.

    XMLA

    • - Support for ExecutionMode=Prepare (e.g., OPENQUERY(...) call support).
    • - Fix empty responses for ROWSET & MDDATASET with no items.

    Server

    • - Dynamic (no need to restart the server) configuration of the logger's levels.
    • - JAVA / R are turned off by default (see icCube.xml).
    • - The default maximum memory (-Xmx option) allocated to the JVM is 512m (see icCube.bat, icCube.sh or icCube.ini).

    Libraries

    • - Upgrade to Joda Time 2.2.

    Others

    • - Migrating from 4.0.1 : details.

4.0.1

    Reporting Tools

    • - Tableau 8 support.

    MDX

    • - Add new standard Divide() MDX function.
    • - Support for calc. member VISIBLE, CAPTION properties.
    • - Instr() made case insensitive.
    • - Filter() accepts a numerical expression as second parameter.
    • - Descendants( ..., LEAVES ) returns members of specified level as well.
    • - Improved duplicated SOLVE_ORDER behavior : first declared are first evaluated.
    • - Complete & improved MDX documentation.

    XMLA

    • - Discover MDSCHEMA_MEMBERS : support for MEMBER_TYPE restriction.
    • - DbpropMsmdFlattened2 : fix as it was supported in reverse.

    Builder

    • - Add (facts) unresolved-rows support.
    • - Add support for Sybase ASE (jTDS) as data source.

    Libraries

    • - Added Apache command line commons (commons-cli-1.2.jar).

    Others

4.0

    Java Runtime

    • - Switch to v1.7 (from 1.6) as the minimum required version.

    OLAP

    • - New calculation engine.
    • - Facts partitioning.
    • - Full schema localization (dimension, hierarchy, ... member captions).
    • - Support for large amount of schemas.
    • - Add renaming (e.g., dimension, hierarchy, ...) to perspectives.
    • - New testing framework.
    • - Drillthrough fix for parent/child hierarchies and many-2-many.
    • - Fix minor bug when connecting through OLEDB.MD driver.
    • - Fix ADO.MD minor issue.

    MDX Functions

    • - CDbl(), CLng(), CLngLng(), CSng(), CStr()
    • - GetMonitoringCounter()
    • - ToHexColor()
    • - IsIN()

    Web Reporting

    • - New widget : HTML template + SVG

    Builder

    • - DB table partitioning support.
    • - Improved dimension browsing (was validating whole datasource).

    Scheduler

    • - Allows for generating offline snapshots when loading schema.

    IDE

    • - Multiple minor UI improvements.

    Server

    • - Performance counters (e.g., memory, CPU, ...) and [$Monitoring] schema/cube.
    • - Authentication : login names case insensitivity support (e.g., Windows SSO friendly).

    Libraries

    • - Upgrade POI 3.9, JDBC MySQL 5.1.24, JDBC Postgres 9.2-1002.

    Others

    • - Migrating from 3.0.3 : details.

3.1.0 (internal release)

    OLAP

    • - Asynchronous and parallel schema load.
    • - Add unary operator aggregation type (+-*/~).
    • - Perspective : introduced rename statements (e.g., dimension, hierarchy, ...).

    Web Reporting

    • - Support for opening reports by name as well (was report unique ID only).
    • - Export to Excel fix (single row, simple table: multiple members on left columns, NaN/Infinity support).

    XMLA

    • - Improve ADOMD support.

    IDE

    • - Fix crash in Chrome when zooming.

    Libraries

    • - Upgrade Waffle (Windows SSO) version (1.5).

3.0.3

    Server

    • - Aggregate block optim. fix.

    Web Reporting

    • - Force export to Excel charset encoding (UTF8).

    Others

    • - Migrating from 3.0.1 : details.

3.0.2 (internal release)

    Builder

    • - Fix statistical dimension setup (possibly missing hierarchy).
    • - Fix incremental load with same table processed multiple times (initial full load).

    Server

    • - MDX unique name : include hierarchy name for single hierarchy dimension.

    Web Reporting

    • - Introduce spanHeaders widget option to span same header rows and columns cell tables.
    • - Pivot table : rename oddRow & evenCol CSS classes to ic3-pt-oddCol & ic3-pt-evenCol.
    • - Pivot table : fix Export to Excel (with expand/collapse).

    Libraries

    • - Upgrade GUAVA (14 rc1).

3.0.1

    Server

    • - MDX Descendants() : added support for non-specified 2 parameter (Excel 2007 usage).

    Web Reporting

    • - Fix nested-report widget with multi-value parameters.
    • - Pivot table extra-properties support.
    • - Reference latest DataTables plugin version (v1.9.4).

    Excel

    • - Fix cube name in set declaration (was missing sets in Excel).
    • - Fix sets usage in Excel 2007 (was Excel crash).

    Libraries

    • - JAVA GVI API source code and JAR packaged.
    • - Upgrade to GWT 2.5 (fix issue with widget components on latest Chrome version).

    Others

3.0

    Builder

    • - Incremental (real-time) load.

    Server

    • - Introduced a notification service (e.g., eMail on schema loaded).
    • - MDX result (Web Reporting) cache (promoted from beta status in 2.6).
    • - SESSION scoped named set support.

    Web Reporting

    • - Added perspectives support.
    • - Added report widget to embed reports within a report.
    • - Added MDX tree filter.
    • - Improved permaLink graphical setup (i.e., URL, report parameters, etc...).
    • - Improved MDX Query Builder (i.e., support for event, member search by level).

    IDE

    • - Roles/users import/export definitions.

    XMLA

    • - Added MDSCHEMA_MEASUREGROUP_DIMENSIONS / MDSCHEMA_SETS support.
    • - Schema life-cycle command status updated to reflect incremental load support (contact us for more details).

    Excel

    • - Fix refresh Pivot Table in .xlsx files.
    • - Support for Pivot Table slicer (aka. graphical filters) - see excelFixXsdLong configuration property.
    • - Support for Pivot Table Manage Sets.

    Libraries

    • - Latest JDBC driver for MySQL (5.1.22) & Postgres (9.2.1000) - icCube server.
    • - Latest TinyMCE (3.5.8) & jQuery UI (1.9.2) - Web Reporting.

    Others

2.6

    Web Reporting

    • - Report parameters.
    • - Autocomplete filter fully revamped.
    • - Ability to fire MDX on demand.
    • - Ajax collector: avoid sending several times the same request.

    server

    • - HTTPS support.
    • - MDX result cache (beta).

    Builder

    • - Parent/child hierarchy, improved all member setup.

    Libraries

    • - Upgrade to latest HTTP Core / Client (4.2.1).

    Others

    • - Migrating from 2.5.6 : details.

2.5.6

    Web Reporting

    • - MDX code completion.
    • - Query Builder widget.
    • - Explicit GVI login cleanup.

    Builder

    • - Parent-child hierarchy ordering.
    • - Refresh data-source/table improved.
    • - Duplicate dimension.
    • - Support for hierarchy with no aggregation.
    • - Support for unzipped version on the server (faster schema loading).
    • - Support for storing facts in files instead of RAM (lower icCube server physical memory requirement).

    Others

    • - Migrating from 2.5.5 : details.

2.5.5

    Miscellaneous

    • - MDX FORMAT_STRING : Add support for MS/Excel syntax ("#0.0") and improve GVI export to Excel to include formatting. JAVA syntax still available + more named formats.
    • - Web Reporting : introduced ic3Reporting class (improved application life cycle + hooks/events support).
    • - Web Reporting : new JQuery UI datepicker widget, Google Table widget remembers sorting column, increase MDX filter consistency.
    • - XMLA : fix discover level's members and cube's dimensions.
    • - Fix MDX Editor completion bug.
    • - ic3-pub : no authentication required anymore.

    Others

    • - Migrating from 2.5.4 : details.

2.5.4

    Miscellaneous

    • - Web Reporting : single JS link (ic3bootstrap.js introduced).
    • - Latest JDBC drivers : MySQL 5.1.20 (was meta-data memory error) / PostgreSQL 9.1-902.jdbc4.
    • - Latest Apache POI version (stable 3.8).
    • - MDX Object Oriented extensions introduced : Vector / Matrix.
    • - MDX / JAVA integration introduced.
    • - MDX / R integration introduced.
    • - Fix CONST function (slicer/sub-select visibility + calc-member/set usage).
    • - Evaluation tuple cache : introduced ON_DEMAND mode (REQUEST_CACHED cell property). Cell evaluation iterator improved.

    Others

    • - Migrating from 2.5.3 : details.

2.5.3

    Miscellaneous

    • - Pivot Table improvements (export to Excel, open all...).
    • - Google chart improvements (first column processing).

    Others

    • - Migrating from 2.5.2 : details.

2.5.2

    Miscellaneous

    • - OLAP Engine property icCube.mdxEvalUnknownMemberError defaulted to true (was false).
    • - Fix member lookup (Week 1 vs Week 11 + tricky Unicode alphabet).
    • - JAVA 7 validation.

    Others

    • - Migrating from 2.5.1 : details.

2.5.1

    Miscellaneous

    • - MDX : massive speed improvement with large sets in slicer, new functions (compactSet), sub-select fix for slicer usage.
    • - Engine property : introduced compactSetInSubSelect (defaulted to true).
    • - Add RGB, HSV and HSL color MDX functions.

    Others

2.5

    Miscellaneous

    • - Fix HTTP session timeout setup.
    • - DISTINCT COUNT massive speed improvement.
    • - New access rights for Web Reporting.
    • - Web Reporting (alpha).

    Others

    • - Migrating from 2.0.6 : details.

2.0.6

    Miscellaneous

    • - icCube more robust while reloading schema under heavy load (thousand MDX requests / sec.).
    • - iPad support improvements.

    Others

    • - Migrating from 2.0.5 : details.

2.0.5

    Miscellaneous

    • - MDX Script introduced, full refactoring of the creation of calculated members, sets and functions. It's now possible to dynamically create and drop them.
    • - STATIC sets have been introduced, caching the result at schema level (a single evaluation per schema load).
    • - Improve schema loading (speed and memory, around 30% improvement). Yes more facts and dimension for the community and Enterprise I editions !
    • - iPad & Android tablet support for icCube UI.
    • - Server log files accessible from the monitoring UI.
    • - Fix : enforce cube read/write access rights in WRITEBACK.
    • - Windows installer : introduced a single installer handling both 32 and 64 bits.
    • - Several minor bug fixes (see bugzilla).

    Others

    • - Migrating from 2.0.4 : details.

2.0.4

    Miscellaneous

    • - GVI : pivot table export to Excel support + GVI error improvements (error code introduced).
    • - Packaging: plugins dependent 3rd party JARs (POI) moved to main /lib directory + fix missing openCSV in Windows MSI / Mac OS
    • - Schema Load : fix memory leak when deleting previously loaded schema.
    • - Windows Installer : improved multi-version support (XP, 2003, ...).
    • - New MDX function : SchemaRefreshTime.
    • - GWT 2.4 migration + upgrade several 3rd party libs.
    • - Windows SSO support (XMLA).
    • - XMLA/TCP support removal (server-side).
    • - Drillthrough : speed improvements + sub-select fix.
    • - On-the-fly role definition support.
    • - Embedded scheduler for loading schemas (e.g, once, fixed rates, daily, etc...).

    Others

    • - Migrating from 2.0.3 : details.

2.0.3

    Miscellaneous

    • - Fix JDK compatibility issue.
    • - Fix sub-select filtering out empty tuples.

    Others

    • - Migrating from 2.0.2 : details.

2.0.2

    Miscellaneous

    • - Packaging : fix duplicated plugins jars + GWT client-side jars in /lib + minimal JCR jars + help not duplicated + latest versions of JODA / JDBC (SQL server, MySQL, Postgres, Oracle 10g).
    • - Time wizard level ordering + ASC/DESC support.
    • - MDX cell evaluation : round-robin MT executor-
    • - New functions : isNaN, isInfinite, currentCellValue (allows for improved FORMAT_STRING), stringToDate.
    • - flot (Javascript plotting library) Viz. integration.
    • - JDBC : fix possible issue on date/time conversion when servers on different timezones.
    • - MySQL datasource : fix quoted column usage.
    • - UI : import file (schema, offline, roles) improvements.
    • - Configuration (multi-homed machine) + Licensing (IP bound).

    Others

    • - Migrating from 2.0.1 : details.

2.0.1

    Miscellaneous

    • - Fix Viz. library packaging (missing library).
    • - Fix Windows installer (allows multiple installed versions).
    • - MDX Editor full screen mode focus fix.

    Others

2.0

    Miscellaneous

    • - Enterprise vs. Community Edition.
    • - Report Web Server introduced (Web documents publishing & sharing).
    • - New JS Pivot Table (integrated into MDX IDE and Viz. library).
    • - GVI + Visualization library improvements (new widgets, pivot table, etc...).
    • - MDX : DRILLTHROUGH + Perspectives + new functions.
    • - MDX IDE : better completion, better pivot-table, full screen edition mode, etc...
    • - Builder improvements : parent/child hierarchy properties, better DB case handling, level order, etc...
    • - Offline cubes support.
    • - Multi-lingual support (French localization added).
    • - Several minor bug fixes (see bugzilla).

    Others

    • - Migrating from 1.3.x : details.

1.3.4

    Miscellaneous

    • - Fix regression in Excel 2007 (DISCOVER_MEMBERS).

1.3.3

    Miscellaneous

    • - Fix two issues with Reporting Services / Report Builder protocol (see bugzilla)
    • - Change code completion and help in MDX IDE to better support Mac users (shift+space for code completion, mouse click for help).
    • - Several minor bug fixes (see bugzilla).

1.3.2

    Miscellaneous

    • - MS Reporting Service / Report Builder support.
    • - Support for MDX parameters in XMLA requests.
    • - Support for duration/period format in FORMAT_STRING.
    • - Several bug fixes (see bugzilla).

1.3.1

    Miscellaneous

    • - Several bug fixes (see bugzilla) : note Excel XMLA connection fix.

1.3

    Miscellaneous

    • - Apache authentication support.
    • - icCube Visualization Library introduced.
    • - Several bugs fixes (see bugzilla).

1.2

    Miscellaneous

    • - MDX Request cache introduced.
    • - GZIP support for XMLA responses.
    • - GWT 2.2 migration.
    • - More minor performance and memory footprint improvements.
    • - Several bugs fixes (see bugzilla).

1.1.3

    Miscellaneous

    • - Support for "unknown" dimension members fix.

1.1.2

    Miscellaneous

    • - Support for "unknown" dimension members when building facts.
    • - Support MDX EXISTING operator.
    • - MS-Access supported via the SUN JDK JDBC/ODBC bridge.
    • - Reduced memory footprint and performance improvements.
    • - Several fixes (e.g., HTTP XMLA response charset encoding).

1.1.1

    Miscellaneous

    • - Reduced memory footprint.
    • - Several performance improvements.
    • - Several fixes.

1.1.0

    Miscellaneous

    • - Several UI enhancements.
    • - Offline GVI chart export.
    • - As usual, fixes and performance improvements.

1.1.0 RC3

    Miscellaneous

    • - Introduced Web Reporting (integration with Google Visualization).
    • - Implement Authentication / Authorization (security on members/facts).
    • - Implement many-to-many on facts.
    • - UI refactoring.
    • - Introduced XMLA schema management commands.
    • - As usual, fixes and performance improvements.
    • - Definition of dimensions at cube level are not supported anymore. Migration of XML schema definition file may be done copy/pasting the dimensions from the cube section into the schema section.

1.0.2 Pegasus

    Miscellaneous

    • - Fix sub-select performance issue (regression) - this will improve response time in Excel pivot-tables when filters are used.
    • - Fix plugins setup when installing icCube over a previous version.

1.0.1 Pegasus

    Miscellaneous

    • - Not released - built as part of the client library patch.

1.0.0 Pegasus

    Miscellaneous

    • - New Pegasus engine is here, a new step on performance.
    • - Measure groups.
    • - Write back / what if simulation.
    • - Several UI improvements.

0.9.10 (internal release)

    Miscellaneous

    • - Fix exists MDX function.
    • - Make exists, nonempty, isEmpty functions faster.
    • - UI monitoring improved.

0.9.9

    Miscellaneous

    • - Performance improvements.
    • - UI new monitoring introduced.

0.9.8

    Miscellaneous

    • - Fix suggestion column list for parent/child and path dimension in Fact use case.
    • - Add column type validation for fact links (it's not possible to link a STRING with an INTEGER column).
    • - Add more cases to schema validation.
    • - Add undo (and history revisions) for schema definitions.
    • - Server request management introduced (e.g., monitoring, CANCEL, ...).

0.9.7

    Miscellaneous

    • - Builder : fix SQL statement XML serialization (from attribute to element).
    • - Examples : Sales cubes [Geography].[Geo].[All Regions] introduced.
    • - Improved memory usage.
    • - Faster aggregation engine.
    • - Several fixes and enhancements.
    • - Note the icCube application directory is named after the release version. For example: C:\Documents and Settings\user\.icCube-ci.0.9.7 - if you need to get some saved data from previous installed version please update manually this directory content.

0.9.6

    Miscellaneous

    • - MDX Editor: code completion (functions, dimensions, members, etc... ) has been introduced.
    • - MDX Editor: load/save queries.
    • - Schema/Cube Builder : table and dimension browsing.
    • - WITH [CONST] FUNCTION() AS : added optional CONST keyword to signature for declaring constant values.
    • - Several fixes and enhancements.
    • - Note the icCube application directory is named after the release version. For example: C:\Documents and Settings\user\.icCube-ci.0.9.6 - if you need to get some saved data from previous installed version please update manually this directory content.

0.9.5

    Miscellaneous

    • - Remove time expiry limitation.
    • - Several UI fixes.

0.9.4

    Miscellaneous

    • - UI : The cube builder beta version is there, enjoy.
    • - UI : improved MDX editor (better user experience, syntax highlighting, help link (click+CTRL over an MDX function).
    • - MDX: WITH function() has been introduced.
    • - Schema definition format change + naming form Factory.xml to .icc-schema convention. No backwards compatibility.
    • - New cubes examples.
    • - Several bug fixes and improvements.
    • - No obfuscation (full plugins support).

0.9.3

    Miscellaneous

    • - Several minor bug fixes.
    • - The MDX query editor highly improved with code mirror library (e.g., syntax highlighting).

0.9.2 Preview

This Preview Release version corresponds to the version of icCube as delivered with the Desktop Solution with several differences:

    Miscellaneous

    • - The localhost limitation is not applicable.
    • - The JAVA byte code is obfuscated.
    • - OLAP Function plugins are not supported. Due to obfuscation, OLAP Function plugins are not supported; both JAVA Functions and OLAP Statistical Functions are supported.
    • - Pivot Table (Query Result) : the drilldown is not activated yet.