I am happy to announce that Tools-EPM has been released!
Tools-EPM provides various command-line based utilities that simplify the daily tasks of an
technical EPM consultant/engineer.
Read all about it here.
Thursday, September 22, 2016
IntroductionPersonally I never paid attention to specific UEFI (Unified Extensible Firmware Interface) settings when installing and configuring EPM. It was always on factory default values. During a project however, I was triggered to have a look at these setting due to an issue I could not explain.
What I discovered, came as a big surprise to me!
Monday, July 4, 2016
IntroductionIf you ever had to publish Planning utilities for administrators in e.g. Terminal Server or Citrix, you experienced the difficulties of doing that. Planning utilities can only be executed on the server where Planning is installed. Solutions to provide access to these utilities range from full administrative (RDP) access on the Planning server to PowerShell scripts using remote execution. In my experience non of these solutions are ideal and at best cumbersome to maintain.
Already for a few years I though: "There must be another way".
... and now there is!
Monday, May 9, 2016
IntroductionProbably most of you who worked with EPM Architect before faced the situation where an application in EPMA is in a corrupted deployment state and cannot be deleted properly from EPMA the usual way, or EPMA complains that the application already exists while attempting to recreate the EPMA application you deleted.
In most cases running diagnostic against the application would get you back on-track. If not, as a last resort you can drop all tables from the EPMA database by re-configuring the EPMA data source. However in most cases this is not an option.
If you have manually removed all references of the application in all EPM components (how is out-of-scope of this post) and still you cannot re-create the application in EPMA, consider using my SQL script below to ZAP! that orphaned application from the EPMA database.
Geek Stuff (FR) - Let's not press a zillion times on "Yes" during FR import through Workspace, right?
Tuesday, May 3, 2016
For those who migrated Financial Report objects using Workspace, will recognize the frustration of having to click "Yes" a zillion times during import.
For those who got spared so far: When LCM is not an option to migrate Financial Reporting objects, you have to use Workspace to export from the source and import in to the target environment. Sadly Oracle still didn't builtin a "Yes to all" option for some of the import activities, resulting in many manual clicks on "Yes" for sometimes over an hour.
Below you will find a solution to automatically click "Yes" when needed.
Monday, April 11, 2016
IntroductionAs you might know, the latest version (v15) of EPM Maestro by AMOSCA uses a Java Web service to expose the new HFM Java based API to EPM Maestro. As a prerequisite, EPM Maestro Java web service must be installed on a EPM server, HFM Web seems to be recommended by the vendor.
However, for various reasons, you might what to keep EPM and third-party products like EPM Maestro strictly separated.
Never used it? Request a 30 day trial here.