Search
English
HierCube VCL versions history

HierCube VCL 4.56.0 (22 April 2010):

New features:

  1. New method TGridInfo.CalcLabelNodeChildCount allows to define the amount of the child nodes.

Bugs fixed:

  1. After deleting data from the database an attempt to refresh the cube gives out "Index out of range" error.

 

HierCube VCL 4.55.0 (25 February 2010):

Bugs fixed:

  1. The .DFM files for Delphi 5 have wrong format;
  2. Now the fixed columns are forced to shorten if they exceed the visible area size;
  3. The memory errors related to the wrong object destructions;
  4. The grid cannot be sorted by the last column;
  5. When a column size is changed or some node is expanded the grid "resets" the cell focus, so that the focus is set to the very first cell of the grid.

 

HierCube VCL 4.53.0 (29 October 2009):

New features:

  1. Delphi 2010 support.

Bugs fixed:

  1. Some problems are possible when sorting dates under Delphi 2009.

 

HierCube VCL 4.52.0 (8 October 2009):

New features:

  1. The columns' width can now be saved along with the rest of cube data;
  2. New property TotalValueColor sets the color of the Total values;
  3. Ability to compare hierarchy members with case sensitivity.

Bugs fixed:

  1. The font size can be wrong on export to PDF;
  2. "Not enough memory" error when working with large databases;
  3. Some errors having to do with Unicode support under Delphi 2009;
  4. Some errors in the Dimension Editor.

 

HierCube VCL 4.51.0 (28 April 2009):

New features:

  1. On changing the column width for a summary when Ctrl key is pressed, all corresponding columns for that summary change their width in the same way;
  2. A grid with huge number of cells is now rendered faster.

Bugs fixed:

  1. When changing a column width the row height is changed in a wrong way;
  2. When calling on a context menu of a row/column an error may appear;
  3. In Delphi 2007, 2009 when moving a mouse over the grid the scrollbar is flickering;
  4. When calling on a "Drill into data cell" function in a cell context menu in Delphi 2009 an error may appear.

 

HierCube VCL 4.50.0 (19 February 2009):

New features:

  1. Delphi 2009 support
  2. Some minor changes in the chart.

Bugs fixed:

  1. The null values in the chart can be displayed like any random value that leads to the redundant nodes in the chart.

 

HierCube VCL 4.49 (2 August 2007):

New features:

  1. Delphi 2007 support.
  2. Documentation updated.

Bugs fixed:

  1. Sometimes direct export to XLS files produces wrong file format, so that it cannot be opened by Excel. This especially occurs when there are many columns in the grid.
  2. When the cube raises the "There's no connection to database" exception, it hides the original exception, that may be useful to find out the reason.

 

HierCube VCL 4.48 (7 February 2007):

New features:

  1. New ability to change the default icon displayed in the internal grid. This can be done using the THierCubeGrid.OnDrawCell event handler. See description of the event for details.
  2. Documentation updated.

Bugs fixed:

  1. Sometimes the Fact Table Editor ends up with the "Out of memory" exception after clicking the "OK" button.
  2. When the source data set is empty the Fact Table Editor doesn't even show up because of the "Out of memory" exception.

 

HierCube VCL 4.47 (23 October 2006):

New features:

  1. Loading from a compressed stream is now 4 times faster. This is especially visibly on the large streams (10MB and above).
  2. New event THierCubeGrid.OnCloseDimensionEditor allows getting to know if a user has changed something in the "Dimension Editor" window.
  3. Documentation updated.

Bugs fixed:

  1. An exception is raised in the demo application when double clicking a grid cell.
  2. If the display name of a dimension is changed, all export components nevertheless put out the initial display name.

 

HierCube VCL 4.46 (23 March 2006):

New features:

  1. New event THierCubeGridExport.OnGetPageParams allows getting page properties from the printer.
  2. Documentation updated.

Bugs fixed:

  1. After filtering members in the "Dimension Editor" window sometimes the grid gets empty in spite of the fact that there are some members to be visible.
  2. When printing the grid directly on the printer, changing the page properties of the printer doesn't affect the properties of the printed grid.
  3. Memory leaks problem on using THierCubeGrid.OnGetPopupMenu event.
  4. If the cube is empty (no records in the fact table) it is not saved to the stream correctly. This leads to the exception on reading it back from the stream: "Invalid stream data at position XXX. Tag XXX expected".

 

HierCube VCL 4.45 (13 March 2006):

New features:

  1. The method THierCubeGrid.BuildViewDataset raises an exception when the HierCube library compiled under Delphi 2006.

Bugs fixed:

  1. In the "Dimension Editor" window the tool bar commands like "Select all", "Select none", and "Inverse all" don't work correctly.
  2. Sometimes when grouping dimension members, the opened (expanded) members in the grid do not restore their expanded state correctly.
  3. In the VCL Demo Application the command "Creating the cube in run time" doesn't work properly because of the wrong filed name in the database.

 

HierCube VCL 4.44 (4 March 2006):

New features:

  1. New method xhPreview.ShowPreview allows the end user to give a look at the picture of the grid before printing it.
  2. Documentation updated.

Bugs fixed:

  1. In the "Dimension Editor" window the tool bar commands like "Select all", "Select none", and "Inverse all" don't work correctly.
  2. Sometimes when grouping dimension members, the opened (expanded) members in the grid do not restore their expanded state correctly.
  3. In the VCL Demo Application the command "Creating the cube in run time" doesn't work properly because of the wrong filed name in the database.

 

HierCube VCL 4.43 (21 February 2006):

New features:

  1. Delphi 2006 support.
  2. In the "Dimension Editor" window the enhanced search has been replaced with the filter ability. Now you can filter the dimension members in order to simplify searching for a specific member. You can use the "%" symbol as a wildcard in the filter mask.
  3. The grid now can be sorted on clicking at any column header (i.e. summary, function, or sub-function). So if you even turn some headers off, still you will be able to sort the grid by any column.
  4. Documentation updated.

Bugs fixed:

  1. The dimension panels in the grid don't display their captions under Windows 98.
  2. Some panels are displayed incorrectly in "Summary Settings", "Dimension Editor", and "Dimension Map Editor" windows under Windows XP or Windows 2003 when XP themes are on.

 

HierCube VCL 4.42 (15 January 2006):

New features:

  1. In the "Dimension Editor" window enhanced search of dimension members in the tree is now possible. You can use additional search panel to find the dimension member containing specified word.
  2. Documentation updated.

Bugs fixed:

  1. Being compiled under Delphi 2005 the Tree View in "Summary Settings" window works incorrectly.
  2. The form xhFormula.dfm cannot be opened from Delphi 5. The exception "Error reading Panel1->DesignSize: Property does not exist" is raised on opening.
  3. In the "Summary Settings" window on adding calculated item wrong item icon appears.
  4. Strange behavior on scrolling dimension panels in Page and Column grid areas.

 

HierCube VCL 4.41 (2 December 2005):

