Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

IT Business Analytics10.10

Develop > Develop Content > Extend Content > IDE > IDE Basic Tasks > Load an existing Target entity

Load an existing Target entity

To access:

Load an existing Target entity

Target Content Pack

Architect Target Designer View

Palette Area

User interface elements are described below (when relevant, unlabeled elements are shown in angle brackets):

UI Element	Description
Entities	Contains the following Target entity options: New Target Entity. Creates a new Target entity.Entity type can be defined in the Properties tab. To view the Properties tab, right-click on the specific entity and click Show Properties View. Load Target Entity. Opens the Resource Selector dialog box. Select the relevant entity for your model. Target Column. Adds columns to entities. Column properties, for example column type, can be edited in the Properties tab. Each added attribute impacts the relevant entity generations.
Target Entities Relation	Click a link to create connections for building the model. Dimension to Dimension. Link from one Dimension to another Dimension. A red arrow is displayed between the entities. Fact to Dimension. Link from a Fact to a Dimension. This type of relation requires that the fact type was defined in the entity properties. A blue arrow is displayed between the entities. Target Extension. Link from a new target entity to the base/original target entity. A black arrow is displayed between the entities.

UI Element

Description

Entities

Contains the following Target entity options:

New Target Entity. Creates a new Target entity.Entity type can be defined in the Properties tab. To view the Properties tab, right-click on the specific entity and click Show Properties View.
Load Target Entity. Opens the Resource Selector dialog box. Select the relevant entity for your model.
Target Column. Adds columns to entities. Column properties, for example column type, can be edited in the Properties tab.

Each added attribute impacts the relevant entity generations.

Target Entities Relation

Click a link to create connections for building the model.

Dimension to Dimension. Link from one Dimension to another Dimension. A red arrow is displayed between the entities.
Fact to Dimension. Link from a Fact to a Dimension. This type of relation requires that the fact type was defined in the entity properties. A blue arrow is displayed between the entities.
Target Extension. Link from a new target entity to the base/original target entity. A black arrow is displayed between the entities.

Properties tab for Target entity and specific fields

To view the Properties tab, right-click on the specific entity and click Show Properties View.

You first configure the Target entity properties, and then the properties for each specific column.

UI Element	Description
General tab	Displays the Entity, Dimension and Fact attributes for the target entity. General Target entity attributes: ID: The ID of the entity. Business Name: The complete business name. Description: Enter a description of the entity. Dimension/Fact Checkbox: Select one or both for the entity. If you change the selection, a dialog opens, warning that you may lose information previously entered in the Columns tab. Note Make sure to select the required option connected to the relevant Fact or Dimension column properties.
Columns tab	Displays information for each column in the Target entity. Column property options are displayed according to the entity selection of Fact or Dimension in the General tab. ID. The ID of the entity. Business name. The complete business name. Description. Enter a description of the entity. Data Type. Varchar, Int 16, Int 32, Float, Localized Date Time Length. Only for Varchar data type. The length of a Varchar column must be more than 0 and less than 4000. Null Allowed.Select if the field can have the value NULL. SCD Type. Slowly Changing Dimension type can be either 1 or 2. Only for Dimension. SCD1: For update. SCD2: For preserving history. Measure. Select only for Fact. Calculation Formula.The calculation of the measure. (Optional) Summary. Select SUM, MIN, MAX, or AVG. (Optional)
Appearance tab	Displays font and appearance information.

UI Element

Description

General tab

Displays the Entity, Dimension and Fact attributes for the target entity.

General Target entity attributes:

ID: The ID of the entity.
Business Name: The complete business name.
Description: Enter a description of the entity.
Dimension/Fact Checkbox: Select one or both for the entity.

If you change the selection, a dialog opens, warning that you may lose information previously entered in the Columns tab.

Note Make sure to select the required option connected to the relevant Fact or Dimension column properties.

Columns tab

Displays information for each column in the Target entity. Column property options are displayed according to the entity selection of Fact or Dimension in the General tab.

ID. The ID of the entity.
Business name. The complete business name.
Description. Enter a description of the entity.
Data Type. Varchar, Int 16, Int 32, Float, Localized Date Time
Length. Only for Varchar data type. The length of a Varchar column must be more than 0 and less than 4000.
Null Allowed.Select if the field can have the value NULL.
SCD Type. Slowly Changing Dimension type can be either 1 or 2. Only for Dimension.

SCD1: For update.

SCD2: For preserving history.
Measure. Select only for Fact.
Calculation Formula.The calculation of the measure. (Optional)
Summary. Select SUM, MIN, MAX, or AVG. (Optional)

Appearance tab

Displays font and appearance information.

Send Help Center feedback