Dataset Schema interface
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|
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 > .