Groovy
Discussion List
-
Could Filter based on data values using GroovySummary: I would like to export data from to csv using groovy, but specific data value should be exported Content (required): Hello All, I have a requirement to export d… -
Has anyone worked on Groovy script for importing dimensional security into EPBCSSummary: Is it possible to import dimensional security into epbcs using groovy? Version (include the version you are using, if applicable): Product name EPBCS Version: 2…User_2025-03-10-22-57-31-218 161 views 3 comments 0 points Most recent by User_2025-03-10-22-57-31-218 Planning -
How can I make unique combinations of dimensions for changed cells ?Summary: All the examples I have found are using operation.grid.dataCellIterator({DataCell cell -> cell.edited}).each{ for one single dimension. I have a combination of … -
Groovy Code to Determine Valid IntersectionsSummary: We have a valid intersection to define the business unit for each department (every department belongs to only one BU). To make business rules more efficient, w… -
How do you surface the currently running business rule's Job ID?This should be really simple but I can't seem to work it out. I initiate a business rule which uses REST API calls to kick off multiple child jobs. At the moment, these … -
Has anyone used EPM Automate commands from Groovy (aka Server-side EPM Automate)?Summary: I'm working on a banking project where we have restriction to download/install EPM Automate, so we are trying to leverage EPM Automate from Groovy without insta…
-
[EPM Automate via Groovy] Error capturing when status code equals 0Summary: I am trying to have a Groovy rule show as "Error" in a job where, even though it runs "successfully" and shows a status of 0, it still has errors/warnings that … -
Groovy - Accessing Attribute Dimension MembersHi, We were doing some testing today and were trying to use .getEvaluatedMembers to access attribute dimension members (similarly to accessing dimension members using th… -
Groovy Sum of two columnsSummary: Groovy to check sum of two columns Content (required): Hi, I want to use groovy to check if sum of Dr. column is equal to sum of Cr. Column and if not then thro… -
Extract or download cell attachmentsSummary: Looking for a way to systematically download cell attachments Content (required): I'm trying to find a way to systematically download cell attachments. I don't … -
Groovy to update an Alias based on text account?Content Hi, has anyone written Groovy to update an alias of a member from one dimension based on text entered into a text account? I've read a lot of public Groovy how-t…
-
Has anyone seen a issue with Groovy BR loadGrid filterMembersWithNoAccess?Summary: Expecting the data grid to load cells ignoring user security because loadGrid filterMembersWithNoAccess = false but user running rule does not pull the data for…
-
Using Groovy to Trigger a Data Management BatchSummary: Content (required): similar to the question posted here how to trigger data management rule in PCMCS using Groovy in Planning — Cloud Customer Connect (oracle.c…
-
Can I use a range of Periods in a groovy script that pass parameters to Data MapsSummary: I need to use a range of Periods in a groovy script that pass parameters to Data Maps Content (required): I wrote the following groovy script to pass parameters… -
What's New in 21.08?Summary More cool things plus some favorites of mine!Content Well, here we are again and I'm back on my normal release date as 21.08 is set to hit your test environments… -
Right click to a form with level0 members of the chosen parentSummary: I want to create a high level review form where user can right click on the selected cost centre parent and go to a form that only shows the bottom level cost c…
-
Assigning a variable to a text member using EPBCS groovyContent (required): Hi guys! I am facing a small issue in assigning a variable which contains text using groovy. I have an array named "Teachers" which contains staff na…
-
Groovy how to get member combinations from DataGridSummary: Content (required): Dears, I am looking for a way to get member combinations from a Datagrid, for instance: builderUnit.addRow(['Unit', 'Account'], [['Lvl0Desce… -
Delete file REST API - GroovySummary: Has anyone successfully used the Delete Files (v2) API in a groovy business rule? Content (required): I am able to make the API call from Postman. However I kee…
-
Can we delete attribute members via a groovy script?We have a requirement to delete attribute members and are wanting to do this via a groovy script, however can't seem to find a method to do this - has anyone done this b… -
Groovy REST sendmail fails with "IOException while sending message"Summary: Groovy rule to sendmail via REST. The request works fine in that it is passed through the connection. But the email never arrives. Checking the status returns s…
-
Unable to get current rule name in groovySummary: Trying to get the name of the current rule in groovy. Getting generic error: Script failed on line: 522, with error: An error occurred while processing this pag…
-
check whether member is descendant of any parent in groovySummary: how to find the the member is a descendant of any parent in groovy Content (required): How can we check whether selected member from pov is a descendant of any …
-
Send Email REST API Stop Working from Last FridaySummary: Send Email REST API Stop Working from Last Friday in Prod Content (required): I have noticed that from multiple clients. Using REST API to trigger send email st…
-
get a parent members in a list for list of lvl0 members in groovySummary: get a parent members in a list for list of lvl0 members in groovy Content (required): I have lvl0 members in list extracted from flexform need to create another…
-
Test on smartlist value in groovySummary: hi all, Test on smartlist value in groovy Content (required): Is it possible to test on a smartlist value in groovy. We want to make cells read only if a cell v…
-
Restore Backup - Rest API Status CheckingHi, Has anyone here used the Restore Backup functionality via Rest API? We have successfully been able to use it via groovy business rule in one of our planning apps, bu…
-
Invoking a Cube Refresh via Business RuleSummary I am trying to create a business rule that executes the Cube refreshContent I am trying to create a business rule that executes a cube refresh. I have created a …
-
Groovy - Acting on Edited Cells IssueHi, We are running a basic groovy rule on save to act only on edited cells. The form in question is a spin off of the OOB expense trending form, but with additional dime…