Request a Consultation

CheckPoint Consulting Blog

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.

read more

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.

read more

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.

read more

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.

read more

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.

read more

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.

read more

Task Flows in Classic HFM  11.1.2.4 are interesting beasts. If your clients rely on them to run consolidation packages like ours do, they could be in some trouble. If there is any drop in communication between HFM and Shared Services, your results will not be as desired.

read more

We discovered a few interesting things about consolidation tasks and HFM 11.1.2.4 at a recent client engagement. First, there is no “keep-alive” between HFM and the Oracle HTTP Server, so anything relying on a keep-alive will time out and cause issues later. Load balancers would need to have their keep-alive times adjusted, and OHS would need the entry for WLIOTimeoutSecs in the mod_wl_ohs.conf file adjusted upwards too.

read more

When comparing two roughly-equivalent environments, UAT and Staging, we kept running into a performance discrepancy we were unable to account for. We had the same data, rules, etc. in each HFM application, the same tuning parameters applied, and similar server host capabilities. We could not run a complex Task Scheduler instruction set in the same amount of time in each environment. UAT would take 90 minutes longer to complete the few dozen steps in the Task than Staging would.

read more

Not so long ago an Oracle finance survey found that more than 50 percent of finance managers in global companies specified a lack of visibility into reporting. Many also admitted difficulty in controlling the quality of financial data across the reporting process.

read more