Top 5 EPM Report Member Functions
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