Dimensions with Multiple Values

As of Release 5.4.0, 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.

REQUIREMENTS:

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

COMMON WORKFLOW:

  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

1. Create a Dimension with Multiple Values

1.1. Access Content > Dimensions

Click [+ New Dimension]

1.2. Define the Basics

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.3. Info tab > Dimension Values section

  1. Click [+ 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

  1. Admin > Data Sources > Plugin Data Sources  > Info tab
  2. Specify the Delimiter that you used with Multiple Dimension Values

3. Map an External Filter to this Dimension

  1. External Report  > Configuration tab
  2. [+ Plugin Filter] to add an external filter that will be mapped to the Dimension with Multiple Values
  3. On the pop-up, enter the Filter Name
  4. From the dropdown, select the Dimension with Multiple Values
  5. 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.