New features:

  1. New event THierCubeGrid.OnInitPivotState allows setting initial state of the grid when the cube initializes. This may be extremely useful if you want a user to start exactly from the point where he stopped last time. See documentation for details on using event.
  2. New event THierCubeGrid.OnGetPopupMenu allows setting up the custom popup menu which must be shown on right mouse button click instead of standard one. See documentation for details on using event.
  3. Documentation updated.

Bugs fixed:

  1. On editing the summaries in Wizard the "Access violation" error occurs.
  2. Memory leaks in run time Dimension Editor.
  3. If set the THierCubeGrid.VisualSettings.PivotVisible = False in design time then start the application and set THierCubeGrid.VisualSettings.PivotVisible = True in runtime then the dimension panels in the grid located in the wrong order.
  4. When creating and destroying the THierCubeChart component dynamically there may be random "Access violation" errors after the chart is destroyed.

 

HierCube VCL 4.40 (23 September 2005):

New features:

  1. Unicode support! Now the HierCube library VCL works fully using Unicode symbols to represent strings. This allows displaying correct symbols even if the operating system doesn?t have the language at the moment. The Unicode is supported in all levels of the library from Unicode streams to displaying of Unicode symbols on the screen and exporting to all formats which ever support Unicode.
  2. Design time Wizard for configuration the Cube Dimension Map in more friendly mode.
  3. New event THierCubeGrid.OnCustomDrawCell allows customizing the grid cells drawing providing Canvas property to draw the graphic primitives on. See documentation for detailed description.
  4. Documentation updated.

Bugs fixed:

  1. Sometimes on drilling a dimension member "Array out of Index" exception occurs.
  2. When loading streams of earlier versions with THierCubeGrid.LoadFromStream method the "Invalid property value" exception may occur.
  3. Sometimes on restoring the previously saved grid states the dimensions that don?t have a dimension table may be restored incorrectly.
  4. Sometimes after loading the cube from stream instead of creating from the database the method THierCubeGrid.BuildViewDataset raises the "Access violation" exception.
  5. On restoring the grid state from the stream the order of summaries is not restored.

 

HierCube VCL 4.32 (8 August 2005):

New features:

  1. New functionality on saving restoring dimension members in the state. New functionality allows select what members must be saved to the stream (hidden, visible, or both) and what members must be restored from the stream (hidden or visible). This provides an ability to hide exactly those members that were hidden in the saved state or, vice versa, show only those members that were visible in the saved state. For details see description of THierCubeGrid.SaveToStream, RestoreFromStream methods in the documentation.
  2. Controlling the order of summaries in design and run time. Now the Summary Settings Editor allows moving the summaries to another location thus changing their order.
  3. Documentation updated.

Bugs fixed:

  1. Sometimes on drilling a dimension member "Array out of Index" exception occurs.
  2. When loading streams of earlier versions with THierCubeGrid.LoadFromStream method the "Invalid property value" exception may occur.

 

HierCube VCL 4.31 (27 June 2005):

New features:

  1. Calculated sub-functions. Now you can create your own sub-function, calculated on your own algorithm, and even replace the method for evaluating any standard sub-function with your own. The sub-functions now allow to create calculated cells in the grid that can be calculated by your own algorithm. See "Using custom sub-functions" chapter in tutorial for more information.
  2. New published property THierCubeGrid.SubFunctionDefs allows to define in design time what sub-functions must be available to a user at run time.
  3. New method THierCubeGrid.BuildViewDataset returns dataset with all fact table records that were used to aggregate the given grid cell. See documentation fro details.
  4. New methods THierCube.SaveUncompressed/THierCubeGrid.SaveUncompressed allow to save cube data without compressing that may sometimes be useful.
  5. Documentation updated.

Bugs fixed:

  1. In Delphi 2005 Dimension Map Editor doesn't works correctly. This is because of strange changes in standard TTreeView component in Delphi 2005.
  2. When moving a dimension from its area, so that this area becomes empty, the "Array index out of range" error can occur when another grid area has open dimension members
  3. In the dimension editor sort order may be broken when remove a dimension member from the group area.

 

HierCube VCL 4.30 (1 June 2005):

New features:

  1. Great speed and memory capacity optimization! Now the cubes having hierarchical dimensions open much faster and take less memory. The more hierarchical dimensions and hierarchical levels you have in your cube the faster it works! This is actual for any kind of hierarchical dimensions (parent-child dimensions, composite dimensions, and even for dimensions having groups). Also cubes with long dimensions now work much faster.
  2. New method THierCubeGridExport.ExportToClipboard allows to copy the grid content to the system clipboard in corresponding format.
  3. New export component THierCubeGridExportToTXT allows to export grid data in the text format.
  4. New export component THierCubeGridExportToBMP allows to export grid data in the Windows Bitmap format.
  5. New property THierCubeGridExportToExcel.Template allows to use predefined excel template on exporting rather then creating a new Excel worksheet.
  6. New property TExportOptions.MergeCells controls if the result cells will be merged when needed to display a single value of the grid.
  7. New property THierCube.Options.DupDimensionTableID defines the behavior of the cube when some dimension table contains duplicating identifiers.
  8. THierCubeGrid.OnInternalGridClick and OnInternalGridDblClick events have additional argument with useful event properties.
  9. New method THierCubeGrid.ShowAllMembers shows all hidden dimension members in the dimension.
  10. Numeric dimensions are now sorted by their values instead of their string representations.
  11. Documentation updated.

Bugs fixed:

  1. Incorrect processing of Windows messages in THierCubeGrid component. This error occurs only if there are many summaries in the cube (20 or more) and may lead to "Stack overflow" error in run time or the system crash in design time.
  2. In Delphi 2005 the Dimension Editor window's TreeView components don't show correctly the "Checked" state of the tree nodes. This causes the incorrect filtering situation after applying filters in Delphi 2005.

Migration tips:

  1. Because of the change of some event types on compiling/saving old projects may occur the errors like: "The GridBeforeEditCell method referenced by Grid.BeforeEditCell has an incompatible parameter list. Remove the reference?" If this happens do not remove the reference, click Cancel in this error window and change the type of last Args argument in the event handler. For example, in GridBeforeEditCell event you must change the type of Args parameter from TGeneralEvent to TBeforeEditCellEventArgs. You can know the new type of the second parameter from the typecasting operator in the event handler. For example, in GridBeforeEditCell event there is such typecasting operator: TBeforeEditCellEventArgs(Args), so the new type of Args parameter must be TBeforeEditCellEventArgs.

 

HierCube VCL 4.24 (25 April 2005):

New features:

  1. Now you can choose what functions must be displayed for every summary in the THierCubeChart component.
  2. New THierCubeGrid.OnInternalGridClick occurs on clicking the grid over "InternalGrid" component.
  3. New property THierCubeGrid.Active allows to know if the grid connected with the active THierCube component at the moment.
  4. New method THierCubeGrid.ShowDimensionEditor allows to show the "Dimension Editor" window in run time.
  5. Some speed optimization.
  6. Documentation updated.

