Posts Tagged ‘Planning’
Web 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 MoreUser Cloud File Access
I have a Groovy script that produces a text file on demand, executed by a power user. The user then needs to download the file for downstream offline activity. However they couldn’t access the file output. So the question was how to get a file from the Inbox/Outbox folder, the default folder for all API…
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 MoreOptimising Cost Allocations in Hybrid Essbase
How good is the Oracle EPM Hybrid Essbase for doing cost allocations? Surely it would be hampered by having to keep recalculating the total cost dynamically every time the allocation formula ran, i.e. 1000’s times to the members that you want to allocate to.
In this post I look at using an ARRAY and other options within a calculation script, leverage the power of Groovy in a combined Calculation/Groovy script and evaluate a total Groovy option in Hybrid and ASO. I uncover what doesn’t really work at all, how a basic allocation performs, and how to optimise the allocation to take the calculation time from minutes down to a few seconds, all with working code examples from my test application.
Read More