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.

Note: When you run a query in unformatted mode, the results will still display formatted date values. Date values will always be displayed in the local time for the user in Meridium Enterprise APM; however, if you export the unformatted query result set to a file or dataset, the exported date values will be unformatted, and will differ from those seen in Meridium Enterprise APM.

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. If you select the same name and location as an existing dataset, that existing dataset will be overwritten when you save.

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 query result set has been exported to a dataset.