Bugs fixed:

  1. When THierCubeGrid.Options property doesn't contain hgEditing flag (i.e. internal editing is disabled), pressing F2 or Enter key causes the "Access violation" exception.
  2. When assign the same dimension table to different dimensions in the "Dimension Map Editor" combo-boxes with dataset fields in the window are not updated.
  3. When there are no dimensions in the grid column area, the chart component is empty.
  4. "Access violation" exception on closing the cube when THierCube.Options.LookupHasntTheValue property has the value of lvAddFactTableID and the dimension table key field is of string type.
  5. When THierCube.Options.LookupHasntTheValue property has the value of lvAddFactTableID and the fact table has dimension values that are not in the dimension table then opening the cube may run into an endless loop.
  6. If a screen saver works for several seconds or the computer is blocked by "Ctrl+Alt+Del", then after coming back to Windows, the grid may raise an OS exception if the grid is active at the moment.
  7. Some hierarchical dimensions are not saved to a stream correctly, so after restoring such dimensions may contain duplicating items in it.
  8. THierCubeChart component raises Access Violation when the active cube is closed and then opened back from a stream.
  9. In the "Dimension Editor" window when deleting a group with the members for a non hierarchical dimension then its members go back to the member area (left tree), but their names are the same as the name of the deleted group.

 

HierCube VCL 4.23 (3 April 2005):

New features:

  1. New event THierCubeGrid.OnInternalGridDblClick is called when a user double clicks with the mouse while the mouse pointer is over InternalGrid component.
  2. New property value: THierCube.Options.LookupHasntTheValue property now may have new value lvAddFactTableID. Setting this value causes the cube to create a new dimension member when the corresponding one is not fount in the dimension table.
  3. New property TVisualSettings.ShowAbsentTuples controls if the empty combinations of dimension members are shown in the grid.
  4. Documentation updated.

Bugs fixed:

  1. The grid always shows all dimension member combinations even if there are no corresponding records in the fact table.
  2. If integer summary is edited though the in-place editor in the grid, then the resulted values are not saved correctly, so after editing the BuildCellDataset THierCubeGrid method returns strange dataset.
  3. After in-place editing the current grid cell is not restored.
  4. After grid editing all the dimensions lose their filtering state. The same happens on RefreshFactTable method.

 

HierCube VCL 4.22 (21 March 2005):

New features:

  1. THierCubeChart component now can show several summaries in a single chart. See THierCubeChart.Summaries property for details.
  2. The feature of editing the underlying database though the THierCubeGrid component has been improved.
  3. New event THierCubeGrid.BeforeEdit cell allows controlling what cells can actually be edited in the grid.
  4. New event THierCubeGrid.OnGetFactTableEditor allows changing the default fact table editor and use custom form.
  5. The THierCubeGrid.OnEditFactTable event format has been changed. So there may be an error ": method referenced by OnEditFactTable has an incompatible parameter list" on compiling the project using the old event. In this case you must change the parameter list to the following before compiling the project: (Sender: TObject; Args: TEventArgs).
  6. The same is for THierCubeGrid.OnSetEditText.
  7. New property THierCubeGrid.VisualSettings.ShowIcons allows controlling if the icons of summaries, functions, and sub-functions are displayed.
  8. New event THierCubeGrid.OnInternalGridDblClick occurs when the user double clicks with the mouse while the mouse pointer is over the InternalGrid component.
  9. New property THierCubeGridExport.ColsWidths allows changing the width of the exported columns.
  10. New property AutoSize has been added for the components: THierCubeGridExportToHTML, THierCubeGridExportToXML (XML Spreadsheep), THierCubeGridExportToMF, THierCubeGridPrint, and THierCubeGridExportToExcel.
  11. Documentation updated.

Bugs fixed:

  1. When update fact table (no matter with new or additional data) and then hide and show back any dimension member, "access violation" error occurs.
  2. The error occurs on creating a new calculated summary in run-time in "Summary Editor" window.
  3. After editing cell in the grid a error "Access violation :" occurs.
  4. When editing one grid, other grids connected to same THierCube component are not updated.
  5. In old THierCubeGrid.OnDrawDataCell event Col and Row parameters are always 0, no matter what cell is actually drawn.
  6. On exporting the grid to Excel the OLE objects are not correctly freed, so the MS Excel application stays in memory and there may be various errors because of this.
  7. On closing the cube not all memory is released, so if open/close the cube many times there may be memory leaks.
  8. In the "Dimension Editor" window when clicking the 'OK' button the edited tree node is not applies changes.
  9. The pivot state is not restored when selecting one from the internal list of pivot states.
  10. There is an "Access violation:" error on changing a range-based dimension's parameters in run-time using "Dimension Editor" window.

 

HierCube VCL 4.21 (7 February 2005):

New features:

  1. New localization functions in module xhConsts.pas: AddResStr, DeleteResStr, CreateResourceStrings give a programmer an opportunity to change the resource strings displayed on the screen in run time, giving the best chance to build multilanguage applications.
  2. New overloaded methods LoadUserData give more ability on loading user specific data from stream or file.
  3. Now for all TDataset components which are read by HierCube, the DisableControls/EnableControls methods are called, so the other components connected to the same TDataset are not updated during the reading process.
  4. New property TExportOptions.CharacterSet allows settings up the characters used on export to HTML, XML, PDF, and RTF.
  5. New property THierCubeGridExport.Units allows setting up units for the export page.
  6. Documentation updated.

Bugs fixed:

  1. When using string dimensions without dimension table, the cube saves corrupted stream, so that later THierCube.LoadUserData method raises the "Invalid property value" exception.
  2. On saving sorted state of the grid to a stream, wrong object size is saved.
  3. If save a pivot state, then add new dimension to Dimension Map, and then restore back the previous pivot state, then the new dimension is out of cube.

 

HierCube VCL 4.20 (18 January 2005):

New features:

  1. Delphi 2005 support. The distributive package now includes Delphi2005 packages.
  2. Enhanced system of events in HierCube library. New events OnDrawCell, OnExportCell, allow controlling the drawing, exporting process in a better way. See new event in the application.
  3. Universal event on pivot operations. Now on any pivot operation (rotating, filtering, etc.) the universal event handler is called. See THierCubeGrid.BeforePivot and AfterPivot events for detailed description.
  4. Working with dimension members through their names instead of indexes. Now it is possible to access the dimension members and groups in this manner: DimState.MoveToGroup('Austria.Graz.[Ernst Handel]', 'Group2'). TDimensionState class has now many overloaded methods which allow manipulating dimension members through their names. See TDimensionState.FindMember method description for details.
  5. New methods in TSummarySettings and TDimensionStates classes: BeginUpdate, EndUpdate allow preventing updating of the grid when plural changes on summaries or dimensions are performed.
  6. Enhanced working with dimension groups in run time. Now it's possible to manage dimension groups in runtime.
  7. New methods THierCube.LoadUserDataFromStream, THierCube.LoadUserDataFromFile allow reading some user specific data from the stream or file before reading the cube data.
  8. Export to PDF format has been added.
  9. Colontitles and page settings added into export components.
  10. Some speed optimization.
  11. Enhanced documentation. The documentation now includes Tutorial chapters.

