Focus Component properties view

The focus of analysis consists of one or more focus components. It defines the entities under investigation.

For example, if you want to forecast the revenue of your products on a particular day in the future, you must aggregate your sales data separately for each product and each day. To prepare for this aggregation, you must define the focus components product and day for the focus of analysis. The result of this transformation is a table that includes one row for each combination of values of the focus components. The transformations are defined in the profile.

The Focus Component properties view is displayed by double-clicking a focus component in the Design Studio.

The properties view includes the following tabs:

General

The name for the focus component must be unique. Optionally, you can provide a textual description.

Definition

You can define a focus component based on columns or by a hierarchy level from the underlying input model.

If you define a focus component based on columns, you can reference one or more columns for the focus component.

In many simpler cases the focus of analysis is defined by a single level in one of the hierarchies of the data source.

Focus components based on columns

Typically, the definition of a single column is sufficient. However, sometimes the values of two or more columns might be required to identify the values of a focus component uniquely. For example, if customer is the focus component and a customer ID is not available, the columns First Name and Last Name might be required to identify the customer uniquely.

From the list of available columns, you can select one or more columns that define your focus component. You can view the columns of a table by clicking the plus symbol (+). You can select one or more columns by clicking the Right arrow.

Focus components based on hierarchy levels

The level definition, that is the columns defining the level, is shown below the selected level name for your reference.

From the list of available levels, you can select one level. You can view the levels of a hierarchy by clicking the plus sign (+). You can select one level by clicking the Right arrow.

In the Selected columns table and in the Level definition table, you can change the name of the column in the result table by clicking into the column Result Column Name and editing the name.

Feedback