Create a standard data dictionary

When you select Standard as your data dictionary type, the Data structure tab is made available. You use the Data structure tab to specify details about your data set, including which tables to use and how they are related.

Getting started with your data dictionary

  1. Click the Data structure tab and then click the Wizard button wizard icon graph with yellow plus sign.
  2. The Choose a table window displays.


  3. standard data structure table screen
  4. Depending on the database type associated with the selected World, Sentinel displays only the Schema drop down list or both the Catalog and Schema drop down lists. Depending on the database and whether the world you specified is restricted to a single catalog and schema, there can be more than one value available in each drop down.
  5. Choose a Table type: LOCAL TEMPORARY, TABLE or VIEW. The types of tables available depend on the JDBC driver and the type of database accessed.
  6. Choose a table from the drop down and then click OK.
  7. Specify the level of Depth of your star model.
  8. Choose an option from the Import fields list. You could specify to import All the fields, All but keys or None.
  9. Click OK. The data dictionary is created.


    standard data dictionary

When the first table is added to the data structure, the PDF Export button is displayed. Select this button to export a PDF of the graphical representation of the data set you just defined.

Note   To internationalize, click the Internationalization tab and enter the necessary information.

Modify Table details

When you click a table header, a pop-up menu becomes available.

Option Description
Modify The description of the table and configure its columns. See Modify the table configuration .
Delete Removes the selected table and any child tables from the data structure (but not from the database)
Wizard Allows you to make modifications to your data structure (for example, modify the Depth parameter)
Add a table Opens the Choose a table pop-up and allows you to add more tables to the star model. When you add a table the Join edit (link to Modify Links between tables) pop-up is displayed. You can manually define a relationship between two tables without the relationship being represented by integrity constraints.
Add context field Allows you to set a filter depending on personalized fields. See Add Context fields.

Modify the table configuration

When you select the Modify option in the pop-up menu the Table edit pop-up is available. The list of fields displayed is provided by the JDBC driver.

Field Description
Catalog All data managed by same execution engine.
Name The name of the table in the database.
Description A custom name of the table displayed across the GUI. You can set different values for this parameter depending on the user's language via the Internationalization tab.
SQL field Includes or excludes each field from your data structure.
Field name Used to customize the name associated with different table columns. Field names of the same data dictionary must be unique. These names are used by certain objects (for example, reports, dynamic links and tasks) to refer the table columns. It is recommended not to change the name once the column has been referred by another object
Description A custom name of the field name which will be displayed across the GUI. You can set different values for this parameter depending on the user's language using the Internationalization tab.
Field group Select the field group associated with the table column. See Modify field details.

You can access advanced settings in the More details section:

Field Description
Updatable Allows updating the table.
Insertable Allows inserting new entry in the table.
Deletable Allows deleting from the table.
Data type The data type of the field.
Size The size in bytes of the data type.
Scale The number of digits to the right of the decimal point in a number.
Nullable Allows the field to be set to the value NULL.
Insertable The field can be inserted in a table.
Updatable The field options can be updated.
Auto-increment Automatically creates the value of the primary key field every time a new record is inserted.

Add Context fields

Each row in this screen describes a Contextualization, which will be reflected at the Report level:

Field Description
Field name The first list contains all the fields in the table.
Operator The second list contains the most frequently used operators (<, <=, =, >= and >).
Personalized Field This list contains any defined personalized fields.
Add icon green plus sign Adds a new contextualization.
Delete Deletes the contextualization.

Modify field details

Left-click a field in a table to make a pop-up menu available. The options on this menu allow the modification of a specific column in the table.

Option Description
SQL field The name of the column in the database.
Field name The name of the column to be used on the SQL queries.
Description The name of the field to be displayed in the GUI.

Optionally, click More details to access advanced setting of fields properties:

Option Description
Field group The field group with which the column is associated.
Data type The data type of the filed.
Size The size in bytes of the data type.
Scale The number of digits to the right of the decimal point in a number.
Nullable Allows the file to be set to the value NULL.
Insertable The field can be inserted in a table.
Updateble The field options can be updated.
Auto-increment Automatically creates the value of the primary key field every time a new record is inserted.

Left-click a link between two tables to make a pop-up menu available.

  • Delete removes the child table from the star model, along with any child tables that it may need to remove.
  • Modify opens the Join edit pop-up, which contains the following options:
Option Description
Join name The join name is not mandatory. If it is not specified manually, it will be generated automatically when the dictionary is saved.
Join type

The join type can be:

  • INNER Join
  • LEFT Join
  • RIGHT Join
  • FULL Join

You must then select which field(s) in the two tables allow the join to be made.

Add icon green plus sign Select to add a new element to the join.
Delete icon red x Select to deletes the element from the join.

Contextualization

The Add contect field screen for contextualization

Each row describes a contextualization.

  1. The Field name list displays the fields in the table affected by the contextualization.
  2. The Operator list contains the most frequently-used operators (<, <=, =, >= and >) and allows you to compare table fields to
  3. The final list contains any personalized fields that have been defined.
  4. Click the Add button icon green plus sign to add a new contextualization or click the Delete button icon red x to delete the contextualization.

Modify the join

The join name is not mandatory. If it is not specified manually, it will be generated automatically when the dictionary is saved.

Screen indicates the Join Name and Join Type screen

The join type can be:

  • INNER Join
  • LEFT Join
  • RIGHT Join
  • FULL Join

You must then select which field(s) in the two tables allow the join to be made.

Click the Add button icon green plus sign to add a new element to the join..

Click the Delete button icon red x to delete the element from the join.

Related Links