Dataset Schema interface

Last update: 2022-10-04
  • Created for:
  • User

Read more about Data Workbench’s End-of-life announcement.

The Dataset Schema interface displays the extended dimensions (countable, simple, many-to-many, numeric, denormal, and time dimensions) defined in any transformation dataset configuration file and provides a view of the relationships between those dimensions.

In addition, the Dataset Schema interface shows any derived dimensions that you have defined, as well as any extended dimensions that are configured to be hidden.


You can search for dimensions from within the schema diagram. The name of the dimensions found by the search string are highlighted, and the lines of the parent class change color for any hits found in subordinate child dimensions. The Countable dimensions stay visible as you scroll to provide viewable hierarchy and context.

To interpret a dimension type using the Dataset Schema interface

The following table lists the dimension types and the colors in which their names appear in the Dataset Schema interface. Parents for the sample dimensions (from the example above) are noted as well.

Dimension Type Color Sample Dimension and Parent
Countable Pink

Visitor - In this schema, Visitor is a root countable dimension.

Session - parent is Visitor

Denormal Yellow DenormalPage - parent is Page View
Derived Blue Next Page - parent is Page View
Many-to-Many Pink and Green (The stem from the parent is pink, while the dimension name is green.) Search Term - parent is Session
Numeric Green Exact Page Duration - parent is Page View. In this example, Exact Page Duration is a hidden numeric dimension. See the Hidden dimension type in this table.
Simple Green Page - parent is Page View
Time Green Hour - parent is Session
Hidden Hidden dimensions are a darker version of the appropriate dimension type color. For example, a hidden numeric dimension is a darker, less bright green. Exact Page Duration - parent is Page View

For more information about these dimension types, see the Dataset Configuration Guide.

To display the default visualization for a dimension

  • In the Dataset Schema interface, click the desired dimension. The default visualization displays. For example, if the default visualization is a table displaying Sessions and the selected dimension and you click the URI dimension, Data Workbench displays a table with URI by Sessions.


    If you want to change the default visualization that displays, see The Dataset Schema Interface.

To display a specific visualization for a dimension

  • In the Dataset Schema interface, right-click the desired dimension and click Add Visualization > < visualization type>.

On this page