Selecting a data source
The following section describes how to select a data source. The procedure for selecting the data source for your report depends on the template you select. If you select a template that does not include a data set, Report Studio prompts you to select an information object or a data object stored in the iHub volume. If you choose a cross tab template, you must select a data object that contains a cube or a data model.
How to select a template that includes one or more data sets
1 In Report Template, select a template that includes one or more data sets. Choose OK. Data appears, as shown in Figure 2‑4.
Figure 2‑4 Selecting a data set
Data displays the data sets included in the template.
2 Select a data set, then choose OK.
Table Builder appears listing the data fields in the selected data set. Use Table Builder to select and insert data fields in a BIRT design.
How to select an information object
This procedure assumes that the option to access information objects has been enabled in the Report Studio configuration file.
1 In Report Template, select a template that does not contain a data set. Choose OK. Data Source appears.
2 In Data Source, select Information Objects, as shown in Figure 2‑5. Then, choose OK.
Figure 2‑5 Selecting an information object data source
3 Select Information Object appears. Navigate to the folder that contains the information object to use. An information object has a .iob file‑name extension. Select the information object, as shown in Figure 2‑6. Then, choose OK.
Table Builder appears listing the data fields in the selected data set. You
use Table Builder to select and insert data fields in a BIRT design.
Figure 2‑6 Selecting an information object
How to select a data object
1 In Report Template, select a template that contains no data set. Choose OK.
2 In Data Source, as shown in Figure 2‑7, select BIRT Data Objects. Then, choose OK.
Figure 2‑7 Selecting a data object
Select Data appears, as shown in Figure 2‑8.
Figure 2‑8 Selecting a data object
3 In Available Data, select a data object design (.datadesign) file to retrieve current data on demand, or a data object store (.data) file to use cached data.
To view the data sets and cubes in each data object, select the arrow next to the data object file name, as shown in Figure 2‑8.
*Available Data displays the data sets and cubes in the selected data object, as shown in Figure 2‑8.
*Select the cube to view the data fields it contains.
*Select a data model to view the data fields it contains.
*Select a data set to view the data fields it contains.
4 In Select Data, in Available Data, select the data object design file or data object store file, then choose the right arrow.
The selected file appears in Selected Data, as shown in Figure 2‑9.
To select a different data object, in Selected Data, select the data object and select the left arrow. Then, repeat step 4. Choose OK.
Figure 2‑9 Current Data Selection displaying the chosen data object
5 In Select Data Set, shown in Figure 2‑10, select a data set or data model to use.
Figure 2‑10 Selecting a data set
Choose OK.
Table Builder appears listing the data fields in the selected data set or data model. Use Table Builder to select and insert data fields in a BIRT design.
How to select a new data set
1 In Report Studio, choose Modify in the left navigation pane, as shown in Figure 2‑11.
Figure 2‑11 Choosing Modify
Select Data Set appears displaying the data set currently in use, and the data sets in the data object you selected earlier.
2 Select a new data set from the list of available data sets. Then, choose OK.
Table Builder appears, displaying the data fields in the data set you selected.
3 Double‑click each field to add it to the report table.