Posts Tagged ‘EPM’
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 MoreView Double Entry Transactions
Ever done an intercompany recharge of costs? The calculation creates the other side of the transaction and you want to see it, but the security set up prohibits you from viewing what you’ve just done. I was confronted with this paradox problem, I had a web form to input intracompany cross charges, but all I…
Read MoreBSO database, calc performance or size management
What to do if the size of your database is getting close to your storage limit, or the performance of a calculation is becoming less optimal because it is running over too many blocks, here is a tip to see where the blocks are in your BSO application. From the Database Properties the total block…
Read MoreCopy Version Snapshot in ASO model
Something that comes up regularly is creating a snapshot of Scenario & Version, often a copy of “Budget” “Working” into “Budget” “Final” and locking the data as read only. Data Copy in BSO In a BSO or Hybrid model it’s pretty straight forward and you’d do something as simple as this: It’s quick, simple and…
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 MoreWhat Breed of Essbase to choose – BSO – ASO – Hybrid
Building a new Oracle EPM Planning application? Or is your old one not working too well?. Either way you’ve got to get the engine room right! The variant of Essbase makes a difference to the user experience on performance.
In the days before EPM Planning SaaS, to get better performance out of the system you could either upgrade the hardware or optimise the software. Now that Oracle has taken control of the hardware in EPM Planning SaaS, there’s only one option left, optimise the software. Within your application the first thing to consider is the choice of Essbase for your use case. So which one do you choose?
This article explores and compares the performance of Block Storage Option(BSO); Aggregate Storage Option(ASO) and the Hybrid, a combination of BSO and ASO and shines a light on what you may want to use.
Read More