Posts Tagged ‘Planning’
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 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 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 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 MoreAccess to Multiple Environments in Excel Smart View
A super quick post about a tip I got a few years ago on an easy way to manage access to multiple environments in Excel Smart View. The reason for going to post is that it surprises me how often that I come across people that have not seen this, so here it is. How…
Read MorePerformance step up for @PRIOR
I wanted to test the performance of using @XRANGE with @PRIOR verses using the cross dimensional operator in conditional statements to see how much performance could be improved.
Read MoreData Extract with Ancestor Meta Data
From time to time requirements to publish meta data along with an extract come up. I recently had a requirement to produce an extract with column headers a bit like this: This was two dimensions, the bottom row is just level 0 members, the second row up is level 0 members with parents, grandparents &…
Read MoreLoading Multiple Accounts Using Logic Groups
In this blog, I have a file that I needed to parse twice in order to populate six account members by filtering on different subsets of the data. One approach could be to create two data load rules and have scripts to run them, basically reading the file twice. Alternatively, by using “logic groups” the…
Read More