Set up entity creation parameters

Release notes

Set up the parameters that are applied:

To the creation of Data sets in D365 FO.
On deploy, to the creation of entities in the target database.

Standard procedure

1.	Go to Data modeling studio > Data modeling studio > Parameters.
2.	Sub-task: Set the prefixes and suffix parameters.
2.1	You can define a prefix for system fields. On deploy, the prefix is applied when the system fields are added to the applicable table in the target database. Example: If the entity system fields prefix is 'CDP' and systems fields are added to a table on the target database, the system field name is 'CDPRecId'.
	In the Entity system fields prefix field, type a value.
	Note: The default entity system fields prefix is 'CDP'. If you use CDPR on the data warehouse, you must always use 'CDP' as entity system fields prefix. If you don not use CDPR, you can define a prefix as desired.
2.2	You can define a prefix that is applied: - To the creation of Data sets in D365 FO. The defined entity prefix is added as prefix to the data set identification. Example: If the entity prefix is 'CDP' and you create a data set for the SalesTable, the data set identification is 'CDPSalesTableDataEntity'. - On deploy, to the creation of tables in the target database. The defined entity prefix is added as prefix to the table name in the target database. Example: If the entity prefix is 'CDP' and on deploy, on the target database, a table is created for the SalesTable, the table name is: CDPSalesTableSTAGING.
	In the Entity prefix field, type a value.
	Note: -The default entity prefix is 'CDP'. If you use CDPR on the data warehouse, you must always use 'CDP' as entity prefix. If you don't use CDPR, you can define a prefix as desired. - If the entity prefix is changed between the creation of a data set and deploy, the entity prefix from the parameters is applied. So, it overwrites the prefix as applied to the data set identification. - On deploy, the entity prefix is not applied to the creation of metadata tables. - On deploy, the entity prefix is applied to the creation of the financial dimensions table.
2.3	You can define a suffix that is applied, on deploy, to the creation of tables in the target database. The defined entity suffix is added as suffix to the table name in the target database. Example: If the entity suffix is 'STAGING', and on deploy, on the target database, a table is created for the SalesTable, the table name is 'CDPSalesTableSTAGING'.
	In the Suffix field, type a value.
	Note: - On creation of a data set, the fixed 'DataEntity' suffix is applied. On deploy, this suffix is replaced with the entity suffix as defined in the parameters. For example, if a data set identification is CDPSalesTableDataEntity, on deploy, the table name in the target database becomes 'CDPSalesTableSTAGING'. - On deploy, the entity suffix is not applied to the creation of the metadata tables and the financial dimensions table.
3.	Sub-task: Set the fields parameters.
3.1	You can define the default value for the Add date and time fields field on the data set. If, on the data set, this field is set to 'Yes', on deploy, the table date/time fields are added to the target database. On export, the data of these date/time fields is also exported. Also, to the target database, additional fields are added to store the time zone. On export, time zone calculations are applied to store the right time in the target data base time zone.
	In the Add date and time fields field, select the desired option: 'Yes' or 'No'.
3.2	You can define the default value for the Add system fields field on the data set. If, on the data set, this field is set to 'Yes', on deploy, the table system fields are added to the target database. On export, the data of these system fields is also exported.
	In the Add system fields field, select the desired option: 'Yes' or 'No'.
	Note: If you add system fields to the target database, these fields get a prefix in the target database as defined by the Entity system fields prefix parameter.

Related to	Notes
Set up parameters

Provide feedback