Oracle Analytics Cloud and Server

Same Data Model - Different RTF Templates - How can a template be picked dynamically based on a valu
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
Answers
-
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
Cheers
Fernando
-
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