Exporting Query Results

You can export the data specified in the Query Manager section to a CSV or XML file.

Procedure

  1. Define a query in Query Manager as explained in Metric and Concept Data Query Using Query Manager.
  2. Click Export. The Query Manager Export window opens.
  3. Select CSV or XML as the output format.
  4. The Depth field is applied to concept queries only. Use it to specify the depth of related concepts to include.

    For example, for customers with orders and line items, you might enter 2 to show the orders for each customer, but not the line items in each order.

  5. In the Per Type Count field, select the number of instances of each metric or concept to export.
  6. In the Overall Count field, select the total count of instances to export. (This can reduce the number of instances of each type below the Per Type Count.)
  7. To include any system fields, check the Include System Fields check box.
  8. Click Export. Browse to the directory where you want to save the file, and name the file as desired.