Display Tab

On the Display tab, you specify which columns and calculated fields to expose through the Domain and how they appear. Typically, you select only columns that are useful in building or filtering reports, and omit other columns for simplicity. You also can modify display properties, such as the label and description of tables and sets and items for each specified column. Using meaningful labels and descriptions to help users of the Domain.

The Display tab contains three panels:

•

Resources – Lists tables or join trees, depending on the view you choose.

•

Sets and Items – Lists resources that appear to report creators who use the Domain.

•

Properties – Displays and modifies properties of selected sets and item.

In the Resources panel you can view resources as either a Join Tree or a Table List:

•

Join Tree – Displays joined, unjoined, and calculated tables for this Domain. Joined tables appear as join trees.

•

Table List – Displays the selected and calculated tables for this Domain.

In the Table List view, you can use the Delete Table button to remove the selected table from the Resources panel and from the Domain design. The table no longer appears on the Joins tab, and any joins to the table are deleted. Use carefully.

To specify which columns and calculated fields are exposed to users of the Domain, you move resources from the Resources panel to the Sets and Items panel:

•

Set – A group of items independent of the tables in which the columns originate.

•

Item – A column or calculated field, along with its display properties, that you want to appear in the Domain.

All items in a set correspond to columns in a join tree. Sets and items appear to report creators who use the Domain. Sets are optional. You can create a list of items outside of any sets. If you want to display only a few of the columns from the join tree, first create a new set in Sets and Items. Next, add items from the join tree in Resources.

To move a resource to Sets and Items, you can drag it from Resources and drop it in Sets and Items, or you can use one of the following buttons:

Add to Sets – Select a resource in Resources and click this icon to add it to Sets and Items. Tables are added as sets, and columns are added as items outside of any set.

Add to Selected Set – Select a destination set in Sets and Items, select a resource in Resources, and click this icon. Tables are added to Sets and Items as subsets, and columns are added as items within the destination set. You can also expand sets in Sets and Items and drag tables and columns from Resources to the destination set.

To create new sets or delete items, use the New Set and Delete buttons:

 

New Set – Creates a new set or subset in Sets and Items. If a set is not selected, clicking New Set creates a top-level set; otherwise, clicking New Set creates a subset.

Delete – Removes the selected set or item from Sets and Items. You can also double-click the object or drag and drop it in a blank area of Resources. Items removed from Sets and Items automatically reappear in Resources.

To move most of the tables and columns in Resources to Sets and Items:

1.

Double-click the join tree name in Resources, or drag-and-drop it from Resources to Sets and Items. All tables are created as sets, and the columns are created as items within the sets.

2.

Remove any unwanted sets or items individually from Sets and Items using the Delete Item button.

To change the order of items within a set in Sets and Items:

1.

Select the item.

2.

Reposition the item using one of the following buttons:

Move the selected set or item to the top.

Move the selected set or item up.

Move the selected set or down.

Move the selected set or item to the bottom.

You can also use these buttons to reposition sets within Sets and Items.

To move items and subsets into other sets:

1.

In Sets and Items, select the item or subset you want to move.

2.

Click Delete Item.

3.

In Sets and Items, select the destination set.

4.

In Resources, select the item or subset deleted from Sets and Items.

5.

Click to add the item or subset from Resources to the destination set.

Subsets always appear after the items in a set.