(Showing Draft Content)

Add An Entity

An entity represents a data table that holds information within the data model. In a Cached Model, you can easily add an entity through the Get Data button and further create a custom entity using an SQL expression. For more information on data extraction, see the Create Cached Model article.

To Reconfigure Entity

There are high chances of missing columns or specifying an incorrect table definition when adding entities using SQL expressions. To resolve this issue, you can reconfigure the entity to modify its bound data source, existing table definition, or predefined alias. The process to reconfigure an entity is similar to the get data process of the cached model, used for extracting data from multiple data sources.

Note: You can reconfigure only one entity at a time.

  1. In the data model designer, select an entity you want to modify.

  2. Click the Ellipses icon and select the Reconfigure Entity option.

    Reconfigure an Entity

  3. In the Reconfigure window that appears, choose the data source for the selected entity, or keep the original data source, and click the Next button.

    Select Data Source

  4. Select the table you want to reconfigure or add a custom table using an SQL expression. In the case of the original data source, the chosen table is already selected by default.

    Note: You can select only one table at a time.

    Select and Edit Tables

    Here, you can modify the table in the following ways -

    • Add or change the table alias by entering the name under the Alias header.

      Modify the Table Alias

    • Replace the chosen entity with another table, by selecting any other table from the list. For example, over here the Categories table would be replaced by Territories.

      Replace entity

    • Change the custom table definition by entering a valid SQL query using the Edit button.

      Edit Table by SQL expression

      You can also change the table name using the Alias field.

      The originally selected table gets replaced by the newly created custom table.

      Edit Table by SQL expression

    Note: In the case of unsupported column data types, an error message is displayed while selecting and editing the table.

  5. Click the Next button to proceed further.

  6. Select the table column you want to reconfigure. By default, all the columns in the table are selected. You can uncheck the checkbox next to the Column Name header to discard the default selection of columns.

    Following are the different ways to modify a table column -

    • Change the column data type using the Type dropdown.

      Select and Edit Columns

    • Add or modify the existing column name by entering the name under the Alias header.

      Select and Edit Columns

    • Add a new custom column using a valid SQL expression.

      Select and Edit Columns

    • Change the custom column definition by entering a valid SQL query using the Edit button. You can also change the column name using the Alias field.

      Edit the custom column

    Note: You cannot add or remove a column from a custom table.

  7. Click the Next button to proceed further.

    The data for the table starts loading, you can see the loading progress for the table under the Progress header.

    Loading Progress for the table

    Once the data loading is complete, you will see the load status for the table under the Status header, and the number of rows loaded in that table under the Total Number of Rows header.

    Loading Progress for the table

    Note: The relationships that are no longer valid after successfully reconfiguring an entity are removed from the model.

To Delete Entity

Follow the below steps to delete an entity from a cached model.

  1. Select the entity you want to delete.

  2. Click the Delete button next to the selected entity.

    Delete Entity

  3. In the Delete Entity dialog box that appears, click Yes to confirm. Note that all the relationships referring to the chosen table are removed as well.

    Delete Entity Dialog Box

Important Properties

The following table describes the important properties of an entity that you can set in the Data Model Designer.

Property Name



The name of the entity.


The database object that the entity represents.

Is Hidden

Indicates whether the entity is hidden from end-users.

Security Filter

Allows you to use custom security providers to filter the data displayed for the entity.

Incremental Attribute

An attribute based on which you can incrementally update the data in the entity. This property is not applicable to a custom entity.