Help & DocumentationDatasets Creating Elements from DatasetsCreate a Dimension with values sourced from a Dataset

Create a Dimension with values sourced from a Dataset

This article outlines the process used to create a Dimension whose values are populated automatically from the Dataset.

PREREQUISITES:

In the Dataset choose the column that contains the required Dimension Values

Open the Dataset that is going to serve as a source for a future Dimension and find a column that contains the values that should be fetched as Dimension Values. Remember the name of this column, since further you are to specify it while creating a Dimension.

1. Access Content > Dimension

The list of Dimensions previously created in the system opens.

At the bottom of the page click [+ New Dimension].

2. Provide key information for fetching Dimension Values

Provide key information for fetching Dimension Values

Provide the basic Dimension definition information, paying close attention to:

  1. Name: should be unique and descriptive
  2. Value Source: since we are creating a Dimension sourced from a Dataset, choose 'Datasets' from the drop-down list.
  3. Dataset & View: Choose the name of the Dataset or its particular View to be used as a Data Source for this Dimension. To quickly preview Dataset's columns, click an Eye icon to the right of this field.
  4. Key Value Column: Choose the name of the Dataset column that contains the required values. The column content type (numeric or text) is going to be specified in the round brackets next to the column name.
  5. Display Value Column: Choose a Dataset column with Display Values (often the same as above).

Save this basic information to proceed with creating a Dimension. The Dimension Editor opens.

3. Collect Values

  1. After you set up Dataset & View, Key Value Column, Display Value Column fields, click Check Data
  2. The system displays Sample dimension values below.
  3. If the sample dimension values shown are as expected, click Collect values

4. Dimension Values list is populated

0 Comments

Add your comment

E-Mail me when someone replies to this comment