Adding Attributes and Facts to a Dataset in CloudConnect Modeler

Now, you need to add field data to your dataset. In logical data models, fields in a dataset are broken down into two basic types: Facts and Attributes.

  • Facts: Numerical data that is to be used in computed functions in your reporting.
  • Attributes: Data that is to be used in grouping the values resulting from the computed functions. In almost all use cases, this data is non-numerical. Attributes are grouping or segmenting data.

For a review of these terms, see Logical Data Model Components in GoodData.

Steps:

  1. Select the Payments dataset.

  2. Double-click the rectangle, or click the Down Arrow icon in the rectangle. Then, click Edit. The Attributes and Facts window is displayed.  

      There are currently no attributes or facts in this dataset. In the original dataset, the fields are identified as either attributes or facts in the following table:

    Field Name

    LDM Data Type

    Employee ID

    Attribute

    Name

    Label of Employee ID Attribute (explained later)

    Pay Stub ID

    Attribute

    Pay Date

    (ignore this field for the moment)

    Payment

    Fact

    Department ID

    Attribute

    Department

    Label of Department ID Attribute (explained later)

     For purposes of this tutorial, we will add all of these fields to the Payments dataset and then break them out into separate datasets to define the hierarchical relationships.

  3. Add the fields from the table to the dataset:

    • To add an attribute, click the Add Attribute () icon.

    • To add a fact, click the Add Fact (Plus icon) icon.

  4. For the Title value, enter the value as listed in the table.

  5. For the Folder value, leave the default.

  6. To add a label, click the Plus () icon. Select Add Label For > field_name . Add labels for Employee ID and Department ID.

  7. To delete a field, secondary-click the field. Then, select Delete.

  8. When finished, click OK. The finished Payments dataset should look like the following: 

    Payments dataset with specified attributes and facts

     You may notice that the label fields (Name and Department) are not displayed.

  9. From the menu, select File > Save. The Publish Model to Server dialog appears.

  10. Click Do not publish for now as you don’t want to publish the model to the server at this moment.  The data model is saved.