Dimensions with Multiple Values

Users can load aggregate data into External Reports and build visualizations using multiple filter selections. This is achieved by creating Dimensions with Multiple Values and mapping them to combined Filter Values in the respective BI tool. This article describes how to create a Dimension with Multiple Values.

Table of contents:

  1. Create a Dimension with Multiple Values
  2. Configure a Plugin Data Source to support Multiple Values
  3. Map an External Filter to this Dimension
  4. Build aggregate Visualizations for Multiple Values

NOTE: Multiple Dimension Values can only be used with Plugin Data Sources that support Filters.

1. Create a Dimension with Multiple Values

1.1. Start Creating a New Dimension

Access Content > Dimensions

Click [+ New Dimension], specify the basic information for your Dimension, [Save], and proceed to the next step.

For details on creating Dimensions, you can refer to:

  1. Create a Dimension with Manually Entered Values
  2. Create a Dimension with Automatically Collected Values

1.2. Complete the Info Tab

Open the Info tab and scroll the page to Dimension Values section

  1. [+ New Dimension Value]
  2. If necessary, add single Dimension Values
    • In the example above, these are the Values representing sales in each separate country
  3. Create Multiple Values that combine several measurements
    • If you have sales data for Canada and United States, you can collect aggregate data and build a View for North America

NOTE:

  • Optionally, you can build Dimensions having only Multiple (aggregate) Values
  • Multiple Values must have Delimiters
  • Only the following Delimiter symbols are supported: tilde (~), underscore (_) and hyphen (-)

2. Configure a Plugin Data Source to Support Multiple Values

Access Admin > Collection & Storage > Data Sources and click the Data Source Active Name link to open the Data Source Editor

Open the Info tab, scroll the page to the Advanced Data Configuration section and specify the Multiple dimension values delimiter that you used with Multiple Dimension Values

3. Map an External Filter to this Dimension

Access Content > Elements, find the necessary External Report and click its Active Name linc to open The External Report Editor

  1. Open Configuration tab
  2. [Manage Filters]
  3. [+Filter] to add an external filter that will be mapped to the Dimension with Multiple Values
  4. Filter Name: Give the Filter a descriptive name
  5. Filter Values: Select "Map to Dimension Values" option
  6. Dimension: Select the Dimension with Multiple Values from the dropdown menu
  7. [Save]

After you Enable & Publish your Report, you will be able to access visualizations with aggregate data for Multiple Dimension Values.

4. Display Visualizations for Multiple Values

Provided the above configuration steps were performed correctly, you will be able to access visualizations built for Multiple Dimension Values.