Non-Dimension Object Views

WhereScape RED also supports creating views of objects other than dimensions (Load tables, Facts, Stage tables, Aggregates, etc.).
A Fact View is a database view of a Fact table. It may be a full, partial view, or a view incorporating both the fact data and some dimensional attributes.
It is typically used in cases where a subset of information is to be provided for specific end-user communities. It is common that the 'Where' clause be populated in fact views, either to join the dimension tables or restrict the data that the view represents.
Similarly, views may be created over Staging tables or any other table object.
The creation of non-dimension table views is the same process as that for Dimension views: 

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.