Posts Tagged ‘Calculation’
Period End Average Selling Price
To calculate an average price in the Year_Total/Total_Period member is quite straight forwards if you’ve got your period hierarchy as dynamic calc. It just needs a forumula. It doesn’t need to be a Two Pass calculation member. The ASP (Average Selling Price) member in my model has the following properties: The time balance and account…
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 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 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 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 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