System Admin
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 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 MoreUpdate Of Security by File
In this blog I wanted to update Planning Security using file imports. When a dimension is security enabled (see below) and required multiple members to have security applied to them, doing it through the user interface is tedious. This is also true of rules and forms. Import Security Groups First thing to do is add…
Read MoreConfigure Financials Automatically
To all you EPM administrators out there, here’s one job you can automate, the monthly Configuration of the open periods on the Scenario dimension and setting of the “OEP_” substitution variables. One less thing to do each month end…. Save a bit of time. Basically I’ve got two scripts, the first to set the variables,…
Read MoreCombine LCM Migration Files
Recently I had a scenario where I needed to migrate to production updated artefacts from DEV to UAT to PROD. Inevitably through testing there were one or two additional artefacts to go into PROD. Rather than trying to reselect all the artefacts from previous migrations which obviously can be prone to error in an extensive…
Read More