Bugs fixed:

  1. Sometimes color ranking doesn't works properly (wrong grid cells are colored).
  2. The functions BuildDatasetXY, BuildDatasetX, BuildDatasetY raise an exception when using with calculated summaries.
  3. Access violation when opening a cube from an empty dataset.
  4. Some other minor problems have been fixed.

 

HierCube VCL 4.12 (2 November 2004):

New features:

  1. New value of THierCubeOptions.DimMemberIsNull type dnCreateEmptyMember. Set DimMemberIsNull to dnCreateEmptyMember if you have null dimension members in your fact table and you want that these records were counted by the cube.
  2. TPivotState now holds the sorting method on grid column value if it defined for the grid.
  3. Scrollable design time and run time Dimension Map Editors.
  4. Some speed optimization on restoring of the grid from a stream.
  5. Documentation updated.

Bugs fixed:

  1. The THierCube.Options.LookupHasntTheValue property doesn't control the situation when the dimension table doesn't contain the value of the fact table: "Array out of index" exception occurs instead on any property value.
  2. In calculated summaries the function IF doesn't work if the "ELSE" clause is used.
  3. Some sub-functions are calculated incorrectly when the dimensions in row/column area don't show totals.
  4. When the grid is sorted by some column open members of the dimension that doesn't show totals may stay in incorrect order.
  5. On sorting grid by the column value, the real position of a dimension member can change on its expanding/collapsing.

 

HierCube VCL 4.11 (25 October 2004):

New features:

  1. New methods of THierCubeGrid component: BuildDatasetXY, BuildDatasetX, BuildDatasetY return data that can be displayed in a chart component or used for some other similar purpose. See documentation for description.
  2. New event THierCubeGrid.OnChangeEditText occurs on editing of the text in grid inplace text editor.
  3. Documentation updated.

Bugs fixed:

  1. Wrong dimensions order on creating cube dimensions in run time using method THierCube.DefineFieldAsDimension.
  2. When no key fields in the cube defined, the second activating of the cube causes the access violation error.
  3. When opening the cube second time (without freeing it before opening) with different number of dimensions/summaries the access violation error occurs.
  4. Sometimes the cube freeze if using hierarchical dimensions with "NULL" values in Parent_ID field.
  5. The runtime method TCustomHierCube.UndefineField clears any information of the field in the Dimension Map, so that if later the fields is assigned with the same role, dimension for example, all dimension information is lost and must be set again.
  6. THierCubeGrid.OnSetEditText event is called on any change of the text in editor, instead of on final changing.
  7. "Internal calculation error" exception in calculation of statistical functions when there is records in the fact table for the parent members of any hierarchical dimension.

 

HierCube VCL 4.10 (28 September 2004):

New features:

  1. Ability to change a range based dimension parameters in runtime Dimension Map Editor.
  2. New method RefreshFactTable allows full refreshing the internal fact table. See documentation for description.
  3. The parameter list of the OnDrawDataCell event has been changed. On compiling a project the error can appear: "The GridDrawDataCell method referenced by Grid.OnDrawDataCell has an incompatible parameter list. Remove the reference?" Press "Cancel" button and change the parameter list as shown in TDrawDataCellEvent description (find TDrawDataCellEvent keyword).
  4. The parameter list of the OnExportDataCell event has been changed. See documentation for description of new TExportDataCellEvent event.
  5. New events in THierCube component: BeforeReadFactTable, OnReadFactTable, AfterReadFactTable. Can be used to make custom progress dialog. See documentation for description.
  6. New property THierCube.Options.DimMemberIsNull controls how to behave when a dimension member read from the database is null.
  7. New command "Hide this dimension member" allows hiding the selected member in a dimension.
  8. New method THierCubeGrid.HideThisMember executes the command of the previous point.
  9. Changing current sorting method though the grid local menu commands.
  10. Documentation updated.

Bugs fixed:

  1. In design time on deleting the lookup dataset component for one of the fields of a composite dimension, the pointer to a component doesn't set to nil.
  2. When THierCubeGrid.OnCompareDimensionMembers is not defined the dimension editor window raises a repeating access violation exception when trying to select Custom sort.
  3. Wrong custom sorting on hierarchical (composite) dimensions.

 

HierCube VCL 4.05 (16 September 2004):

New features:

  1. The sort order of dimension members in the "Dimension Editor" window now reflects the current dimension's sort order.
  2. Run time Dimension Map Editor has been improved;
  3. New command "Hide all dimension members excepting this" allows selecting the most important member in a dimension, hiding all other members.
  4. New method THierCubeGrid.HideMembersExceptThis executes the command of the previous point.
  5. New property TDimensionState.IsGroup[Index: integer] allows to learn if a dimension member is a group.
  6. Help updated.

Bugs fixed:

  1. When defining dimensions in runtime, their real indexes in the Dimension Map are different from dimension declaration order (using THierCube.DefineFieldAsDimension method).
  2. When clearing all summaries in the "Summary Setting Editor" using the button and then check one summary, other summaries are also checked.
  3. When exporting the grid second time with changed layout (column/row count) sometimes not all rows/columns are exported.
  4. When exporting directly to XLS format the result file is corrupted so that MS Excel raises the error "error on file: The data can be lost".
  5. On restoring a pivot state with defined groups it's not restored correctly or access violation error occurs.
  6. When using statistical functions sometimes THierCubeGrid component "hangs" on filtering operation.
  7. In design time Dimension Map Editor fact table fields are cloned sometimes on saving.

 

HierCube VCL 4.04 (16 August 2004):

New features:

  1. Some speed optimization.
  2. New property TVisualSettings.ShowMoreIconsButton controls whether the button displaying pivot states panel is visible in the grid.
  3. In Summary Settings Editor new buttons added: Select All, Select None, and Inverse.
  4. New method THierCubeGrid.BuildCellKeyDataset returns key fields of the fact table records needed to aggregate the value of a grid cell. See help file for description.
  5. New event THierCubeGrid.OnSetEditText is called after editing grid data cell directly in the grid.
  6. Method THierCubeGrid.SaveCurrentPivotState has been renamed into THierCubeGrid.CreateCurrentPivotState.
  7. New method THierCubeGrid.SaveCurrentPivotState saves current grid's pivot state into internal list of pivot states. If the pivot state with the given name already exists in the list then the method writes the new state with the old name.
  8. New method THierCubeGrid.DeletePivotState deletes given pivot state form internal list of pivot states.
  9. New property CurrentPivotStateName. Read this property to get the name of the current pivot state in the grid. Setting the property will cause changing the current pivot state in the grid as if RestorePivotState method had been run.
  10. New property CurrentPivotState. Read this property to get the pivot state object currently selected in the internal list of pivot states.
  11. New event THierCubeGrid.OnSavePivotState is called on saving a pivot state into internal list of pivot states.
  12. New event THierCubeGrid.OnDeletePivotState is called on deleting a pivot state from the internal list of pivot states.
  13. Help updated.

