Oracle Analytics Cloud and Server

Bursting control file to loop through the XML, possible?
Summary
Bursting control file to loop through the XML, possible?
Content
HI : Can Bursting control file include a "looping" though the data from XML and put it into email body?
Here is my situation. we are in EBS 11.5.10.2 with BI publisher 5. ( yes sorry, very old )
User has a requirement to put the following information in the email body ( not attachment )
Dear customer : Here is your order
Item description
Apple Fruit
long desk furniture
car transportation
However, here is my XML output
<Order>
<item_detail>
<item>Apple </item>
<description>Fruit</description>
</item_detail>
<item_detail>
<item>Long Desk</item>
<description>Furniture</description>
</item_detail>
<item_detail>
<item>Car</item>
<description>Transportation</description>
</item_detail>
</Order>
I do not aware that I can put a LOOP into the control file........ or I just did not know... Do you?
Answers
-
I can put the data into pdf file. But the requirement is the data shows in the email body .. not a pdf file attachment in the email. If there is a way that I can print the body of the PDF file into the email body, that will work. But I don't know is that possible...
-
Hi,
why do you want to display in the bust subject ? you can provide the data in PDF file right?
I don't think so we have LOOP or not...
-
Please check the following for the complete bursting process
and for your email delivery please check your parameters as below ...
Regards,
Yugandhar