Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
XML Data Source Optimization
Migrateduser
Hi,<br />
<br />
I'm struggling to get data in from large XML data sources having to wait sometimes 5 or 10 minutes for a report to generate because of nested tables, etc. Is there any way to script a data set to use an XML data source and programatically iterate through sub elements as needed, instead of nesting entire tables? For example, if I have a customer which may have multiple emails and addresses, the XML is currently<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<customer>
<first_name>
<last_name>
<addresses>
<address>
<address_1>
<address_2>
<city>
...
<address>
...
</addresses>
<emails>
<email>emailaddress@gmail.com</email>
<email>another_address@gmail.com</email>
...
</emails>
</pre>
Right now I have to iterate through emails as one data set/table, addresses as another data set/table, and then have an outer table with the top level customer information, which takes quite a while to parse through about a 20 MB file.<br />
I'd like to program the fetch method of the data set to automatically iterate through each address/email as they appear. Is this possible? Do I have to script a data source as well? How do you script a data source to pull in the exact same XML data?
Find more posts tagged with
Comments
There are no comments yet