Bugs fixed:

  1. Sometimes THierCube.UpdateFactTable method raises and exception "Array index out of range".
  2. Access violation occurs on hiding all summaries in Summary Settings Editor.
  3. Access violation occurs when clicking on the grid column in empty grid.
  4. In design time in Summary Settings Editor access violation error sometimes occurs on switching between "Summary settings" and "Function settings" pages.
  5. In pivot states panel "Delete" button doesn't work.

 

HierCube VCL 4.03 (2 August 2004):

New features:

  1. Help updated.

Bugs fixed:

  1. Sometimes Access violation error occurs on pivot state restoring.
  2. Pivot state doesn't restore correctly the filter state of dimensions.
  3. On pivot state restoring sometimes sub-total values are not calculated correctly.
  4. After closing runtime Dimension Map Editor on "OK" button some dimensions are "blocked" and cannot be moved to another area any more.

 

HierCube VCL 4.02 (29 July 2004):

New features:

  1. New menu items on right-click on a dimension caption node in the grid: 'Expand all nodes', 'Collapse all nodes': allow expand/collapse all nodes for a dimension in a single command.
  2. New methods: THierCubeGrid.ExpandAllNodes, THierCubeGrid.CollapseAllNodes: program interface for commands of the previous paragraph.
  3. New menu item in the Dimension MapEditor on click on the dimension or summary - 'Delete (Del)'.
  4. The speed of all pivot operations in the grid has been increased.
  5. Help file updated.

Bugs fixed:

  1. PivotState is not restored when it has no dimensions in some grid area (Row, Column, or Page).
  2. Access violation error occurs when the cube for some reason is empty (if all members for some dimension are turned off for example).
  3. Access violation error occurs on loading a form with THierCubeChart component when some series are defined.
  4. The event handler "THirCubeGrid.OnCompareDimensionMembers" is never called, so custom sorting doesn't work.

 

HierCube VCL 4.01 (26 July 2004):

New features:

  1. Demo application shows how to use grid for editing fact table.
  2. Help file updated.

Bugs fixed:

  1. Fatal error. Sometimes the project using HierCube crushes in design time.
  2. Sometimes when moving dimensions access violation error occurs.
  3. Wrong painting of dimension panels when moving.
  4. Sometimes the hint with dimension attributes appears when mouse cursor is out of InternalGrid component.

 

HierCube VCL 4.00 (25 July 2004):

New features:

  1. Ability to edit multidimensional data directly from the grid and update the base fact table in the database.
  2. Creating composite hierarchical dimensions made from different fact table fields. ("snowflake" schema and ragged hierarchy). For example, if you have separate fields in your fact table: "Year", "Quarter", "Month" then you can create one composite hierarchical dimension "Year, Quarter, Month".
  3. Range-based dimensions. Range-based dimensions is a dimension whose members are created from the values of any numeric field in the fact table. To create dimension members all the values from the fact table are divided into several ranges. It can be used to represent many different values from the fact table in several ranges (for example "X <= 10", "10 < X <= 20", "20 < X"). HierCube Library supports two methods of range forming: "equal ranges" and "equal density".
  4. Different attributes for dimension. If you have several fields in the dimension table for some dimension, they may be used to describe dimension members. For example, the table "Customers" can have not only "name" or "last name" columns, but also "address", "phone number", "email", etc., and these columns can be displayed in the grid as a default attribute.
  5. Creating custom aggregation functions.
  6. Calculating statistical correlation function for two summaries.
  7. Direct export to XLS-format, export to RTF, XML for Analysis, XML for MS Excel.
  8. THierCubeChart component has been fully renewed. Its functionality significantly improved.
  9. Speed and memory usage optimization.

 

HierCube VCL 3.16 (18 February 2004):

New features:

  1. Method THierCube.UpdateFactTable has been improved. Now it doesn't break the current state of the grid.
  2. THierCube is now a successor of TCustomHierCube class to make easier creating of successor components.

Bugs fixed:

  1. An exception is raised in the THierCube.UpdateFactTable method when updating the string dimensions without lookup-table.
  2. An exception is raised in the THierCube.UpdateFactTable method when displaying any statistical function.
  3. The exception "Array Index out of range" occurs when fetching the cube that contains more then one integer dimensions without lookup-tables.
  4. When restoring the pivot state in the grid, the sort order of some dimensions may be wrong.

 

HierCube VCL 3.15 (8 February 2004):

New features:

  1. Speed and memory optimization. Now the cube gets opened much faster and takes for opening process much less memory. The difference can be especially huge when loading a "flat" fact table with many string dimensions. Now you can work with large fact table (millions of records, tens of dimensions and summaries) on a computer with 256Mb of memory.
  2. The loading from file runs much faster. Especially when using long dimensions (thousands of members).
  3. All operations on the cube (rotating, drilling down, filtering, etc.) are performed now faster.
  4. New event THierCubeGrid.OnExportCaptionCell. See help file for details.
  5. Help updated.

Bugs fixed:

  1. An exception is raised when filtering the dimension whose members are visible in the most detailed level of the grid and if some statistic function is used.
  2. An exception can be raised when using TGridInfo.Col2LabelNode, TGridInfo.Row2LabelNode methods.

 

HierCube VCL 3.14 (1 February 2004):

New features:

  1. The dimension length is now limited by 2^15 (32 768) members.
  2. Help updated.

Bugs fixed:

  1. An awful bug that causes all the memory to be devoured (be it 1GB or more) when the long dimensions are used in the cube (thousands of members). Can be marked when using several dimensions with more then 1000 members.

 

HierCube VCL 3.13 (22 January 2004):

New features:

  1. New property TVisualSettings.ShowPopups controls whether the popup menus are shown in the grid on right mouse click.
  2. Help updated.

Bugs fixed:

  1. The export methods don't work correctly - sometimes there are empty cells in export result.
  2. When the data source has the negative dimension values the Access Violation error occurs on cube activating.

 

HierCube VCL 3.12 (19 January 2004):

New features:

  1. Working with hierarchical dimensions has been improved in the grid. Now a dimension member may contain two buttons for drilling down: one to show detailed members of the next dimension and another to show its child members by hierarchy.
  2. The performance has been increased.
  3. The limitation of the demo version (limited cube size) has been removed. Now evaluation version can process the cubes without size restriction, but shows in the grid "demo" string instead of real values in the first nine grid cells.

Bugs fixed:

  1. The method THierCube.SaveToFile raises the exception.
  2. Such functions as Min, Max, Variance, etc. are not calculated correctly when showing the most detailed cube data in the grid (the grid cells that are not subtotals).

 

HierCube VCL 3.11 (6 January 2004):

