A challenge that is commonly overlooked when upgrading EPM is keeping your upgraded application in sync with your Legacy application after the initial upgrade, prior to go-live. The challenge comes from the requirement to continue day-to-day operations in the Legacy environment during the upgrade project time line. At some point, the Legacy application must be "upgraded." The upgraded application then becomes a snapshot, or a "Point in Time" of the Legacy application; any changes made in the Legacy environment beyond that point must be accounted for in some form or fashion in the new, or upgraded environment and application.
FCCS is the next generation Oracle Hyperion Financial Consolidation Application. There are several fundamental differences in the technical aspect of the FCCS.
Recently Oracle published an article on performance concerns in PBCS titled “EPM Cloud - Can the Capacity of an EPM Cloud Service be Increased?” In the article Kash Mohammadi, VP of EPM Cloud says the underlying compute resources in the cloud are designed for “elastic stability” and memory or CPU issues are very unlikely the cause of any performance issues. Instead customers should look at application design as the most likely cause of performance issues. Oracle provides a tool for reviewing an application’s design call the “Application Activity Report.” This very useful tool provides a wealth of metrics which can be used to identify performance issues and provide a starting point for improving your application's design and performance.
With the latest Oracle Cloud Updates the EPM Automate utility now supports proxy authentication. The EPM Automate utility is the tool used for automating many of the maintenance activities in the EPM cloud. With the 17.10 Oracle Cloud updates released in October the utility has been updated to allow for additional login functionality that support Internet Proxies which require authentication. For more information administrators should check out the latest documentation available from Oracle. New login command information for EPM Automate can be found here EPM Automate Login Commands.
A frequent issue With FDMEE processing is the time it takes to load data into a target system. One issue that significantly slows FDMEE processing is the use of LIKE mapping. If the number of LIKE Mappings gets large then the response time can be overly burdensome and may lead the user to wonder if there is an issue and the system has stopped processing.
Post-upgrade migration of security from one version of Hyperion to another can be challenging. Ideally, security is migrated as part of the upgrade as documented in the upgrade steps, however there are times between the initial upgrade and go-live that requires a second migration, with a large amount of security changing and parallel maintenance either not practical or simply neglected.
FDMEE’s Universal Data Adapter (UDA) allows you to pull records from an external table or view. The UDA can be utilized to connect to a source database’s table or view when a standard FDMEE adapter is not available. When defining the UDA as a Source Adapter, filters can be applied by configuring parameters on “Parameters” tab.
When working with a client reporting frequent slowdowns in copying of data between schemas, we asked the DBAs to investigate, as well as the UNIX team. Both teams reported that the individual database servers were performing fine, with plenty of resources available to them. However, after a number of conference calls, we overheard one of the team members say their HOST server was at or near 100% CPU usage and had been for some time. As the host was an Exadata 3 server, we had not anticipated we would be subject to shortages of system resources. Unfortunately, without visibility on the host server, we had to rely on reports from the teams maintaining the individual instances. Without us asking specifically for a screenshot of the host server’s performance statistics, we would not have been able to certify the issue was with the database server after all. As always, trust, but verify.
Oracle bundles an installer for WebLogic with their Oracle EPM suite of products, that ‘phones home’ to Oracle for more information. Many of us deal with clients who have firewalls that may block all attempts to communicate from the installation server to Oracle.com or other outside Internet addresses. In these cases, the installer for Oracle EPM informs us of the communication error and asks us to provide proxy information for the installer to communicate with Oracle.com. Refusal to grant the proxy information results in another nag screen after which we can move on with our installation.
When you create a new Essbase application, one task that needs to be performed is creating substitution variables. This is usually done one at a time, selecting the application, selecting the database, entering the variable name and the corresponding value. This task gets really tedious when there are so many to add.