Parsing SOAP request containing multiple datasets

Serg

<p>Hi guys,</p><p> </p><p>I'm building a BIRT report with several datasets. All the data comes from one SOAP response. I can't find the way to share single response between several datasets, so I have performance issue. I need to execute the same request as many times as datasets it contains.</p><p> </p><p>Sample XML, each <table> tag should be placed into a separate dataset.</p><pre class="_prettyXprint _lang-xml"><root> <tables> <table name="table1"> <row> <cell name="id">123</cell> <cell name="caption">Text</cell> ... </row> <row>...</row> </table> <table name="table2"> <row>...</row> <row>...</row> </table> ... </tables></root></pre><div>Example of used XPathes:</div><div>for rows</div><div><pre class="_prettyXprint _lang-nocode">/root/tables/table[@name='table1']/row</pre><p>for columns</p></div><div><pre class="_prettyXprint _lang-nocode">/cell[@name='id']</pre></div><div> </div><div>I'd be glad to hear any solution of my problem.</div><div> </div>

kclark

<p>How are you bringing the data from your SOAP response to your other data sets?  I haven't tried it yet but why don't you create a scripted data source from your SOAP response.  This should only be executed once.  After you have it as a scripted data source then you can join the data to your other data sets.</p>