Same Data Model - Different RTF Templates - How can a template be picked dynamically based on a valu

Bipul Shukla-179455

Summary

Same Data Model - Different RTF Templates - How can a template be picked dynamically based on a value in the Data Model?

Content

I know dynamic text control can be done using IF-ELSE logic in the RTF template.

But the templates that I have are huge contract templates and multiple of them. So what I ideally need is dynamic RTF template selection based on a value from data model.

 

Any ideas?

Version

Oracle Business Intelligence 11.1.1.9.0

FPonte

Hi Bipul.

The only way I think this is possible is using SubTemplates together with an IF-ELSE statement in a master template.

Check this.

Calling a Subtemplate from a Main Template

https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-43E24DE3-F1DE-47E1-8B2F-C8ED59D619BA.htm#BIPRD3064

Cheers

Fernando

Bipul Shukla-179455

All,

I utilised Bursting SQL - put a decode 

 

decode(hapf.ATTRIBUTE8, 'Value1','TEMPLATE1','Value2','TEMPLATE2','VALUE3','TEMPLATE3','VALUE4','TEMPLATE4') as TEMPLATE,

 

Scheduled one of the template report based on the same DM to get correct templates.

 

Regards,

Bipul