Over the years we have featured numerous posts on technical how-tos, tips & tricks and insights from our consultants out in the field. Going into 2018 we are looking forward to expanding on our topics and will include more business-process articles, client successes, event presentations and more! And in case you missed some of these, we thought you might like to see what the most popular technical posts have been to date:
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.
Though normally used primarily for management of financial master data, Oracle's Data Relationship Manager may be able to help your organizations technical documentation strategy. The software’s ability to: import data from sources systems; supplement and augment that data; govern such updates; and export the data, makes it a perfect tool to be your central repository for technical documentation across your organization.
At the earliest levels of athletics, coaches are asked to teach players the basic tenets of teamwork, sportsmanship, and developing fundamentals. At the highest levels, however, coaches are tasked with leading a team to success, oftentimes being some sort of national or professional championship. As the participants gain experience and their skill-sets become more refined, the roles of the coach change. In the beginning, we are teaching new fundamentals and skills, trying to stoke a passion for a sport in a young, impressionable mind. At the highest levels, the coach must rely on their experience and expertise to put their team and players in a position to be successful.
Recently I had a client decide to implement a major architecture change to their production environment. Of course, this change was going to be made to their production environment, during financial close, and on a weekend. As managers of EPM Systems surely know, there is no ‘good time’ to push major system changes. In this case, the change was moving all the EPM components to a new database (DB) server.
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.