Top 5 EPM Report Text Functions
When building Reports in Oracle Cloud EPM Planning or FCC, text functions can be utilised to expand the report beyond a simple grid format and give added context to data. Text functions can also be used to surface additional information, including attributes, UDAs and cell commentary. Functions are access via the dropdown at the bottom of the Member Selector : Here are my top 5 text functions to use when creating EPM reports: 1. CellText Purpose: Surfaces the cell comments for a specified cell Example: Use this to report on variance commentary which is entered as a comment on a cell Syntax: CellText(Row,Col) where Row/Col are optional Benefits: · Cell comments can be entered against any member combination, which can then be surfaced for reporting · Comments add context to data for reporting · Allows comments to be held in the system, rather than offline, and surfaced in reports 2. MemberProperty Purpose: Reference a range o