1. Designing and Publishing Pixel-Perfect Reports in Oracle Analytics Server
  2. Model Data for Pixel-Perfect Reports
  3. Create Datasets
  4. Create a Dataset Using a XML File

Create a Dataset Using a XML File

You can use an XML file to create a data source.

Do one of the following:

  • Place the XML file in a directory that your administrator has set up as a data source.

  • Upload the XML file to the data model from a local directory.

To use layout editor and interactive viewer, save sample data from the XML file source to the data model.

About Supported XML Files

Support of XML files as a dataset type in Publisher follows certain guidelines.

  • The XML files that you use as input to the Publisher data engine must be UTF-8 encoded.

  • Do not use the following characters in XML tag names: ~, !, #, $, %, ^, &, *, +, `, |, :, \", \\, <, >, ?, ,, /. If your data source file contains any of these characters, use the data model editor Structure tab to change the tag names to an acceptable one.

  • Use valid XML files. Oracle provides many utilities and methods for validating XML files.

  • There's no metadata available from XML file datasets, therefore grouping and linking are not supported.

Upload a XML File Stored Locally

You can create datasets using locally stored XML files.

To create a dataset using a XML file stored locally:
  1. On the toolbar, click New Dataset and select XML File.
  2. Enter a name for this dataset.
  3. Select Local to enable the Upload button.
  4. Click Upload next to the File Name field to browse and upload the XML file from a local directory. If the file has been uploaded to the data model, you can select it from the File Name list.
  5. Click Upload.
  6. Click OK.
  7. (Required) Save sample data to the data model.

Refresh and Delete an Uploaded XML File

You can refresh and delete uploaded local XML files.

After uploading the file, it's displayed on the Properties pane of the data model under the Attachments region, as shown below.

Description of xdo11g_xml_edit2.gif follows
Description of the illustration xdo11g_xml_edit2.gif

To refresh the local file in the data model:

  1. In the component pane, click Data Model to view the Properties page.

  2. In the Attachment region of the page, locate the file in the Data Files list.

  3. Click Refresh.

  4. In the Upload dialog, browse for and upload the latest version of the file. The file must have the same name or it won't replace the older version.

  5. Save the data model.

To delete the local file:

  1. In the component pane, click Data Model to view the Properties page.
  2. In the Attachment region of the page, locate the file in the Data Files list.
  3. Click Delete.
  4. Click OK to confirm.
  5. Save the data model.