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.
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 the same way as in metric sets.
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.
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 its green or orange tile to edit it.
The 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.
For elements that could be either a measure or a hierarchy, you can switch between them by clicking Switch to a hierarchy or Switch to a measure.
1.2.1. Replace with a hierarchy
Simple columns containing text, dates & times, or numeric IDs each 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 and set up with features such as multiple levels or custom sorting, or with a time dimension hierarchy for date/time data.
For example, to replace a ProductID column with an existing Product hierarchy, click Select a hierarchy or level to use as a replacement in the Output Element dialog.
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.
Click the submit button at the bottom when finished.
If there are additional hierarchy links you want to indicate, click 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.
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.
1.2.3. Attribute hierarchies
If the element is an 'implicit' hierarchy, you can define other elements that should appear as attributes for this hierarchy, the same way as attributes defined in a user hierarchy created from the main menu.
You can select one or more elements under Attribute Hierarchies: to select multiple, click and drag, or hold the Ctrl or Shift keys while selecting.
After submitting the dialog, the hierarchy with attributes defined will appear with a special icon, and the elements selected as attribute hierarchies will no longer be listed as separate hierarchies in the Data Cube Elements popup.
1.2.4. Formatting measures
The formatting options available on a metric set can also be defined ahead of time for a measure in a data cube, which will be the initial settings used whenever that measure is selected.
Click Configure format to open the Configure Formats dialog, which contains a variety of formatting options. For details on these, see the article Formatting text.
Double-click the Process Result transform to see its configuration dialog, or select Configure from the toolbar or 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).
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.