New features:

  1. xhCache unit has been removed. Now all its the types and methods are located in xhHierCube unit.
  2. The functionality of TDimension class has been reduced. All functions and properties for working with the dimension members are now located in TDimensionState class.
  3. Some properties of THierCubeGrid corresponding for visual settings have been moved to TVisualSetting class.
  4. Working with the dimension member groups has been improved in the "dimension members" dialog.
  5. New event THierCubeGrid.OnCompareDimensionMembers allows to make an influence on sorting of dimension members. See help for details.
  6. New methods TDimensionState.CompareXXXNames allow quickly compare dimension values in OnCompareDimensionMembers event. These methods are useful for correct sorting of such dimension members as months and week days. See help and demo application sources for details.
  7. Help updated.

Bugs fixed:

  1. An exception occurs when changing DataFont, CaptionFont, LabelFont properties in TExportOption class.

 

HierCube VCL 3.10 (25 December 2003):

New features:

  1. New method THierCube.UpdateFactTable allows to download new data from the fact table and reflect it in the grid without reactivating cube.
  2. Now cube removes the dimension members that never appear in the grid. This reduces the memory occupation, increases the speed of calculation and prevents useless values from displaying in the dimension filter editor.
  3. New property TDimensionState.TotalApperance allows to control how "Total" line appears in the grid for the dimension. This property can be different for every dimension. See help for details.
  4. Dimension members grouping! Now you can group dimension members that you want analyze together having common totals for them. Also grouping may be useful if you don't want to see some particular dimension members in the grid but want to have their totals. The dimension member editor is expanded to allow groups editing.
  5. New function "Group members bellow" allows to group together all dimension members located bellow selected one in the grid just like "Hide members below".
  6. Export to WMF-file and to the printer canvas. New methods of THierCubeGrid: PaintTo(ACanvas: TCanvas; :), PrintTo(APrinter: TPrinter; :), CreateMetafile(ARect: TRect; :) allow to paint grid on any canvas, print to any printer, or create WMF object with the image of the grid.
  7. TGridExportStructure now contains information about dimension captions, so all export routines may use it to display dimension captions.
  8. New methods of THierCubeGrid: SavePivotStateToStream, ReestorePivotStateFromStream, SavePivotStateToFile, RestorePivotStateFromFile allow to save the current pivot state in any file/stream and then restore it again.
  9. New property TVisualSettings.ShowSummarySettings controls whether the summary settings are visible and available to the user of the grid in run time. See help for details.
  10. New property TVisualSettings.LowestSubLevelNode controls what sublevel nodes are visible in the grid (summaries, functions, or sub-functions). See help for details.
  11. All ".asString" methods reading database table changed to ".DisplayText" because "DisplayText" method triggers the field's "OnGetText" event, allowing the programmer to influence the displayed values.

Bugs fixed:

  1. On changing dimension display name in DimensionMap editor the changes aren't reflected in the SummarySettings structure and not displayed in the grid.
  2. If there are no dimensions located in the row area then the exception occurs on exporting to Excel.

 

HierCube VCL 3.06 (1 December 2003):

New features:

  1. New functionIFsupported in formula when defining calculated summary. Now you can define complex rules of summary calculating.
  2. Help updated.

Bugs fixed:

  1. Sometimes on large cubes the grid gives an "access violation" exception or not all dimension members are visible. This was because of cube overflow error that wasn't processed correctly. Now such a situation raises the correct exception.
  2. A calculated summary displays a wrong value when formula calculates from empty grid cells.
  3. Inside the formula the formula editor places the display name of the field but during parsing it searches the field names (which differs from display name). So the parser says "Unknown summary". Now parser processes display name too.
  4. In the THierCubeGrid component a background color is not applied correctly.

 

HierCube VCL 3.05 (20 November 2003):

New features:

  1. In OnExportDataCell event the "Value" parameter has now type of string just as OnFrawDataCell.
  2. New property TSubFunctionInfo.Alignment: TAlignment.
  3. New field TExportNode.Alignment.
  4. Help updated.

Bugs fixed:

  1. "When I drag and drop a dimension in the Dimension Map Editor an access violation exception is raised."
  2. Sometimes the export is not performed correctly.
  3. When closing TDimValuesFRM by pressing ENTER key, the changes previously made take no effect.

 

HierCube VCL 3.04 (6 October 2003):

New features:

  1. New property TVisualSettings.WordWrap: Boolean allows you to control whether the long string are split into several lines when displaying in the grid. If True then grid line heights are set to accommodate the string that is displayed.
  2. Property THierCubeChart.ControlSummaryFieldName has been renamed to ControlSummaryName. See help file for details.
  3. Help updated.

Bugs fixed:

  1. My application gets hung if I make the width of expanded grid cell too small.
  2. There is an access violation if some of lookup datasets has no records.

 

HierCube VCL 3.03 (25 September 2003):

New features:

  1. New method THierCubeGrid.AddSummary allows to add a new calculated summary in run time. The cube may not be active when you can call the method. See help file for details.
  2. New method THierCubeGrid.RemoveSummary allows to remove any calculated summary in run time. The cube may not be active when you can call the method. See help file for details
  3. New TGridInfo methods SaveCurrentPivotState and RestorePivotState allow to save and restore the grid pivot state. See help file for details.
  4. New TGridInfo methods: Row2LabelNode, Col2LabelNode, IsLeaf. See help file for details.
  5. New THierCubeGrid methods: DimID2LocalIndex, LocalIndex2DimID. See help file for details.
  6. Help updated.

Bugs fixed:

  1. In design time dimension map editor on changing the "Type of element:" property the whole group "For Dimension" always gets disabled, so it is impossible to change the dimension properties until the dimension field is reselected in the field list.
  2. An exception occurs when I try to show in the grid a dimension with null members (empty strings).
  3. In evaluation version there may be a situation when the active cube size exceeds the maximum allowed and the operation doesn't break, so the cube becomes throw many exceptions on almost every operation such as filtering (drilling), moving, and so on.

 

HierCube VCL 3.02 (21 September 2003):

New features:

  1. The dimension map editor doesn't describe default summary function.
  2. Demo application source code is available for C++Builder 5.0.
  3. Help updated.

Bugs fixed:

  1. If delete a summary from the cube, it is not reflected correctly in the grid summary settings, so the grid raises an exception when it tries to get a cube cell for the non-existing summary.
  2. An exception occurs when the grid row area is empty (has no dimensions).
  3. When THierCubeChart.UseDimension = xhcColumns the chart raises an exception or doesn't display an information correctly.
  4. Sometimes THierCubeChart component doesn't rebuild itself on changing grid pivot state.
  5. On expanding dimension value for hierarchical dimension no sorting method applies.
  6. The method TSummaryStates.SumStateByFieldName raises an exception.
  7. In demo application an "access violation" exception is raised on generating a QuickReport report when the default network printer is not available.
  8. On add/remove calculated summary some grid parameters (drilling, pivoting states) are reset.
  9. If summary description in cube dimension map differs from summaries saved in cube data file then exception is raised.
  10. When THierCubeGrid.HierCube = nil design time summary settings editor raises "access violation" exception.

 

