Outline view
The Outline view offers two different representations of the data mart on the canvas.
- A hierarchical list (tree view) of all the tables in the data mart on the canvas
- A bird's-eye-view of the canvas, which allows you to see the full extent of the currently displayed data-mart diagram with minimal scrolling effort
Hierarchical list (tree view)
When the Outline view shows a hierarchical list (tree view) of a data-mart diagram and is the active window, the Properties view shows the property pages for the object that is selected in the Outline view.
If you select the root node of the hierarchical list, which represents the entire data mart, the following pages are displayed in the Properties view:
- General
- This page shows the name of the data mart on the canvas, the name
of the associated database, and the estimated size of the data mart.
It also provides buttons to:
- Set the database for the selected data mart (change the source location)
- Deploy the data mart
- Validate the data mart
- Refresh the database cache
- Tables
- This page lists the tables that are used in the data mart and shows their estimated sizes. There are also buttons to add and remove tables from the data mart.
- Validation
- This page shows just the errors in the data mart that is currently displayed on the canvas. The same errors are also listed in the Problems view. The purpose of the Validation page is to isolate the data mart errors, so that you do not need to identify them among all the others in the Problems view.
- Space Required
- This page gives you an estimated size of the data mart that is currently displayed on the canvas. The size displayed is the total estimated compressed size in the combined main memory of all accelerator server nodes. The actual size that is required after loading might differ from the estimate because it depends on the actual column cardinalities and the value frequency distribution.
If you select an item in the hierarchical list that represents a table, the Properties view shows the following pages:
- General
- This page displays the name and the schema name of the selected table. It also gives you access to the Fact table check box and related radio buttons. Using these controls, you can select the method by which it is determined whether the selected table is a fact table.
- Columns
- This page lists the columns in the selected tables. There are check boxes in front of the column names so that you can exclude and include columns. This determines which queries can run at an accelerated pace (queries against an excluded column are not accelerated because the data will not be present in the data mart after the data mart has been deployed to an accelerator). Selecting just a subset of the available columns of a table also reduces the data mart size.
- Relationships
- This page lists the references between the selected tables and gives you access to several function buttons.
- Space Required
- This page gives you the estimated size of the selected table and
informs you about its role in the references that it participates
in. In addition, the page gives you the memory space that will be
required when a table join, as defined by a reference, takes place.
For example:
Estimated size of this table: 3 KB Table is parent in a run-time join = 3.0 KB
Bird's-eye-view (data-mart diagram)
When the Outline view shows a data-mart diagram (bird's-eye-view) and the entire data mart is selected on the canvas, the Properties view shows the same pages as the hierarchical list. When just a table is selected on the canvas, no Properties pages are shown. To select an entire data mart, click once on the white space of the canvas.