Give a friendly name to a transform

Contents[Hide]

1. Overview

When you add multiple SQL Select transforms to your data cube, each transform node on the canvas displays the name of the associated SQL Server database table. In this case, it is easy to identify the transforms on the canvas.

SQL Select transforms show the name of the database table
SQL Select transforms show the name of the database table

However, when you are working with multiple Manual Select transforms, there is no suitable default name for them and they all appear identical on the canvas, making it difficult to identify them.

The solution in this case is to give a friendly name and optionally a description to each of these transforms. 

2. Friendly name and description

As an example, consider a data cube process consisting of two Manual Select transforms.

Data cube with two Manual Select transforms
Data cube with two Manual Select transforms

Double-click the first Manual Select transform to configure it. In the Manual Select dialog, set the Name and Description fields.

Set the Name and Description
Set the Name and Description

Returning to the Data Cube Designer canvas, you'll see that the Manual Select transform now appears with its friendly name displayed. To see the description in a tooltip, hover over the transform.

Manual Select transform showing friendly name
Manual Select transform showing friendly name

Note
Friendly names won't be displayed for native selection transforms such as SQL Select because these transforms display the table name instead.

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