- Getting Started
- Administration Guide
- An Introduction to Wyn Enterprise
- Document Portal for End Users
Data Governance and Modeling
- Data Binding Concepts
- Introduction to Data Sources
- Introduction to Data Model
- Introduction to Direct Query Model
- Introduction to Cached Model
- Introduction to Datasets
- How To
- Secure Data Management
- Working with Resources
- Working with Reports
- Working with Dashboards
- View and Manage Documents
- Understanding Wyn Analytical Expressions
- Section 508 Compliance
- Subscribe to RSS Feed for Wyn Builds Site
- Developer Guide
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.
In the data model designer, select an entity you want to modify.
Click the Ellipses icon and select the Reconfigure Entity option.
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 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.
Here, you can modify the table in the following ways -
Add or change the table alias by entering the name under the Alias header.
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.
Change the custom table definition by entering a valid SQL query using the Edit button.
You can also change the table name using the Alias field.
The originally selected table gets replaced by the newly created custom table.
Note: In the case of unsupported column data types, an error message is displayed while selecting and editing the table.
Click the Next button to proceed further.
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.
Add or modify the existing column name by entering the name under the Alias header.
Add a new custom column using a valid SQL expression.
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.
Note: You cannot add or remove a column from a custom table.
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.
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.
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.
Select the entity you want to delete.
Click the Delete button next to the selected entity.
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.
The following table describes the important properties of an entity that you can set in the Data Model Designer.
The name of the entity.
The database object that the entity represents.
Indicates whether the entity is hidden from end-users.
Allows you to use custom security providers to filter the data displayed for the entity.
An attribute based on which you can incrementally update the data in the entity. This property is not applicable to a custom entity.