#3 Performance Cubes Full Rebuild

[Frank van de Ven]

Web Financials has a Cube system, which can be used
for SQL Analyses and/or other Analyzing tools.
The ETL-program mmcubes.exe builds a fact table based
on selections of years, amount classes and entities you
made by the admin-configuration of the datawarehouse.
The number of records of the fact-table can become
huge (> 1.000.000 records).

This enhancement-request handles about:
- building only records for amounts <> 0
- adding indexes to the table after inserting the records

The structure of the table will not be changed.

By only creating records for amounts <> 0 for a giving
accounting period we save a lot of records without
losing information.

In a full rebuild-situation the fact-table is recreated and
then populated.
By adding indexes after populating we save time when
we are inserting the records.

[Frank van de Ven]

Logged In: YES
user_id=1133657

Installation instructions:

1. Unzip 1094883.zip to a working-directory

2. Copy multimart\mmcubes.exe to c:\program files\multimart
and overwrite the existing mmcubes.exe
(don't rename the old one to prevent problems with the
registry of the exe).

3. Double click on mmcubes.exe to register the new exe.

4. The source code on \sourcecode\etl is delivered for your
convenience.
The source code is also available in the cvs-system of
sourceforge.net

End of instructions

[Frank van de Ven]

Patch Cube-Performance