Keeping up with EPM Cloud

Recently, while implementing Oracle Planning Cloud for a new client, we experienced an issue where attribute dimensions were not being deployed successfully to the underlying Essbase cube – which was definitely not ideal! As we had never experienced this issue before, we opened an SR with Oracle, and (long story short) the issue was occurring because we had unknowingly used a restricted word as a member name and also had trailing spaces in a couple of aliases. Once we removed the restricted member names/aliases, the attribute dimensions were successfully deployed during the refresh. Unfortunately, these restricted members do not show as an error when refreshing the database, even if used in the outline, so hopefully this is something Oracle can add either as an error or as a warning on the Activity Report. In the meantime, it’s worth double checking the naming restrictions, especially if you seem to be experiencing some strange behaviour with Essbase. Some of the main restrictio...

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