BackPrevious Topic  Next TopicNext

New XML Hierarchical Data Source Dialog Box

You can use the New XML Hierarchical Data Source dialog box to import an XML HDS into the current catalog. This topic describes the options in the dialog box.

Designer displays the New XML Hierarchical Data Source dialog box when you right-click a data source and select New XML Hierarchical Data Source from the shortcut menu in the Catalog Manager.

New XML Hierarchical Data Source dialog box

You see the following options in the dialog box:

XML URI

Specify the location of the external XML data source. It can be a local path or a web URL. Select Browse to find the file on the local disk.

XSD URI

Specify the location of the schema file for the XML data source. It can be a local path or a web URL. Select Browse to find the file on the local disk.

Root Name

This option shows the HDS root, starting from which Designer imports the data.

Structure

This box shows the structure of the hierarchical data source.

Columns

You can specify the column settings in this box.

  • Element
    This column shows the names of the columns in the selected node of table.
  • Selected
    Specify whether to import the column into the catalog.
  • Format
    Specify the format in which to display the column values in the report result. It varies for different data types, and you can manually define the format.
  • Type
    Specify the data type of the column.
  • Precision
    Specify the precision of the column's values. The default value comes from data source metadata and it specifies the column's largest number of digits. The larger the precision is, the more memory it might take; however, the more accurate values you will get.
  • Scale
    Specify the number of digits to the right of the decimal point for the column's values.
  • Nullable
    Specify whether the column is nullable. You have three options to choose: Nullable, No Nulls, and Nullable Unknown.
  • Currency
    Specify whether to use the Currency data type for this column.
  • Array
    Specify whether to use the Array data type for this column.

Load Tree

Select to parse and load data tree from the external data source file. Designer displays the structure in the Structure box after you select this button.

OK

Select to apply your settings 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

BackPrevious Topic  Next TopicNext