Dataset Schema

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 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.

This section discusses the following topics:

To Interpret 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.

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 Configuring Interface and Analysis Features chapter in the Data Workbench User Guide.

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