Create a Logical Model

Logical models can only be created for relation database data sources. (See JDBC or Connect to a Specific Data Source for information on how to configure a relational database data source.)

If you see the ‘Create Visualization’ dialog box, press the ‘Close’ button close and then proceed with the steps below.

200

To create a logical model, you must first define a physical view. See Create a Physical View. Then follow the steps below:

  1. Press the top ‘Data’ button database.

    dataModel1

  2. In the ‘Navigation Tree’ in the left panel, expand the ‘Data Sources’ folder and the data source to which you want to add a data model. Select the ‘Data Model’ node, and press the ‘New Logical Model’ button new logical model.

    dataModel35

  3. Provide a name for the logical model and press OK.

    dataModel36

  4. Press the ‘Add Element’ button add, and select ‘Add Entity’.

    dataModel37

  5. Provide a name for the new entity and press Next.

    dataModel38

    An entity name can contain any characters. However, the following characters and character combinations have been observed to cause problems on certain databases in particular usages. If you use these characters in an entity name, thorough testing with your database is recommended.

    ! ? [ ] < > ^ ` \ ' = " {D {d {T {t ( : $()

  6. In the ‘Add Attributes’ dialog box, select the fields (columns) that should be used as attributes for the entity. Press OK.

    dataModel39

    This adds the logical model entity and its attributes to the left panel.

    dataModel40

    An attribute name can contain any characters except a period (“.”). However, the following characters and character combinations have been observed to cause problems on certain databases in particular usages. If you use these characters in an attribute name, thorough testing with your database is recommended.

    ! [ ] ? { & } : ^ ` \ ' " = / < > $()

  7. Optional: To add additional attributes to an entity, follow the steps below:

    1. Press the ‘Add Element’ button add, and select ‘Add Attribute’.

      dataModel41

    2. In the ‘Add Attributes’ dialog box, select the entity to which you want to add attributes, and then choose the attributes to add. Press OK.

      dataModel42

  8. Optional: To add an expression or formula attribute to an entity, follow the steps below:

    1. Press the ‘Add Element’ button add, and select ‘Add Expression’.

      dataModel43

    2. In the ‘Add Expression’ dialog box, select the entity to which you want to add an expression, and provide a name for the new expression field. Enter the expression using SQL syntax. (You can select data fields and operators from the provided lists.) Then press OK.

      dataModel44

  9. To edit the properties of an attribute, expand the entity in the left panel that contains the attribute, and click to select the attribute. Make the desired settings in the right panel. (See Modify Attribute Properties in Edit a Logical Model for more information.) Then press the ‘Save’ button save.

    dataModel45

  10. Repeat the above steps to add additional entities and attributes.

  11. Press the ‘Save’ button save to save the logical model.