Table of contents

• What is PivotCube?
  • Limitations
  • Products supplied by the PivotCube family
  • Differences between packages
    
    
• Working with multidimensional cube
  • Building a new cube
    
    
• Slice, roll and drill
  • Building the slices
  • Rolling (dicing) a slice
  • Drilling a slice

• Using PivotCube components, which provide data representation for end-users
  • TPivotMap
  • PivotCube toolbars
  • Dimension toolbars
  • Measure toolbar
  • TPivotGrid
    
    
• TPivotChart
  • Use TPivotChart to display non-top level dimension values
    
    
• Printing and exporting
  • HTML
  • Microsoft Excel
  • TStringGrid
  • Printing
  • Third-party components support
    • XLSReadWriteII
    • SMExport
      
      
• Multi-language support

1. What is PivotCube?

PivotCube is a set of VCL and ActiveX components for multidimensional data analysis in desktop applications

1.1 Limitations

PivotCube components has following functional limitations:

Max number of dimensions	255
Max number of measures	1024
Max number of records for loading	up to 10,000,000
Max number of elements in 1 dimension	65,533 including nodes for hierarchical dimensions
Max number of hierarchical levels in hierarchical dimension	255
Max number of virtual cube cells	no limitation
Max number of real cube cells	up to 10,000,000

For PivotCube VCL

Max number of slices of one cube	dependent upon RAM size
Max number of Grids and Charts by single map	dependent upon RAM size

For PivotCubeX

Max number of slices of one cube	1
Max number of Grids and Charts by single map	1

 

1.2 Products supplied by PivotCube family

There are 2 basic products from the PivotCube family that are supplied by PivotWare Lab.

PivotCube VCL is a set of visual components for use in the Delphi and C++Builder family of products. The following versions of these development tools are supported:

• Delphi 5
• Delphi 6
• Delphi 7
• C++ Builder 6

All PivotCube VCL packages are royalty free.  See the License Agreement for details.

PivotCubeX is an ActiveX control for using in programming environments of development that support ActiveX technology (Delphi, Visual Basic, PowerBuilder, MS Access etc) or for use as embedded objects for web and IntraWeb applications in HTML pages.

1.3 Differences between packages

PivotCube family of products are supplied in the following packages:

PivotCube VCL

Standard package without sources

• Includes a set of .dcu files for Delphi 5,6,7 and a set of .obj and .hpp files for C++ Builder.
• Kernel that realizes basic OLAP functions is taken out in separate OLE server (zCube.dll). This package is also available as a trial and can be downloaded from the PivotWare Lab site.
• Trial version limitations:
  - Cubes cannot be saved to a file or stream.
  - Random pop up of nag-screen window on purchasing a valid license.
• Freeware limitations
  - Can only process fact tables containing 5000 records or less

This package includes source code of demo in Delphi, test database, copy of saved cube built on this demo database and example of file providing multilingual support.

Standard package with sources

• Includes source code of PivotCube VCL components in ‘Object Pascal’ language. Kernel that realizes basic OLAP functions is taken out in separate OLE server (zCube.dll).

non-DLL package without VCL sources

• Includes a set of .dcu files for Delphi 5,6,7 and a set of .obj and .hpp files for C++ Builder.
• Kernel that realizes basic OLAP functions is supplied as .dcu/.obj files

non-DLL package with VCL sources

• Includes source code of PivotCube VCL components of  in ‘Object Pascal’ language. Kernel that realizes basic OLAP functions is supplied as .dcu/.obj files.

PivotCubeX

Standard package includes

• ActiveX control
• Licensing file for work in trial mode
• MS Access demo database
• Example of using ActiveX control in MS Access environment
• Example of using the component in html

Standard package with sources includes

• PivotCubeX standard package
• Includes source code ActiveX component and PivotCube VCL nonDLL edition package with VCL sources