Keeping up with EPM Cloud

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 ·       ...

When building Reports in Oracle Cloud EPM Planning or FCC, member functions are an incredibly useful way to make reports as user-friendly as possible. Including functions can also help to make reports more dynamic and reduce any required report maintenance going forward. Functions are accessed via the dropdown at the bottom of the Member Selector : Here are my top 5 member functions to use when creating EPM reports: 1. CurrentPOV Purpose: References the current point of view selection for a dimension Example: Allow the selected Scenario to be visible both in the POV and on the report columns Syntax: CurrentPOV Benefits: Allows the user to change the selection at run-time, making the report more dynamic CurrentPOV can be referenced in other functions to reduce required selections POV choices can be restricted to only valid selections 2. Bottom Purpose: Retrieve the level 0 relatives of a selected member Example: To see all bottom level account codes only Syntax...