Categories
Ability to apply functions(SUBSTRING, CONCAT, CAST etc) to the presentation variables used for OTBI
Organization Name
PROVIDENCE HEALTH & SERVICES
Description
A functionality within OTBI analysis, where we can do customization to the titles of these reports. Currently, we can add dynamic titles to these analysis using presentation variables. But functions like SUBSTRING(), LEFT(), CAST etc cannot be used. These functions do not get applied to the presentation variables and considers them as strings(Adding screenshots). Having such a functionality would give more flexibility to edit these analysis according to the requirement.
Use Case and Business Need
In OTBI analysis, we had a requirement where a portion of one of the parameter passed should be prepended to the title of the report. The parameter passed was Review Period Name. The Review Period Name consists of the Year of the Review Period followed by the name of the Review Period.(eg: 2021 Annual Review Period, 2019 Annual Review Period etc.) The Year portion of the name is to be added to the title of the report. We set a presentation variable for this parameter and added this to the title of the report. But this prefixed the entire Review Period Name to the title of the graph. When we applied functions like SUBSTRING(), LEFT() etc, it was not getting applied to these presentation variables. These functions were considered as strings in the title, causing it to display the function name as such in the title.
Original Idea Number: cda90b1b24
