Groovy
Discussion List
-
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… -
Running EPM Integration gives me nullPointerExceptionSummary: Running a Data Management Pull of data using Groovy "befExtract" from windows to the EPM using Integration. Content (required): we are trying to connect to a th…
-
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… -
Retrieve in an EPBCS form the number of attachments of a cellSummary: Retrieve in a form the number of attachments of a cell Content (required): Hello, I want to retrieve in a form the number of attachments of a cell next to the c… -
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…
-
Groovy REST API Download Has No New LinesSummary: Using REST API Download in Groovy BR - the text has no new lines Content (required): We are able to use the REST API Download request to get file contents from … -
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…
-
Automation of user variable limits/definitions?Summary: Is it possible to automate additions of new members in user variable definitions? Content (required): We have a number of user variables to assist in the limita…
-
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…Yash Peswani 24 views 9 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning -
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…Peter Joelson 34 views 3 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
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…Kumari Soni 39 views 2 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-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… -
Hide Columns validating a condition through groovySummary: I would like to validate a condition of row member and hide columns which does not satisfy that condition. Content (required): Looking for a groovy logic to see…
-
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…
-
Create & Import a Snapshot via Groovy Rule (Valid Intersection Automation)I have been trying to find a way to do this as a way to try and automate the creation of valid intersections at a client. Ideally, I am trying to complete the following …
-
Can I only format background color for a cell in a data form using Groovy ?Summary: I have only found a way to change background color for a cell in a data form, but can I also e.g. add borders and change the color of the text ? Content (requir…Martin Lundbye 36 views 2 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning -
unable to do the Data Export in ASO cube using groovy scriptSummary: The issue with the Groovy code can anyone please help me to resolve this Content (required): In the BSO cube, we can export the data using below Groovy Script t…
-
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…