Knowledge Handling: Creating and Using Design Tables

You can create and use design tables for Dymola behaviors.

In this scenario, you create a design table in Excel format from the present model parameters exposed to Knowledgeware. You also take care of a problem of conflicting relations.

Important: The scenario below is just an example of one type of design table. For full information about design tables and how to create, edit, and use them, see Knowledge Basics Users Guide: Managing Relations: Design Tables.
Note: In this scenario, you create a design table for a Dymola behavior in a logical component. It is possible to do the same for a function.

Before you begin: To create a Dymola behavior with parameters exposed to knowledge to be used in the scenario:
  • Create a logical component with a Dymola behavior and open it to edit it. See Create a Logical Component with a Behavior.
  • In the MainModel, use the Parameter and Variable Editor to create three Boolean parameters; p1, p2 and p3. For creating parameters, see Dymola Behavior Modeling Users Guide: Defining Parameters and Variables: Parameters Edition: Defining Parameters and Editing Properties of Parameters.
    Note: A behavior with only three top-level parameters and nothing else is not realistic, but sufficient for this scenario.
  • Expose the parameters p2 and p3 to Knowledgeware parameters according to Dymola Behavior Modeling Users Guide: Defining Parameters and Variables: Parameters Edition: Working with Knowledgeware Parameters: Exposing Modelica Parameters as Knowledgeware Parameters.
  • To exit the Dymola Behavior Modeling app, from the action bar, click Exit App .
  1. In the tree, double-click the Dymola Behavior node.

    Important: You must work with the Dymola behavior, not with the logical reference.

    You enter the Dymola Behavior Modeling app
  2. From the Tools section of the action bar, click Design Table .
  3. Optional: In the Creation of a Design Table dialog box, change the name and comment for the design table.
  4. Activate Create a design table with current parameter values and click OK.
  5. In the Select parameters to insert dialog box, use the arrow key to select what parameters to include in the design table and then click OK.

    For this scenario, include all parameters, that is, p2 and p3, and also the formula activity one.

    Note: p1 is not available in the list since it is not exposed to knowledge.

  6. In the File extension dialog box, do any of the following:
    • Click Yes if you want to create the design table as an Excel sheet.
    • Click No if you want to create the design table as a text file.

    In this scenario, click Yes.

  7. In the Engineering Document dialog box that appears, click OK.
    The following is the result:
    • An Engineering Document is defined.
    • In this scenario, a conflict is found between the intended design table and existing relations. This is because the formula and the design table both are intended to control the parameter p3.
  8. In the dialog box displaying the conflict, you can select any of the following:
    • Yes to remove conflicting associations.

      In this case, parameters p3 and the related formula activity are not included in the design table. Both formula and design table are active.

    • No to deactivate conflicting relations.

      In this case, the parameters p3 and the related formula activity are included in the design table, but the present stand-alone formula is deactivated.

    • Cancel to deactivate the design table.

      In this case, the present stand-alone formula is still active, but the design table is deactivated.

    In this scenario, click Yes.

  9. In the design table dialog box, click OK to validate the selections and create the design table.

    In the tree, under the Dymola behavior, under the Relations.1 node, the design table is displayed with an icon. An example is a design table created as an Excel file: .

    Under the design table, the configuration and the sheet are displayed as icons. An example of an icon for a sheet is the icon for an Excel sheet: .

    Deactivation is indicated by a small bracket icon in the lower-left corner of the icon.