how to change Email Subject Name Dynamically based on prompt values in BI Publisher while Scheduling

Question

Hi All

I am scheduling a BI Publisher report in OBIEE11g. The report is having Month Prompt eg. APRIL-2014. While scheduling the Report, can we take this Prompt Value inside the Email Subject Area dynamically?

For Example, The Email subject is "Region wise Sales". But User wants to have the Email subject like "Region Wise sales For APRIL-2014", as APRIL-2014 is the Prompt value.

Rahul Motaparthi · Answer

Hi,

Try bursting the report. Create a bursting definition for the report and you can use your parameter in the subject name.

Thanks,

Rahul