Add substitution formulas and cube values inside text or RTF cube
Use Case: Publishing Financial Reports and Budget Books with Narratives Using Board Presentations
When preparing an annual financial report, customers often need to create narratives referencing fiscal years, specific financial figures, and business unit data. These narratives must be accurate, consistent, and easily updated to prevent errors.
Currently, the Board Office Add-in supports this requirement; however, many customers prefer using Board Presentations functionality due to its enhanced security, auditability, and formatting capabilities for financial statements.
Challenge
A key limitation in Board Presentations is that narratives entered by multiple users are stored in RTF (Rich Text Format) or text cubes, which do not support substitution formulas and cube values. This means users must manually update repeatable content (fiscal Years and key financial metrics: total revenue/expense for business units XYZ, etc.). Since these updates are done manually, there is an increased risk of inconsistencies and errors, particularly when financial data changes frequently.
Potential Solution
Enabling substitution formulas and cube values (like Field Object in Board Office Add-in) within RTF/text cubes would allow for dynamic updates of key financial values and business entities, improving efficiency, accuracy, and consistency in financial reporting.