...
Choose Delete Record Type from the record type ellipsis menu to delete it.
Adding and Deleting Members
...
- Choose a record type and click the Add Member button (+).
- Specify a name for the new member and choose a type from the drop-down menu. You can add a primitive, a list of primitives, or record type as a member of the selected record type (see Data Modeling for information about types of members).
- Choose a data generation mode for the new member. See Mask and Generation Settings for details.
- Configure the mode settings and click Create.
To delete a member from the model, choose Delete Member from the member's ellipsis menu.
Setting Properties
...
- Click on a component and choose Add New Property from the ellipsis menu.
- Define the property in the field that opens.
- Changes are automatically saved when you click away.
...
- Open the Remove Property menu.
- Click the trash icon.
Adding and Deleting SQL Templates
...
- Click on the data set mode in the model and click the Add Template button (+).
- Enter your SQL template and click Save.
The new template will appear in the model. It will be assigned a display name in a SQL# format and include an empty results set.
To change the template display name:
- Click the ellipsis menu icon and choose Edit Display Name.
- Specify a new name when prompted and click Save. Changing the display name only affects how it's represented in the model and does not affect the underlying data.
To delete a template, click the ellipsis menu icon and choose Delete SQL Template.
Adding and Deleting SQL Parameters
SQL parameters are To add a parameter:
- Choose a template and click the Add Parameters button (+) for with the template parameters in the sidebar.
- Specify a name for the parameter when prompted and click Create.
...
- Click the ellipsis menu and choose Delete Parameter from the drop-down menu.
- Confirm that you want to delete the parameter when prompted. The parameter and all its associated data will be removed from the repository.
Adding and Deleting Columns
...
- Click on a result set to view its columns.
- Click the Add Column button (+) in the Columns area and enter a name when prompted.
- Click Create.
...
- Click the column's ellipsis menu icon and choose Delete Column.
- Confirm that you want to delete the column when prompted.
Generating Data
...
- Click on a record type or SQL template and choose Mask and Generate Settings from the component's ellipsis menu.
The Mask and Generate Settings for a result set are limited to the number of occurrences.
- Choose a mode from the drop-down menu. The mode determines how the data is generated. Each mode has different options. See See Mask and Generation Settings for details.
- Configure the Mask and Generation Settings for the type you selected and click Save.
- Click Generate Data in the toolbar.
- Specify a name for the generated repository, choose the number of records to generate, and select which original data sets to include.
For SQL templates, you will be able to expand SQL templates.
- Click Generate to add the data generation task to the queue.
...
- Click on a component and choose Infer Constraints from the member's or key's ellipsis menu (also see Inferring Data Constraints). You could manually set the constraints, but using the built-in function on existing data makes this step easier.
- Click on the constraints for any components if you need to make adjustments.
- Choose Mask and Generate Settings from the components ellipsis menu.
- Choose a mode from the drop-down menu. The mode determines how the data is generated. Each mode has different options. See Mask and Generation Settings for details.
- Configure the settings for the type you selected and click Save.
Click Mask Data in the toolbar.
All data members with mask and generate settings will be replaced in a new masked repository.
...
- Open the repository from which you want to generate a subset.
- Set the data constraints for the subset (see Inferring Data Constraints). Data that is within the specified constraints will be copied to the new subset repository.
- (Optional) Click Integrity Test in the toolbar to verify that the constraints are valid (see Testing Data Integrity). Only data that passes the integrity test will be copied to the new subset repository.
- Click Subset Data in the toolbar.
- Specify a name for subset repository when prompted and click Subset.
...
The Data Modeling feature can automatically set constraints for generating new data based on the data in the repository. You infer constraints for the selected repository by choosing a repository in the sidebar and click the click Infer Constraints button.
You can also infer constraints for individual members and keys by choosing Infer Constraints from the key/member ellipsis menu.
CTP will infer that the data is a Boolean, date, number, or string.
...
If you want to edit the constraints, click on the constraint properties and make changes in the Data Constraint Settings editor.
You can configure the following settings:
...
You can configure the component to reference the data in another component. This ensures that keys, members, columns, result sets, and other data-holding objects in the model remain consistent. Click in the Reference field and a hierarchical view of the objects in the data set appear.
Testing Data Integrity
...
You can test the integrity of individual objects in the model (i.e, members, such as members and columns) or all objects in a data set by choosing Integrity Test from the ellipsis menu.
You can test the data integrity for the repository by clicking the clicking Integrity Test button in the toolbar.
If no constraints are set, a warning will appear. If the data does not match the constraints, an error will appear, and the member will be flagged.
You can click on the error message to see details in an overlay.
You can view additional information about the integrity tests in the Test Data Assistant Tasks tab.
Mask and Generation Settings
...
Choose this mode to programmatically set constraints. Simple math, string, and date operations using JavaScript syntax are supported. You can also use the ready-made aggregate functions in your formulas (e.g.for example, SUM, COUNT, etc.and so on).
See Consuming the Data in Tools for information on the syntax for referencing other record type members.
...