Process Result

Contents[Hide]

The Process Result transform represents the final output or result of the data cube (ETL process).

This transform doesn't do any data processing but it allows you to configure the measures and hierarchies that will be made available to downstream items such as metric sets.

Transform - Process Result
Transform - Process Result

1. Data Cube Elements

Click the Process Result transform to see the Data Cube Elements panel, which shows the list of output measures and hierarchies for this data cube (ETL process). Measures and hierarchies are color-coded differently.

Data Cube Elements panel
Data Cube Elements panel

1.1. Hiding elements

You can optionally hide a measure or hierarchy from the output by clicking its grey minus icon on the very right. The measure or hierarchy will be listed under a HIDDEN section but you can easily unhide it by clicking its plus icon.

A hidden measure or hierarchy is hidden from the data cube output but will still be available for subsequent linking in hierarchy keys (e.g. if you need to use the data cube later to define a hierarchy).

1.2. Replacing with a hierarchy

Columns such as ProductID are referred to as implicit hierarchies. You can add value to your data cube by replacing such columns with multi-level hierarchies.

For example, to replace the ProductID column with an existing Product hierarchy, click the Edit icon on the right of the ProductID column. This opens the Edit Data Cube Output element dialog which shows the available hierarchies in the current project you can use to replace the ProductID column. Find your Product hierarchy, expand to see its levels, and then drag the hierarchy onto the drop region as shown in the figure below. You can also drag the lowest level of the Product hierarchy instead.

Drag Product hierarchy to drop region
Drag Product hierarchy to drop region

In a similar way, you can replace an OrderDate column with a time dimension hierarchy.

ProductID and OrderDate have been replaced with corresponding hierarchies
ProductID and OrderDate have been replaced with corresponding hierarchies

Tip: You can also open the Data Cube Elements panel or the configuration dialog for the Process Result transform from its right-click context menu.

Process Result context menu
Process Result context menu

2. Configure

Double-click the Process Result transform to see its configuration dialog (or use the context menu).

Uncheck any columns which you don't need to be part of the data cube output. This will completely remove the column from the data cube and will make the column unavailable for subsequent linking in hierarchy keys (e.g. if you need to use the data cube to build a hierarchy).

Process Result dialog - Select/Unselect output columns
Process Result dialog - Select/Unselect output columns

3. Output

Select the Process Result transform on the canvas and then click Data Preview to see a preview of the data output generated by this data cube.

Data Preview of the Process Result transform
Data Preview of the Process Result transform

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri