XmlTree Extract

image_pdfimage_print

This extract is used to read XML data from files and web services in a hierarchical form. As XML is a markup language for hierarchically structured data, the Xmltree extract is a natural choice for representation when the hierarchical aspect of the data in an XML document dominates. in this case, it may be more convenient than the tabular-based XML extract.

The whole XML document is extracted and handled internally as a tree. The tag name, the attributes, and parent-child-relations of an XML element is transferred to a tree node.
The result can be further transformed with tree-based components (e.g. Transform TreeJoin, TreeView) or be loaded to a dimension or another XML file (with Dimension load or XMLTree load).

Advanced Settings

The following three settings are necessary due to differences in the tree representation between an XML document and a Jedox Integrator tree:

  1. A Jedox Integrator tree requires unique names for tree nodes.
  2. A Jedox Integrator tree node doesn’t have content like an XML element; it only has attributes.
  3. XML tag names cannot contain certain characters, e.g. a space is not allowed.

The following settings allow an XML document to be transferred to a tree-based source.

Advanced settings

XML element to Tree attribute

Specifies the attribute of the resulting tree node to which the tag name of the XML element is written. If not set,  Tree Attribute “_OrigName” is used as default.

XML content to Tree attribute

Specifies the attribute of the resulting tree node to which the content element of the XML element is written. Since a Jedox Integrator tree node doesn’t have content like an XML element, this option allows the content to be saved in the Jedox Integrator tree.

If the XML document contains elements with Element content and this option is not set, then the tree attribute “_OrigContent” is used as default.

Tree element from XML attribute

If set, the element name of the resulting tree is taken from the specified XML attribute.

As a Jedox Integrator tree requires unique names for tree nodes, the XML tag name cannot be used for it in most cases.

Special values:

:element: The element name of the resulting tree is taken from the XML tag name
:content: The element name of the resulting tree is taken from the XML element content

If not set, a unique name for the tree node will be generated in the form LN. For example: CustomerL2N5

 

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...