I have the following requirement in BI 4.0 SP5 environment.
A webi report needs to be scheduled with a prompt value and saved in a file server. The report has a prompt on a object named
[Fund #]
The object [Fund #] has 5 LOVs . So the report has to be run for all the the prompt values, that is 5 times and 5 copies should be saved as 5 separate PDF files in a file location.
The number of LOVs are not constants. It is possible at some point of time that [Fund #] will have 10 LOVs. In that case the same webi report needs to be run for all the prompt values that is 10 times and 10 PDF files should be saved in a file location.
How can this be automated ?
Using profile in publication is not an option, because the LOVs are not constant in number. Can this be achieved using a java script as a program object rather than using SDK directly ? Please let me know all the possibilities.
You can do what you describe using a publication with Dynamic Recipients.
Try this:
Remove the prompt from the parent report. But make sure Fund # is included in the query as a result object. Let’s call this Report1.
Create a new report. Select the Fund # object in Results, and give it any conditions that are appropriate. This is what will generate the list of values to filter the output with.
Save the new report report with “Refresh on Open” set (this is a requirement in Xi3.1 to prevent failures when scheduling; it may not be necessary in BI4). Let’s call this ReportList.
Create a new publication. Select Report1 as the source report.
In the “Dynamic Recipients” tab, select ReportList. In the “Recipient Identifier” field, select the “Fund #” object.
Make sure “Use entire list” is checked off.
On the “Personalization” tab, under Local Profiles, under “Report Field”, select Fund #. Under Dynamic Recipient Mapping, also select Fund #. You’ll leave Enterprise Recipient Mapping as “Not Specified”, and you will ignore the “Global Profiles” section above. In this section, “Report Field” is the field that the condition will be applied to (from Report1), and Dynamic Recipient Mapping is the field that contains the values to use (from ReportList).
On the Format tab, select the format you want for the generated files.
On the Destinations tab, check off “File System”, then select “File System” from the drop-down box. Enter the directory for the generated files.
Under “File Name”, select “Use specific name”, and enter “%SI_OWNER%.%EXT%”. The “%SI_OWNER%” will be replaced with each value from Fund #. You can change this field as needed. For example, “Report for %SI_OWNER%.%EXT%”
Schedule the publication just as you would a report.
FYI, a Java program object is using the SDK. But to answer your question – yes, you could write a program to do this.
We don’t have individual points here on BOB, but there’s a star icon (look over to the right and down). You can click that to give this thread a point, to indicate to others that it’s helpful.
Hi, Am trying to schedule a report which has date as the prompt and this needs to be dynamic in nature. is there any possibility to pass this date logic to the prompt in the publication?
Report prompt comes from the universe: So this is undeniable.
Tried magic date concept of dave. but that dint work.
what is the criteria to create the second report? whether it should contain same objects as the original report?? along with the date logic or anything.
Iam using 3.1 and when i tried to put the date object in the new report and add it in the dynamic recp it says " Invalid report"
There fore not able to try ur suggestions completely.
Original Report: Has a prompt from universe. Which is undeniable.
Report1: Created to include the date object.
I have included sysdate as an object in my report1.
So this sysdate should be passed to original report prompt so that report runs for SYSDATE.
The workaround you provided is not working as expected. Just it is getting failed without any error. Following steps followed, could you help me furher?
BOXI3.1 SP5
Apache2.2/Tomcat7
Created the Report called “Dynamic_Group_Details” which has collection of required objects including “Group Name”.
Created the another report called “Dynamic_Group_Input” which has “Group Name” object in report query.Selected “open on refresh”
Created the new Publication, selected the source as “Dynamic_Group_Details”
“Enterprise Recipients” -> Didn’t select anything
In the “Dynamic Recipients” tab, select “Dynamic_Group_Input”. In the “Recipient Identifier” field, select the “Group Name” object. And unchecked “Use entire list”. There was list of group and selected those to “Selected” box.(Tried by selecting/ without selecting as well)
On the “Personalization” tab, under Local Profiles, under “Report Field”, selected “Group Name”. Under Dynamic Recipient Mapping, also selected “Group Name”. I left Enterprise Recipient Mapping as “Not Specified”, and ignored the “Global Profiles” section above.
On the Format tab, selected the format pdf file.
On the Destinations tab, tried as file system and Email. Those just getting failed without any error message.
(BOB member since 2012-01-27)
(BOB member since 2002-08-29)
(BOB member since 2002-08-29)