Groovy
Discussion List
-
CalcMgrGroovyNumberHello! I'm trying to mask data with a similar approach that the random function in excel. I've been reading old posts where there was a way to do this using @CalcMgrGroo… -
Groovy error "A method called by the line failed" when trying to integrate with EDMCSSummary: This groovy script has been created in order to export metadata from EDMCS and import it into Planning. But it still gets an error saying that "A method called … -
How to refresh a form using a groovy rule?Summary: How to refresh a form using a groovy rule? Content (required): Dear all, I've written a Groovy rule to add some complex control before saving data. This rule is… -
Groovy error "A method called by the script failed on line..."Summary: I am trying to update the substitution variable using a groovy script from the Business rule, which is returning an error. Content (required): I have a groovy s… -
Is it possible to run a Groovy rule before load without User Variable error?Summary: Unable to execute a script replacing user variables because user variables are missing. Content (required): I am trying to execute a script that automatically f… -
Sum duplicate rows from Rest API export data slice to move data to FCCS through import data sliceSummary: Trying to move data between Planning and FCCS through Rest API export/import data slice using a groovy map but getting duplicate lines that aren't adding togeth…
-
I have to display date data which i have entered in dataform using groovy scriptSummary: Content (required): This is the data form in which I'm entering the data. I have to display the date format in Job console. This is the code i'm trying to displ…
-
Groovy Business Rule - crossDimCell across Multiple Dimension Members (Account and Scenario)Summary: We are attempting to use Groovy to assist with custom validation rules to run prior to save on forms in our application. However, the form in question uses the … -
What is the best way to export large amount of data to file?Summary: Trying to expor data to file but having issues of either Data export job generating .zip file, exportdataslice has cell limit of 500.000 or getting around cell …
-
Data maps from BSO to ASO includes Dynamic Smart List members using GroovySummary: Hi All, Please review the bellow groovy script and help us to add the Smartlist syntax. Smartlist Name: SL_BillType ,Smartlist Member Name: Dyn_Billing Type, (T… -
Exporting data with combinations of Smart List members in EPBCSSummary: We are experiencing a delay with Smartpush execution, which is likely due to we use of dynamic members (Smart Lists). Is there a way for us to export data that …
-
[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 266 views 2 comments 0 points Most recent by 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 …