How to Write a Calculation Script in Oracle Essbase

This Performance Architects How To discuss how to write a basic calculation script in Oracle Essbase.

[@TheRealWildCarl]

I'm an admin at my company, and I've been looking for years for something like this. I took a full oracle class for database admins, but it wasn't no where near this concise! I've always steered away from creating custom business rules, but feel it is a must for me to fully develop as an admin. -FCCS/EPM/EPBCS Admin.

[@MLFranklin]

I just discovered this video. Very clear and helpful! Just the right level of detail. Thank you for creating them. I need to make a script for forecasting that takes into account elements of arrays for many prior periods. In Excel I use Sumproduct(), and manage the indices with normal Excel syntax $. Simplified example... For 2017 I need to calculate + A(2016)*B(2016) + A(2015)*B(2015) + A(2010)*B(2010). For 2018 I need to calculate + A(2017)*B(2017) + A(2016)*B(2016) + A(2010)*B(2010). For 2019 I need to calculate + A(2018)*B(2018) + A(2017)*B(2017) + A(2010)*B(2010). Note the pattern where the first two multiplications of each year use the previous two periods, while the third term is fixed. Is there a structure within the Essbase scripting language that allows you to create a loop (for/next, do loop do while, and so on) and then increment the indices to perform calculations on the right elements within the array?

[@Juan-Hdez]

Very useful. Thank you.

[@rekhapons3400]

Hi Jon, need help - I need to write a calc script I need to copy cy15 budget into another scenario as cy 15 budget gbp but divide the cy15 budget data by 1.6 please help and very urgent thank you so much in advance