Export a Query Result Set to a Dataset

A query can be exported as a dataset, a fixed set of information that is stored as a Catalog item.

Steps

For the Select query for which you want to modify the output mode, access the Design workspace.
In the upper-right corner of the workspace, select , and then select Export to a Dataset.

The Save As window appears.
In the folder hierarchy, navigate to the folder in which you want to save the query.
In the Name box, enter a name for the dataset. The name is required and must be unique to the Catalog folder in which you are saving the query.

The Caption box is populated automatically with the value that you entered in the Name box.
In the Description box, you can enter a description for the dataset. This is not required to save the query.
The Of type box is populated automatically with the Catalog item type.
Select Save.

The dataset is saved to the Catalog.