Current Position:Home > BI Pub report bursting based on parameters set in interactive dashboard

BI Pub report bursting based on parameters set in interactive dashboard

Update:10-11Source: network consolidation
Advertisement
Hi,
Could someone help me in creating and bursting reports as per the following requirement:
1. there is interactive dashboard with html multi select parameter that has display values department, location, employee job code. user can select one or more column name from this multi select parameter field.
2. need to create a preview button in dashboard, clicking on which display a report on dashboard page showing how many files are generated after bursting and employee count
3. need to create a generate/burst report button to automatically burst a bi publisher report based on the column names that user has provide in step 1 above.
4. how can we capture the parameter values from dashboard and pass to bi publisher report?
5. how can we automatically burst this report based on column names say both 'department-location'?
6. in bursting of report we can split only by one column name but here we need to do based on two or more column names set by the end user in the parameter
-Priyanka

The Best Answer

Advertisement
Thanks for a quick response but I am still not clear on
1. how to do this using custom java code
and
2. actually user would login to interactive dashboard and there he will give these parameters using which we need to automatically burst a BI publisher report. Can this be done some how?
-Priyanka
  • BI Pub report bursting based on parameters set in interactive dashboard Update:10-11

    Hi, Could someone help me in creating and bursting reports as per the following requirement: 1. there is interactive dashboard with html multi select parameter that has display values department, location, employee job code. user can select one or mo

  • Generate report dynamically based on parameters Update:11-30

    I have a Report with 30-35 items and these items are divided into sets of RMA, WIP,Inventory, finance .... now i need to display the report dynamically based on parameters say, for example if RMA, WIP, Inventory, finance are YES,NO,YES, NO then the r

  • Automatic Report Bursting based on column names given by user as parameter. Update:10-11

    Hi, Could some help me achieve the following functionality. The requirement are: 1. create a report that has parameters that are column names (display values e.g: department, location, employee job code) 2. the end user will select one or more column

  • Crystal Report Bursting based on a field in the report Update:10-11

    Hi, I have a crystal report with  Invoice Number as a field in it.  I need to burst the report with following as the output. 1. Destination: FTP server 2.  Format : PDF : One PDF for every invoice. I was trying to use Publication through Infoview.  I

  • Default date parameters to trunc(sysdate,'IW') in BI Pub Reports 11G Update:11-30

    Hi All, I have a requirement to default the date parameters in the BI Pub Report to the following when the reprot is scheduled to run. Start Date - Trunc(sysdate,'IW') - 8 End date - Trunc(sysdate,'IW') - 2 Steps followed: 1. I have created 2 Date pa

  • Dynamic report based on Parameters and a Button Update:11-30

    Trying to make a dynmic report based on Parameters entered.Wanted to refresh report when i click on a button say "OK" based on parameters entered. (1) created 2 text boxes -- Parameters --One date and other employee No (2) on the same page i cre

  • XML Publisher Report Bursting Program (XDOBURSTREP) is failing after ATG7 Update:10-11

    Hello After upgrading ATG RUP7, we have issue related to the XML Bursting Program. XML Publisher Report Bursting Program (XDOBURSTREP Short Name) is failing with error when there is no output is generated by the Oracle Report, this was working fine b

  • XML Publisher Report Bursting Update:10-11

    I have created report using XML Publisher Report Bursting. The output-type of the report is pdf.. <xapi:document output="${PROJECT_APPROVER}" output-type="pdf" delivery="123"> But if I change the format to xls it's show

  • Utilizing XML Publisher Report Bursting Program user-variables Update:10-11

    When running the XML Publisher Report Bursting Program against a bursting control file, I see the following in the log: Bursting propertes..... {user-variable:cp:territory=US, user-variable:cp:ReportRequestID=4413342, user-variable:cp:language=en, us

  • XML Publisher Report Bursting Program ends in error Update:10-11

    We have a report that generates the XML output (ACH notification) In the after report we have a call to the Bursting program. The ACH notification completes with the correct output but the bursting ends in error showing Set Bursting parameters.. Temp