Groovy – Run a privileged SmartPush
At the beginning of May, Ahmet has published a really interesting article Run Privileged Functions With Non-Admin Users which I highly recommend as I believe you could have so many applications for this to...
Groovy – Automate User Variables
Who loves those error messages ? While user variables are providing a great mechanism to increase user experience, initial setup of user variables are always problematic in a way that it can slow down...
Groovy – Realtime Access to External Tables.
Groovy and RestAPIs combined together provide a big array of possibilities. I will walk you through in this post how to connect to an external table, read records from it and add new records...
Groovy – Run Privileged Functions With Non-Admin Users
Privileged MethodSome methods can only be called by a user with certain privileges. For example delete() on Member class, saveMember() on Dimension class, execute() on DataMap class, setSubstitutionVariableValue() on Application and Cube classes will...
Groovy – Use Force to Edit Read-Only Datacells
In this simplified scenario, suppose you have following form where you have products in the rows and Measures in the columns.
Revenue is a dynamic calc member calculated by multiplying Unit and Price members with...
Groovy – Filter by Attributes
Another strong advantage of groovy scripting is that you can access application dimensions and create dynamic list of members that your algorithm requires on the fly. It is quite easy to access list of...
Groovy – Send Emails from Business Rules
I wanted to explore sendmail option, test how it looks and give a few ideas in terms of how it can be utilized in EPM applications space. I started with a RestAPI client to...
Groovy – Manage Approvals – Part II
After receiving lots of positive feedback for my previous blog, “Groovy – Manage Approvals”, it is time to get on with a bit more about Groovy combined with RestAPI resources to manage approvals.
In certain...
Groovy – Manage Approvals
Using approvals basically allows you to monitor and manage your workflow within the specified process. Approvals help you manage the corporate planning process and gives you chance to formalise approval authorities with using validation...
Groovy – Excel.NPV – Net Present Value
Starting from September 2020 release (20.09), you can now call Excel financial functions in Groovy. This is great news, this means Groovy scripts will be more powerful. Excel functions are very rich and can...
