Groovy
Discussion List
-
[Integrations & REST API] Struggling with updating Source Filters via REST APISummary: I am trying to create rules that utilize the REST API to override source filters when running integrations in Planning. Unfortunately, I cannot seem to get the …
-
Download file via an API in Groovy RuleSummary: What is the location on a local computer while downloading a file via an API in Groovy rule ? Content (required): I'm trying to download a file from my EPMEnvir…
-
How to Groovy for copying data in PlanningSummary: Trying to create a script in Groovy to copy data from one scenario to another, so far unsuccessful Content (required): I am running Planning Cloud. For various …
-
Retrieving cell value and posting backSummary: Hi, I have one member called "Counter->No Project" I want groovy to pick value from it and add 1 and post it back. I basically want to use this counter while cr…
-
Can groovy execute when a POV is submitted aka "Go"Hey Groovy experts, Is there anyway to execute code after a POV is selected, and entered? e.g you change multiple members in the POV and then hit the "->" icon. I want t…
-
Download File to a directory from Planning via API / EPMAutomate / GroovySummary: I need to download a file from Inbox/outbox Explorer to the address I want. Content (required): Hello All, Today we can download a file from Planning via EPMAut…
-
Generating a sequential, unique ID for a record/tuple?Summary: Generating a sequential, unique ID for a record/tuple? Content (required): I need to generate a sequential number for a field to have a unique ID for a record. …
-
Export Data using Groovy with Filters and different combinationsSummary: Hello, I need to export data using groovy rule so i have used "exportDataToFile" function to achieve this, also it was required to filter the exported data depe…
-
How can I assign security for a user/group to a dimension member using Groovy rulesHello, I'm new to groovy and trying to leverage Groovy for implementing security for the below scenarios but couldn't find anything useful. (I cannot leverage EPM Automa…User_2025-03-10-22-57-31-218 254 views 2 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Groovy with REST API - Reading Paramters from FileSummary: Content (required): I'm trying to execute a rule via groovy and REST API by reading the parameters from a file (CSV). If I populate the array with the paramters…
-
I get "EPMAT-1:Command failed to execute" error on the importsnapshot step of groovy scriptSummary: I get "EPMAT-1:Command failed to execute" error on the importsnapshot step of groovy script which allows to migrate the snapshot from source to target environme…
-
Using a Groovy template can you reduce Member DTP scope in 2nd step from Member DTP in 1st step?Summary: I have a dimension hierarchy with multiple levels. I have a Groovy template and created a Member DTP in step one, where a parent level is selected using a formu…
-
Trigger a batch of data management Data load rules via a groovy rule?Summary: I basically want to trigger a number of data load rules using groovy scripting, as I think this is doable using Rest APIs however am new to this concept so guid…
-
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…