Posts Tagged ‘Planning’
User 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