• Modifying the type of a column
• Changing the identifier of a column
• Modifying and translating the display name
• Modifying the format of a column
• Modifying the aggregation function of a measurement
• Modifying the measurement trend
• Changing display settings in the filter and navigation bar
• Modifying artificial intelligence parameters
• Sorting the members of a column
• Changing the time zone
• Defining a label for a dimension
• Hiding/Showing a column
• Assigning a column to a category

Here's how to change the various parameters of the columns in a data model

Modifying the type of a column

Select the column you wish to modify and then, in the properties panel on the right, choose the Type from the drop-down list below.

Changing the identifier of a column

Select the column from the list and enter the desired name in the Identifier field of the parameters panel.

This identifier is used by default as the Name of the dimension or measure.

Modifying and translating the display name

To change the name displayed for a dimension or measure in the charts :

1. Select the column and click the button to the right of the identifier.
2. In the Display name field, enter the name to be displayed.
   

In this interface, you can also add a translation in the specified languages or a description. See the Translate the name of an object page for more details.

Modifying the format of a column

Select the measure whose format you wish to change and then, in the properties panel on the right, choose Format from the drop-down list.

If the desired format is not available in the list, you can create a new format using the Edit button. See the Format manager page for more details.

Modifying the aggregation function of a measurement

Select the measurement you wish to modify and then, in the properties panel on the right, choose the Aggregation function from the corresponding drop-down list.
By default, the Sum function is selected.
The Running sum function corresponds to the cumulative sum of the measurement's members.
The OR function logically ORs ('|' in programming or '+' in Boolean arithmetic) the measurement's (integer) values. Example: 2+2=4 (arithmetic sum) but 2|2 =2, 2|1=3, 1|0=1... (logical OR).

The selected function will be used to aggregate the measurement along the analysis axes.

Modifying the measurement trend

Select the measurement you wish to modify and then, in the column properties displayed on the right, choose Trend from the corresponding drop-down list.

The Trend is used to indicate the expected trend for a measurement:

• Increasing: The trend for the measure should be increasing (e.g. sales).
• Decreasing : the measurement trend should be decreasing (e.g. costs)
• Stable: the measurement should remain stable

These trends are used by natural language queries. The keywords "best" and "worst" (top/bottom) respect the trend of the measure. So a top 5 on a rising bar will display the five highest values, while a top 5 on a falling bar will display the 5 lowest values.

Changing display settings in the filter and navigation bar

The dashboards display a bar containing all the dimensions selected for interactive filtering. The user can select the values to be displayed for each of these dimensions.
If you do not want a dimension to be displayed in the dashboard's interactive filter bar, uncheck the Filter bar box in Properties.
In addition, if you do not want a dimension to be navigated, uncheck the Navigation box in Properties. In this case, selecting values for the dimension will not modify the chart.
These properties will be used by default by information flows using the data model. They can be modified individually for each Flow.

See the dedicated page Specifying the dimensions used in the filter and navigation bar for more details.

Modifying artificial intelligence parameters

Properties related to dimensions and measures are available if you use artificial intelligence:

• AI analysis: By default, all dimensions and measures are used for analysis by artificial intelligence (Display highlights and DigDash Agent). You can uncheck AI analysis for a dimension/measure to ignore it.
• Embed members (Only for a dimension in DigDash Agent): By default, members of all dimensions are embedded.
  Embedding involves transforming the names of members of a dimension (such as products, customers or countries) into numerical vectors that represent their meaning rather than just their spelling.
  This transformation allows semantic search to find items even if the words are not exactly the same - for example, searching for "auto" will also return "voiture".
  If the dimension contains a large number of members (for example, more than 100,000), the vectorisation process can take a long time.
  You can deactivate this functionality for a dimension to speed up the vectorisation process: the search will then be faster but will only be based on exact text matches.

Sorting the members of a column

Select the dimension you wish to sort and then, in the properties panel on the right, select :

• The type of sort you want from the drop-down list: Alphabetic sort, Numeric sort (for numeric or date values) or Manual sort.
• The sort order: Ascending or Descending.

If you select Manual sort, the Sort root members on dimension box is displayed, allowing you to select the sorted members and position the column elements in the desired positions (drag and drop the elements to the desired position).

Changing the time zone

In the case of a time dimension, you can change the time zone by specifying the original time zone of the date and the time zone in which you want the date to be displayed.

Defining a label for a dimension

You can define another dimension as the label for a dimension. In this case, by default, the values in the column chosen for the label will be displayed instead of the values in the column.
For example, if you add dimension B as the label for dimension A, and then display A in your chart, the values for dimension B will be displayed.

You must have a 1-1 relationship between the original dimension and the dimension chosen as the label. Labels can be used, for example, to add a text label to numeric dimensions.

To define another dimension as a label :

1. Select the dimension for which you wish to use a label.
2. In the right-hand panel, click the Select button to the right of Label.
   ➡ The Select a dimension dialog box is displayed.
3. Select the desired dimension (a search bar is available if required) then click OK.
4. Check the Sort on label box if you want members to be displayed according to the sorting of the label dimension.

To change the dimension used for the label, click on the selected dimension and proceed in the same way as above.
To delete the label, click the Delete button .

Hiding/Showing a column

To hide a column that you do not wish to use in your graphs (hidden columns do not appear in the visualization configuration stage):

• Right-click the column, then select Show/Hide from the pop-up menu that appears.
  

For example, you can hide measurements that are only used to create other measurements.

Assigning a column to a category

To assign a column to a category:

1. Right-click the column, then select Assign to category.
2. Choose New to create a new category or select an existing category.

You can also change the category from the Category drop-down list in the right-hand properties panel.