HierCube VCL 3.01 (17 September 2003):

New features:

  1. New property THierCubeGrid.VisualSettings. Contains all old and some new visual settings of the grid combined in one object property. The ability to change background color has been added. See help file for details.
  2. ATTENTION! When you open the project created with the HierCube library 3.00 the Delphi IDE will say that some properties don't exist. Just say "Ignore all".
  3. Visual improvement - now the captions of dimension members are split into many short strings so that the string can be fully displayed in the grid cell.
  4. Help updated.

Bugs fixed:

  1. In demo application on displaying "Grid explorer" occurs exception.
  2. When THierCubeGrid.HierCube property is nil and there is a THierCubeChart component on the form connected with the THierCubeGrid component a error appears. May occur in run time as well as in design time.
  3. When all cube dimensions are located in the page area an exception occurs.
  4. On a THierCubeGrid.OnDragOver event handler a "Invalid Type Cast" exception is raised when the mouse pointer is over row/column pivot panels.

 

HierCube VCL 3.00 (14 September 2003):

New features:

  1. Unlimited cube capacity and unlimited dimension count. Now you can have as many dimensions in your cube as you want.
  2. The custom (calculated) summaries. You can create summaries of yourself that are the functions of predefined summaries. See TSummaryInfo in help file for details.
  3. One-pass data fetching. Now all cube data are read from the dataset in one pass.
  4. The performance increased greatly. The calculating speed is now 5-10 times faster depending on cube size.
  5. A possibility to create several THierCubeGrid components for a single THierCube component. This may be used for more complex data analyze. Each grid may have different pivot states and drilling states and different calculated summaries.
  6. The cube data file format has been changed. Now it takes less memory and is processed much faster.
  7. The different display formats for each sub-function, function, and summary. They can be edited in design time using THierCubeGrid .SummarySettings property editor.

Bugs fixed:

  1. When I restore the cube from the disk file and then try to rebuild it again using initial dataset, my hierarchical dimensions are not initialized correctly, so that all parent values disappear in the grid.

 

HierCube VCL 2.22 (19 August 2003):

New features:

  1. Help updated.

Bugs fixed:

  1. If I take a dimension in the pivot panel with the mouse so that it becomes transparent and then drop it just at the old position, the dimension panel becomes "dead" so that it's impossible to move it any more.
  2. The evaluation version sometimes cannot determine correctly if there is a IDE running at the moment and raises the exception as if there were not IDE.

 

HierCube VCL 2.21 (14 August 2003):

New features:

  1. C++ Builder 5.0 support.
  2. New property THierCubeGrid.FormatNulls: Boolean. When True the grid formats and displays a cell value even if it's null. Set this property to True if you don't want to have empty cells in the grid.
  3. New property TQRHierGridBand.ReportMode. This property defines how the lines are carrying over in the QuickReport report. xrmAllRowsConsistently - Carrying is performed line by line, so the next line is not printed until the previous one is printed completely. xrmGridSimilar - All the lines are carrying over by single block of lines. See example on our demo.
  4. New property THierCubeChart.ControlSummaryFieldName: string. Using this property you can select what summary is shown in the diagram if HierCubeGrid component contains several summaries. The summary is identified by the summary field name.
  5. The Page and Column grid areas are now scrollable. Put there as many dimensions as you want - you can see them all.
  6. Help updated.

Bugs fixed:

  1. The grid crashes when it has no dimensions in the row/column area and the "column/row cumulative sum" sub-function is selected in the grid at the moment.
  2. Incorrect timer handler. In the THierCubeGrid the timer begins to tick even when the THierCube component associated with the grid isn't active yet. This is not a bug itself but sometime there is a derived exception because of this.
  3. When the grid is "empty" (for example, when all values are hidden for some dimension) the THierCubeChart component raises an exception on rebuilding.
  4. In design time on deleting THierCube component from the form the "dead" link remains in the related THierCubeGrid component. The same happens for the related THierCubeGrid and THierCubeChart components.

 

HierCube VCL 2.20 (4 August 2003):

New features:

  1. C++ Builder 6.0 support. The distributive package contains now files ready for C++ Builder compile and also demo application for C++ Builder.
  2. Cube changes history controlling. Now you can save the cube state that is displayed in the grid and then restore it any time you want. Cube states are stored in the saving stream so you can save all your cube and state information and use it after restoring.
  3. New options THierCube.Options.UseStatisticFunctions and THierCube.Options.UseSupersaturatedCubes define if additional cube features are allowed. Setting these properties to False increases the speed of data calculations and reduces the memory occupation. See help for details.
  4. The cube file format has been CHANGED! See below.
  5. The cube now writes all data to packed stream so the cube file size is ~10 times less than in 2.11 version. The restore speed is ~1.5 times slower, and the write speed is ~10 times slower because of the packed streams.
  6. Dimension Map Editor now shows different icons for dimensions located in Row, Column and Page areas.
  7. Help updated.

Bugs fixed:

  1. When demo application is recompiled using evaluation version, the error occurs "Data source is too large".
  2. After canceling cube initialization pressing the "Cancel" button in progress bar window, it is impossible to open the cube again.
  3. Incorrect drag&drop operation in the Dimension Map Editor.

 

HierCube VCL 2.11 (16 July 2003):

New features:

  1. New sub-function "Cumulative Sum By Row/Col" calculates the sum of all previous values from the area of adequate comparisons.
  2. Improved the method of modifying Cube Dimension Map in Run Time. Now you can add new dimension / summary or remove a dimension / summary in Run Time. This may be useful when working with the dynamically created datasets.
  3. New method THierCube.UndefineField allows to remove a dimension / summary from the Cube Dimension Map.
  4. Memory occupation reduced.
  5. Functions are calculated now little faster.
  6. Help updated.

Bugs fixed:

  1. When trying to drill a hierarchical dimension the exception "Internal Calculating Error" sometimes occurs.
  2. When holding a mouse over a grid when the cube is not active the exception sometimes is raised.

 

HierCube VCL 2.10 (11 July 2003):

New features:

  1. Non-integer key fields support. Now you can use string key fields for relation of fact table and dimension tables.
  2. Export to QuickReport report generator.
  3. Saving cube data to the disk file and further restoring. This feature allows to create applications for data analysis without database connection. Cube activation from disk file is much faster than from database.
  4. New method THierCube.SaveToFile(const FName: TFileName) saves cube data to disk file.
  5. New properties THierCube.ActivateFromFile: boolean and THierCube.FileName: TFileName. Set ActivateFromFile to True if you want the cube to be activated from disk file FileName instead of dataset.
  6. Help updated.

Bugs fixed:

  1. When decreasing the amount of active summaries in run time the grid incorrectly draws dimension member captions.
  2. The "Drilling window" doesn't open under Windows XP.

 

