Working with Dictionaries

1 From the OpenInsight 10 IDE select View, Tool Panels, Database.

Select the table you want from within your MultiValue volume. Right click on the table and choose Open In TableDesigner.

Once a table is selected, the converted dictionaries will be displayed in the TableDesigner. The dictionary details are maintained in the Table Properties panel on the right.

Change the Length property for the MODIFIEDDATE dictionary to 16 from the Property Panel on the right:

Below are the converted dictionaries of the SALES_SALESTERRITORY table. Create a Symbolic Type dictionary called NETSALESYTD.

NETSALESYTD is a calculated column in the SALES_SALESTERRITORY table. From the Table Properties panel, scroll to Symbolic Type and open up the Formula editor. This does not affect the dictionary on the SQL server. The Check Syntax button will compile the dictionary.

Note: @ANS is a system variable used to store the value of a calculated column.