zCube 3.05beta
-------------------------------

ZCube - simple and lite in-proc ActiveX library for creating OLAP application via BDE datasources. Also you can use it for creating cross-tab reports :)

Version 3.0 contains fully rewrited code from 2.x versions.

Limitations:

dimension max count -  32767 items (up to 65534, but date dimensions rstricted to 32767)
measure max count - 16 items (it's can be easy changed - just say me. which limit you need - I do not want use memory allocation routines for each cell, so measures now now is simple array.

Cell count - max memory you can address for program. It's may be some less than 4 Gb. :)
You can calculate you memory requirements by formula
Allocated size = (3*(2**N) div 2)+1) * RecordCount * CellSize
where
CellSize = (N*2 + M*4)+8
N - number of dimensions
M - number of measures

This is average value.Really you will earn less memory than these calculations. But if you data contains only unique dimension combinations, you memory requirements will be very high.

It's strongly recommemnded do not use virutal memory for creating cube - speed will down. :)

New in 3.05
1. Some errors are removed
2. Cube loading example added. You must create environment variable "ZCUBEDATA" which will point to directory where you want to store/load you builded cubes
3. Memory requirements lower
4. Work with SQL expressions changed, now it will automatically create DBF table named 'zExplorerTempData.dbf' where all SQL output will stored before you create structure description and also before quick loading

New in version 3.0
1. Very improved preformance
2. Date dimensions now supports options 'wrap to' - Year,Month,Week,Day. If you do not want to use this ability, set WrapType = 0, when CUbe.AddDimension method called
3. New demo program - now this is zCubeExplorer,something like Seagate Analysis :)
4. load monitoring - see demo for details
5. Save/load cubes. Set environment variable 'zCubeData' to directory where you want store you cubes
6. Support snowflake dimensions structure - set MasterTable parameter to tabel, which contains keys.

Installation
Just register zCube.dll - use something like 'regsvr32 zCube.dll'
For using instructions - see demo source.

Demo
Before run, you must create in BDE alias - 'cubedemo', which points to location 'cubedemo.dbf'

Demo limitations
You could not save or load builded cubes, only rebuild on each use.

Registering
This is fully functional version, without any limitations like time or size limits.
If you will register, you will have new dll, which will send to you by email, which will
allow
1. Save and load cubes to disk files(load time costs 508 times less)
2. You will get all new updates
3. Any help with using this program which I can did over email
4. You can said me, if you will need some special abilities, may be it will done :) - depend of time costs for these requirements

You can register via
http://www.regsoft.net/purchase_nonsecure.php3?productid=49669

Author
Alexander Zencovich (zencovich@mail.ru)