HierCube VCL 2.01 (25 June 2003):

New features:

  1. The functions are calculated faster.

Bugs fixed:

  1. The dimension sorting doesn't work in the grid row area.
  2. OnExportDataCell and OnExportLabelCell events are never occurred in the THierCubeGrid.
  3. The "Drilled values" window doesn't open in Windows XP.
  4. THierCubeChart component displays the graph for the first column/row instead of the column/row totals.
  5. The sub-functions "Percent by column" and "Percent by row" raise an exception when the row/column total is 0 (zero)

 

HierCube VCL 2.00 (20 June 2003):

New features:

  1. The maximum cube capacity has been significantly increased. Now the cube may contain about 1018cells.
  2. The process of calculating of subtotals before cube opening has been fully reduced so the version 2.0 is much faster. Now all subtotals are calculated just in time of data access and this is really very fast.
  3. Significantly increased the speed of calculating of parent values.
  4. Multi-drilling has been added. Now you can drill the cube by many dimension values. Open the cube and choose the dimension members you're interested in.
  5. Now the grid can display many summaries at the same time. This provides a unique opportunity to make a comparative analysis of the cube data. The summaries are related only with the common dimension. Their facts are different and independent.
  6. The different aggregate functions has been added. Now the cube can calculate such functions as Standard deviation, Skewness, Median and more. All the functions can be displayed at the same time and can differ for different summaries.
  7. Except aggregate functions the grid can calculate different sub-functions such as "Rank by column", "Percent by row", "Compare with previous row cell". Using sub-functions it is possible to compare function values. Sub-functions can differ for different functions.
  8. The page area has been added to the grid. Now you can move the dimension you're not interested in at the moment to the page area. Work only with the dimensions you need.
  9. New property ShowColorHint marks with the different colors the grid cells depending on their values. Just stop the mouse over a cell and leave it still for 2 seconds. Only cells from the "area of adequate comparisons" are colored.
  10. New feature: "hide all dimension members below" allows to hide insignificant data by only two mouse clicks and concentrate upon topical data analysis.
  11. Some visual improvements like "remembering" the dimension members that was expanded on pivot operations.
  12. The speed of export to MS Excel significantly increased.
  13. Help updated! Contains much information about HierCube library, describes units, classes, and methods. The HierCube tutorial has been included!

 

HierCube VCL 1.23 (28 April 2003):

New features:

  1. Significantly increased the speed of calculating of Parent Values for hierarchical dimensions. The algorithm of calculating fully changed. Now Parent Values are calculating for all hierarchical dimensions in the cube at the same time.
  2. Now all string constants used in the user interface are located in the separate xhResStr.pas file. This file is included into the install package of all types. So you can easily change your user interface language of the HierCube Library, just modifying this file. After changing you may need to rebuild you project to see strings in your own language.

Bugs fixed:

  1. When using string dimensions in the cube, the cube totals are calculated incorrectly, so the grid shows wrong subtotals.

 

HierCube VCL 1.22 (18 April 2003):

New features:

  1. New public method THierCubeGrid.SaveGridToHTMLStream to save the current grid state as HTML file.
  2. Now you can change the initial dimension order right in Dimension Map Editor at Design Time. Just drag and drop any field in the list to change its position.
  3. Now when changing main dataset fields (deleting or adding a new field) the DimensionMap property doesn't reset the cube parameters (is the field dimension or summary) for fields that don't change (the fields that keep name and type unchanged).

Bugs fixed:

  1. On drilling the dimension value the error was occurred, when there was an active THierCubeChart component on the form.

 

HierCube VCL 1.21 (15 April 2003):

New features:

  1. Significantly increased speed of calculating of subtotals.
  2. Now HierCube library supports "supersaturated" cubes where one cube cell corresponds to many rows in main table (facts table). Now you don't need to group your cube data, HierCube will do it for you!
  3. The demo database and application have been updated to show more fully HierCube libraray features (using calculated fields, building dimensions from DATE field, etc.).

Bugs fixed:

  1. The bug fixed when assigning the THierCubeGrid CaptionFont, LabelFont and DataFont properties doesn't take an effect (the font remains the same).
  2. The bug fixed when exporting to Excel workbook.
  3. Some other little bugs fixed.

 

HierCube VCL 1.20 (10 April 2003):

New features:

  1. Significantly raised cube performance and data fetching speed. The speed increased in all the steps of cube activating (data fetching, calculating parents' values, calculating subtotals). NowTHierCubecomponent becomes active in 100 times faster! (It's not a misprint).
  2. New visual componentTHierCubeCharthas been added to view currentTHierCubeGridstate as a diagram. It allows selecting diagram style, active axes, different color schemes and sort modes, etc.
  3. The opportunity of using calculated fields as dimensions.
  4. The opportunity of defining string field as a dimension. In that case you don't need to have a lookup-table with text descriptions.
  5. The drawing algorithm has been improved.
  6. A row of bugs fixed.

 

HierCube VCL 1.12 (24 March 2003):

New features:

  1. The THierCube.HCData property has been discarded. Now use THierCube.DataSet property instead. The first one is still in the package for backward compatibility but will no longer be supported in further versions. When setting this property a message will appear with notification about it. THCData component itself also will not be included in further library versions.
  2. New property THierCube.UseRecordCount allows preventing incorrect progress bar displaying when the database server doesn't support counting table records before all rows are fetched. In that case set UseRecordCount to False and there will be the number of fetched rows displaying instead of a progress bar.

Bugs fixed:

  1. Incorrect cube message handling when the form with THierCube is destroying.
  2. The bug when displaying the Events tab of THierCubeGrid in Object Inspector under Delphi 6 & 7.

 

HierCube VCL 1.11 (21 March 2003):

New features:

  1. New property THierCubeGrid.ShowPivotControlButton allows show/hide Button that controls whether PivotPanels are showed at the moment.
  2. New method THCData.First.
  3. Paint method improved.

Bugs fixed:

  1. When activating the cube for the second time exception had been raised because of the dataset cursor position hadn't been moved to the beginning.

 

HierCube VCL 1.10 (18 March 2003):

New features:

  1. THierCubeGrid is now a successor of TCustomControl component that gives unlimited possibilities for further modification.
  2. THierCubeGrid has built in Pivot to make cube manipulation easier. Make changes you want using integrated Pivot and then hide it to expand useful screen area.
  3. Visual interface is significantly improved.
  4. THierGrid now supports different visual styles like Flat and XP style.
  5. The internal mechanism of accessing to cube data has changed that makes data fetching faster.

Bugs fixed:

  1. The grid labels are no longer truncated by grid column boundary when they don't need to be truncated. It used to be because of the limitation of TCustomGrid component.
  2. There could be a situation in the grid when a row of "Total" labels was displaying on the screen instead of single "Total" label.

 
Support | Download | Purchase | Partners | Upgrade and Discount Policy | Contacts © 2005-2010 Radar-Soft, L.L.C. All rights reserved.