Page History

...

1. Drag a table from the right pane into the middle pane.
   • The Add New Metadata Object window defaults the object type to a View.
   • Change the View name as required, and click Add.

   

2. The View Column Definition window enables the automated re-mapping of certain column names.
   It provides an easy method for changing the column names for a large number of columns when creating a view.

   

3. Click OK, the View properties window is displayed:

   

   Change the following properties, if required:

   • Select the Distinct Data Select check box if you want the view to return only distinct values.
   • A From/Where clause could be entered but this can also be done later.
     Clicking the ellipses button opens the Source Join wizard shown below. Refer to Generating the Dimension Update Procedure > Source tab > Joining multiple source tables for details.

   

4. Click OK in the View properties window, after completing the view definition. A prompt is displayed to indicate that the view has been defined, click Create View.

   

   The columns of the View table are displayed in the middle pane.

   

...