This example generates a new weighted 3-dimensional table called Products.ivt from the ASCII source
data file Products.txt, whose fields are defined in the source definition file Products.ivs. The update
definition file Products.ivu is used to build the table.

Dimensions

The dimensions of the new table are as follows:

Cookie Type

Defined in the dimension definition file Cookie.ivn.

Region

Defined in the dimension definition file Region.ivn. Has an associated map file, NAmerica.ivd.

Time

A monthly timeseries dimension.

Unit1

A weight field.
The table's title, category, author, and notes are all included in the update definition file Products.ivu.

  • The COOKIE TYPE and REGION dimensions have French and English descriptive elements and
    default labels assigned for each language.
  • The table is initialized to missing values before any data is included. Missing values are
    represented by 9999 in the source file.
  • Since there are groups in the REGION and COOKIE TYPE dimensions, a calculation is performed
    after the table is created.     

Source Files

This example requires the following source files, which are provided in the folder \Documentation\Sample
Data\Integrator's Builder\Example1. You can also access the sample files from the Start Menu for
Integrator's Builder. Click on Sample Data to locate the sample files.

  • To run the example, first copy the files into the folder where the Integrator's Builder executable
    (Bldint.exe) is located.
  • For more information about the format of the source files, refer to File Formats in the Reference
    section of the Visual Builder User Guide. The user guide is provided as a PDF file in the
    \Documentation folder of Publisher's Edition. You can also access the User Guide from the Start
    Menu for Visual Builder.

Products.csv

 A CSV source file. This is a sample of the kind of data that is contained in the file:
 Shown in Excel:

Shown in Notepad:

TIME,COOKIETYPE,REGION,UNIT1,UNIT2,UNIT3
Jan1991,4,5,221,2208,179
Jan1991,1,1,3,28,2
Oct1992,4,8,395,4002,326
Jan1991,1,2,7,69,5


Products.ivs

The source definition file that describes the format of the source file. This is the complete contents of
Products.ivs: 


[Definition]
Filter=IVCSV.DLL
Version=3


[Field Definitions]
TIME=,,,mmmyyyy,Dated,,,Monthly,,,
COOKIETYPE=,,,,,COOKIE.IVN,,,,,
REGION=,,,,,REGION.IVN,,,,,
UNIT1=,,,,Numeric,,,,,,9999
UNIT2=,,,,Numeric,,,,,,9999
UNIT3=,,,,Numeric,,,,,,9999


Products.ivu

The update definition file that calls all the other required files. This is a shortened version of the contents
of Products.ivu: 

[Definition]
Version=3


[Input]
Definition=PRODUCTS.IVS
FilePath=Products.csv
CharSet=ANSI
DecimalTreatment=StandardRegional


[Rules]
Dim1=COOKIETYPE
Dim2=REGION
Dim3=TIME
Weight=UNIT1
Dates=Jan1991-Mar1994
Initialize=Missing


[Output]
Name=Products.ivt
Dim1=COOKIE TYPE,COOKIE.IVN
Dim2=REGION,REGION.IVN
Dim3=TIME,TIME,Add,Timeseries,Monthly
Description=Revenues, Expend., and Units Sold by Region, Cookie & Month
Author=Ivation
Category=Example files
IfFileExists=Update
IfDataExists=Add
Language1=eng
Language2=fra
Calculate=True
MapFile=NAMERICA.IVD,REGION,Map Code
Decimals=0


[Output-fra]
Dim3=TIME,TIME


[Notes]
CharSet=ANSI
Notes=eng
;This table is one of two demonstration tables IVATION Datasystems Inc. has in+
;cluded with the Beyond 20/20 Browser software. This table PRODUCTS, and the o+
;ther table PEOPLE, both belong to the "Beyond 20/20 Demonstration Tables and +
;Extract" category. They contain fabricated information about an imaginary coo+
;kie manufacturing company.
;

Cookie.ivn
Region.ivn

ASCII dimension definition files that describe the table's dimensions. This is the contents of Region.ivn: 

[Options]
CharSet=ANSI
NewCodes=Add
Type=Geographic


[Options-eng]
Name=REGION
Label=REGION
DefaultLabel=English Desc
Author=Ivation
Title=REGION
Category=Beyond 20/20 Demonstration Tables and Extract


[Options-fra]
Name=RÉGION
Label=RÉGION
DefaultLabel=Desc Français
Author=Ivation


[ExtraFields]
Field1=English Desc,Label,,131,eng
Field2=Map Code,Label,,133,eng
Field3=Desc Français,Label,,178,fra


[Series]
NAMERICA,North America,Total,Amérique du Nord
CANADA,Canada,CANADA,Canada
1,Maritimes,MARITIME,Maritimes
2,Quebec,QUEBEC,Québec
3,Ontario,ONTARIO,Ontario
4,Western Canada,W_CAN,Ouest du Canada
US,United States,US,États-Unis
5,Western US,W_US,Ouest des États-Unis
6,Central US,C_US,Centre des États-Unis
7,Northeast US,NE_US,Nord-Est des États-Unis
8,Southeast US,SE_US,Sud-Est des États-Unis
MEXICO,Mexico,MEXICO,Mexique
9,North Mexico,N_MEXICO,Nord du Mexique
10,Central Mexico,C_MEXICO,Centre du Mexique
11,South Mexico,S_MEXICO,Sud du Mexique


[Groups]
NAMERICA=CANADA+US+MEXICO
CANADA=1+2+3+4
US=5+6+7+8
MEXICO=9+10+11


[Notes]
DimensionNotes=REGION,eng
;The "Region" dimension has a total of 15 items grouped into three levels. The+
; "North America" item is on the highest level.
;
;The three items "Canada", "United States", and "Mexico" are on the next (lowe+
;r) level. The "Canada" item is broken down further into four regions, the "Un+
;ited States" item comprises another four regions, and the "Mexico" item conta+
;ins three regions.
;
;You can view this data in a table, chart, or map view. The other dimensions i+
;n this table are "Cookie Type", "Units" (Revenues,Expenses, and Units Sold), +
;and "Month."


NAmerica.ivd

A map file. IVDs are binary files that cannot be represented in text 

Running the command

To build the table Products.ivt, enter the following command at a command prompt:

Bldint Products.ivu -i 104 -o 500 -v 

The elements of the command are as follows:

Bldint

Required. The name of the Integrator's Builder executable.

-i 104

Optional. Specifies an input buffer of 104 KB.

-o 500

Optional. Specifies an output buffer of 500 KB.

-v

Optional. Runs the build in verbose mode.

Products.ivu

Required. The Update Definition File (IVU) that controls the build.