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

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

Process Result context menu
Process Result context menu

1.1. Hide elements

You can 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 and you can easily unhide it by clicking its plus icon.

Hide and hide elements
Hide and hide elements

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

You can access additional options related to a specific measure or hierarchy by clicking the Edit icon on the right. 

Edit Data Cube Output Element
Edit Data Cube Output Element

The Edit Data Cube Output Element dialog will open, where you can change the Caption, set a Description, customize a measure's Supported Aggregators and Format, and access other settings.

You can change the element type if the data supports being either a measure or a hierarchy by clicking Switch to hierarchy or Switch to measure.

Switch the measure to a hierarchy
Switch the measure to a hierarchy

1.2.1. Replace with a hierarchy

Simple columns such as ProductID automatically become an 'implicit' or generated hierarchy when output by the cube and used in a metric set. You can replace such columns with a hierarchy you've created with multiple levels, custom sorting, etc.

For example, to replace the ProductID column with an existing Product hierarchy, click Select a hierarchy or level to use as a replacement in the Edit Data Cube Output Element dialog.

Select a hierarchy or level to use as a replacement
Select a hierarchy or level to use as a replacement

In the Open dialog that appears, find your Product hierarchy, expand to see its levels, and select the hierarchy or a level. Selecting a hierarchy will link the column to the lowest level of the hierarchy by default. You can indicate the specific link to use by selecting a specific hierarchy level.

Select a hierarchy or level to use as a replacement
Select a hierarchy or level to use as a replacement

Click the submit button at the bottom when finished.

If there are additional hierarchy links you want to indicate, click Set up additional links.

Set up additional links
Set up additional links

In the dialog that appears, select a Hierarchy Level from the dropdown. To add a link, drag an item under Hierarchy Keys and drop it onto the corresponding item under Result Elements.

Set Up Hierarchy Links dialog
Set Up Hierarchy Links dialog

1.2.2. All member caption

The All member caption can be used to override the display text at the top node of the hierarchy. If this value is not set, it will display the value located in the localization file for the current language.

Customized All member caption.
Customized All member caption.

Note
Implicit date hierarchies used with a Calendar filter will use the caption from default time dimension.

1.2.3. Formatting values

You can define the format used when displaying a measure in metric sets. This format will be used as a default, when no other format is indicated on the metric set.

Enter a valid .NET format in the Format field. You can use standard numeric format strings or custom numeric format strings.

Indicate the default format for measure values
Indicate the default format for measure values

Common examples:

Format TypeFormat StringDisplayed Text
Numeric with 5 decimal places N5 80,487,704.17919
Currency with 2 decimal places C2 $80,487,704.18
Percent (multiplied by 100) with 0 decimal places P0 8,048,770,418%
Exponential/scientific with 2 decimal places E2 8.05E+007
Custom numeric (1 non-zero decimal place) 0,0.# 80,487,704.2
Custom numeric (thousands) #,0,K 80,488K
Custom numeric (millions with 1 decimal place) #,0,,.0M 80.5M

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
Process Result dialog

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.

Preview the data cube process result
Preview the data cube process result

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