Previous Topic  Next Topic

Manage Datasets Dialog Box Properties

This topic describes how you can use the Manage Datasets dialog box to manage datasets in a page report.

Server displays the Manage Datasets dialog box when you navigate to Menu > Report > Manage Datasets in the Interactive View of Page Report Studio.

Dataset List

Server lists all the datasets you have created for the report.

• Name
  Name of a dataset. You can select a name to edit it.
• Data Source
  Catalog data source in which you have created a dataset.
• Business View
  Data resource based on which you have created a dataset.

New

Select to add a new dataset in the report. Server displays the New Dataset dialog box. See the properties in the dialog box:

• Choose Data from
  Select a business view that contains the resources you want to use for the new dataset.
• New Dataset Name
  Type a name for the new dataset.
• OK
  Select to create the dataset and close the dialog box.
• Cancel
  Select to close the dialog box without creating a dataset.

Remove

Select to remove the selected dataset from the report. You cannot remove a dataset when any data component is using it.

Optimize Dataset

Select to optimize the specified dataset. Server displays the Optimize Dataset dialog box. Choose a retrieved data scope for the dataset:

• Only Resources Used in Report
  Select if you only want to retrieve data resources used in the current report at runtime. This way ensures the best performance since the least data is retrieved.
• All Resources in Dataset
  Select if you want to retrieve all data resources defined in the dataset at runtime. Unless you manually added data fields to the dataset, this is the same as Only Resources Used in Report.
• All Resources in Business View
  Select if you want to retrieve all data resources in the business view on which the dataset is based at runtime. This usually leads to lower performance and is not of any benefit unless you expect to often need to add more fields to the report.

Data tab

You can specify the data fields to include in the selected dataset.

• Resources
  This box lists the resources you can use for the dataset. The available resources include all view elements of the business view and the dynamic resources you have created for the business view in the report.
• Dataset Resources
  This box lists the data fields you add to the dataset.
• Add button
  Select to add the specified data field in the Resources box to include in the dataset.
• Remove button
  Select to remove the specified data field from the dataset. You can only remove the fields that are not used by any data component that uses the dataset, either directly or indirectly.
• Move Up button
  Select to move the selected item higher in the list.
• Move Down button
  Select to move the selected item lower in the list.

Filter tab

You can specify conditions to filter the selected dataset. See Edit Dataset Filter Dialog Box Properties for more information about the properties.

OK

Select to apply any changes you made here and close the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

Back to top

Previous Topic  Next Topic