How to create a map of a database table or view

1	In Navigator, select the appropriate project.

2	Choose File→New→Map.

3	In New Maps—Data Source:

Select the appropriate data source.

Select Create maps by selecting database tables, as shown in Figure 2-24.

Figure 2-24

Creating maps by selecting database tables

Choose Next.

4	In New Maps—Maps:

In Catalog, select the appropriate catalog.

In Filter:

To display tables and views from a particular schema, type the first few characters of the schema name in Schema name prefix, for example, dbo. Do not append an asterisk, for example, dbo*. This filter is case-sensitive.

To display only tables and views whose names begin with a particular string, type the string in Table/View name prefix, for example, ac. Do not append an asterisk, for example, ac*. This filter is case-sensitive.

Select Show tables only, Show views only, or Show all.

Choose Apply filter.

Move the appropriate tables and views from Available to Selected, as shown in Figure 2-25.

o

Figure 2-25

Selecting tables

Choose Finish.

A reminder appears. Choose OK.

The map file names appear in Navigator. If you created only one map, Output Columns appears.

5	If you created more than one map, double-click the first map file name in Navigator to display Output Columns.

6	In Output Columns:

Deselect the columns you want to exclude from the map.

To rename a column, type the new name in Name.

Decide on column names before you build an information object from the map. Changing a column name after you build an information object results in a compiler error in the information object.

To create a filter on a column, set the column’s Filter property to Predefined and choose Prompt editor to specify the filter’s prompt properties. Figure 2-26 shows Output Columns and the location of the Prompt editor button for the first column.

Figure 2-26

Map columns

To define other column properties, select the column and define the properties in Properties.

To specify the default analysis type for a column, choose Default Analytics.

To create column categories, choose Column Categories.

To change the order of the columns, use Move up and Move down.

7	Repeat the previous two steps for the remaining maps, if any.

Copyright Actuate Corporation 2012