Generating HTML format of WebI reports Based on sections

[shiva09]

HI,

Currently one of our BO DWH is on BO 3.1 and we are using Deski Report.
Reports have been sectioned based on ID.

Let say Region Reports: Section: Region ID
Post refresh: We can a Single Report generated (section wise pattern).
On the same deski report: A macro has been written to break the Single report in section wise and generate HTMLs for each section.
Example: If there are 5 regions / 5 sections on deski report, then 5 HTMLs would be generated; one for each section.

Now we are going to Migrate to BO 4.x. As deski/Macro won't be supported. Request you to help us with alternative.

1. Is there any direct SDK to perform the same ?
2. Is there any workaround / alternative apart from SDK ?

Thank You.
Shiva.

[amitrathi239 · Accepted solution]

Check attached link for how to use Publication.no need to add prompt for burst report section wise.Check Dynamic recipient section in attached link for to burst.

https://blogs.sap.com/2014/01/07/create-publication-to-schedule-webi-report-to-dynamic-recipients/

mHTML format is available in Format part of Publication.

[shiva09]

Hi Dell,

Thank you for the response.
However, on reports there is currently no prompts.
> Do we need to apply Prompt first, to burst those sgment wise ?
> How to set the format as HTML ?

[DellSC]

Have you looked at using a Publication? Basically, you would create a Webi or Crystal report to replace the Deski report and then configure a Publication to run the report and "burst" it by section.

-Dell