Derived Entity

Entity refers to a table in which data is stored. Derived Entity within the Infrastructure system facilitates you to define entities which are populated through a series of data transformation processes resulting from an existing Data Set or a Data Source. A Derived Entity can be used to define other Business Metadata such as measures, hierarchies, dimensions, data sets, and cubes.

The Derived Entity Summary window displays the list of pre-defined Derived Entities with their Code, Short Description, Long Description, Creation Date, Source Type, and Materialize View status. You can add, view, edit, copy, and delete a Derived Entity. You can search for a specific Derived Entity based on Code, Short Description, Source Type, and Authorization status. By clicking the Column header names, you can sort the column names in ascending or descending order. Click if you want to retain your user preferences so that when you login next time, the column names will be sorted in the same way. To reset the user preferences click  .

Based on the role that you are mapped to, you can access, read, modify or authorize Derived Entity. For all the roles and descriptions, refer to Appendix A. The roles mapped to Derived Entity are Derived Entity Access, Derived Entity Advanced, Derived Entity Authorize, Derived Entity Phantom, Derived Entity Read Only, and Derived Entity Write.

• Create Derived Entity

• Copy Derived Entity

• View Derived Entity Properties

• Modify Derived Entity

• Delete Derived Entity

Creating Derived Entity

This feature allows you to create a Derived Entity based on a Data Set, an Entity or a union of Derived Entities. For Union and Union All options, the metadata used in the participating derived entities determines the columns of the physicalized materialized view. For Union based Derived Entity, even if the participating derived entities have metadata in common, the resultant materialized view in database will ensure unique columns. The same is explained in a tabular format:

In case of Union All based definition, the resultant materialized view in database may have repetition of data based on data present in the participating derived entities.  

Note: To define a Derived Entity based on an Entity in a Data Source, you should have defined permissions for the particular Data Source in the Atomic schema.

To create a Derived Entity:

1. Click Add from the Derived Entity toolbar. The Derived Entity Details window is displayed.

2. Enter the details as tabulated.

On selecting the Data Set Name or Source Application Name, the respective fields are displayed in the Metadata for Source Type list.

3. Double-click Metadata for Source Type. The list of Metadata defined on the selected Data Set or Application and Source is displayed.

• For Source Type selected as Dataset, the Metadata for Source Type displays all Hierarchies and Measures defined on the Entities that are part of the selected Dataset, and Business processors defined on the selected Datasets.

• For Source Type selected as Entity, it displays all Entities in the selected DI Source.

• For Source Type selected as Union or Union All, it displays all Derived Entities created with Source Type as Dataset.  You can select maximum of 15 Derived Entities.

4. Click to expand the folders. Select the required metadata and click button. Click to select all metadata. You can select a metadata and click  to remove that metadata or click  to remove all selected metadata.

5. Click Save. A confirmation dialog is displayed.

The details are displayed in the Derived Entity Summary screen.

Back to Top

Copying Derived Entity

You can copy the pre-defined Derived Entity details to create another entity. You should have the Derived Entity Write role mapped to your user group to copy a derived entity.

To copy a Derived Entity:

1. From the Derived Entity Summary window, select the derived entity you want to copy and click Copy. The Derived Entity Details window is displayed

2. Enter the required details. For more information, see Creating Derived Entity.

3. Click Save.

Back to Top

Viewing Derived Entity Properties

You can view the metadata of the selected Derived Entity.

To view the existing Derived Entity definition details:

1. From the Derived Entity Summary window, select the derived entity you want to view and click View. The Derived Entity Details window is displayed.

The View Derived Entity Details window displays the details of the selected Derived Entity definition. The User Info grid at the bottom of the window displays the metadata information about the Derived Entity definition created along with the option to add comments.

2. Click Close.

Back to Top

Modifying Derived Entity

You can modify a Derived Entity definition as required. A Derived Entity definition in the un-authorized state (modified by other users) cannot be modified. You can modify Derived Entity if you have Derived Entity Write role mapped to your user group.

1. From the Derived Entity Summary window, select the derived entity you want to modify and click Edit. The Derived Entity Details window is displayed.

2. Modify the required details such as Short Description, Long Description and the metadata to be associated with the Derived Entity. For more information, see Creating Derived Entity.

3. Click Save and update the details.

When you modify a Derived Entity which is mapped to other metadata definition, the Affected Metadata Dialog is displayed with the list of mapped Data Sets, Measures, and Hierarchies which gets auto updated. Click OK to confirm, else click Cancel.

Back to Top

Deleting Derived Entity

You can delete a Derived Entity that you have created or if you are authorized to do so. A Derived Entity in Unauthorized state (modified by other users) cannot be deleted. You can delete Derived Entity if you have the Derived Entity Write role mapped to your user group.

Delete function permanently removes the Derived Entity from the database. Ensure that you have verified the details as indicated below:

• A Derived Entity definition marked for deletion is not accessible for other users.

• Every delete action has to be Authorized/Rejected by the authorizer.

• • On Authorization, the Derived Entity details are removed.

  • On Rejection, the Derived Entity details are reverted back to authorized state.

• You cannot update Derived Entity details before authorizing/rejecting the deletion.

• An un-authorized Derived Entity definition can be deleted.

To delete a Derived Entity in the Derived Entity window:

1. From the Derived Entity Summary window, select the derived entity you want to delete and click Delete.

2. Click OK in the confirmation dialog.

Back to Top