Dimension Member Count Matrix
When managing a system it is useful to have a table of dimensions and the cubes that they are valid in like the example below. The numbers are a count of the members in the dimension that are valid for that cube. To get the grid, I have a groovy script to produce the CSV…
Read MoreDelete Multiple Reports
How to delete a reports folder with multiple reports in it without having to delete each report individually. You can go into navigator→forms it shares the same folder structure as reports. In my installation these folders have no webforms and appear empty in the “Form and Ad Hoc Grid Management” You can delete the folders…
Read MoreManaging Files and Folders
Housekeeping of files in the instance can be an unwieldy task. I’ve a couple of scripts to identify a list of files and another to delete files. Moving files produced into a default folder to the desired directory, I use a Pipeline process where the target folder can be changed from default. Finally some scripts…
Read MoreA Notation for Variables
Setting up variables in EPM for Substitution, User Variables or Run Time Prompts without some forethought beforehand will lead to a proliferation of variables, the use of which can become obfuscated and can become redundant without anyone noticing. This article is my naming structure to pre-empt these problems. Often when I’ve seen EPM systems, variables…
Read MoreASO Copy Actual to Forecast
In Planning a common requirement is to actualise the forecast with the latest actuals. This blog is a groovy script that will clear the Actual set of periods from the Forecast e.g. Jan to Jun for the current year and then copy the same periods from the Actual Scenario into the Forecast. It is an…
Read MoreHousekeeping in your application and how to list all your artefacts.
I was going to do some housekeeping and clear out a load of unused forms, 328 of them to be precise. The first job was to identify which forms are in use, I used three approaches: 1. Get a full list for forms and folders 2. From the audit log, export data changes for 180…
Read MoreReinstate the Workforce/Financial Module Artefacts
I was having an issue with an Oracle pre defined calculation in Workforce Planning that had been updated by introducing a modified variable run time prompt, but the artefact no longer worked as it was at least 3 years out of date. I needed to get back to a state where EPM recognised that it…
Read MoreWeb Form Calculation Formula
Sometimes it can be advantageous to embed a formula into a Web Form rather than include it in the database. Such circumstances may be when the use case for the formula is so specific it doesn’t warrant putting into the database, or it is a variance of two columns that are different scenarios set by…
Read MoreEPM Reports – Getting Started
This blog was just intended as a quick start guide to EPM Reports, but now it also has tips for extracting Cell Comments, Supporting Details and Cell Attachments. While compiling the notes, the feature to get the Cell Comments that users enter in Web Forms and Smart View provided a way of extracting all the…
Read MorePeriod End Average Selling Price
To calculate an average price in the Year_Total/Total_Period member is quite straight forwards if you’ve got your period hierarchy as dynamic calc. It just needs a forumula. It doesn’t need to be a Two Pass calculation member. The ASP (Average Selling Price) member in my model has the following properties: The time balance and account…
Read More