How to create a map of an ODA data source query result set

1	In Data source connection properties, choose Map tables.

2

In Maps:

In Name, type a name for the ODA data source query.

In Type, select a data set type from the drop-down list, as shown in Figure 2-46.

Choose Next. The ODA data source query builder appears. For example, for a flat file data source, Select Columns appears.

Figure 2-46

Selecting a data set type for a map on an ODA data source

3	In the ODA data source query builder, build a query. The procedure for building a query varies by the type of ODA data source. For flat file data sources, you select columns, as shown in Figure 2-47.

Figure 2-47

Selecting columns from a flat file data source

Choose Finish. A reminder appears. Choose OK.C

The .epr and .sma file names appear in Navigator.

4	In Output Columns:

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

Decide on column names before you build an information object from this 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-48 shows the Output Columns pane for a map using an ODA data source.

Figure 2-48

Viewing the output columns for a map using an ODA data source

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

Copyright Actuate Corporation 2012