Groovy
Discussion List
-
Groovy rule in pipeline failed to initialize Epm Automate instanceSummary: Try to attach groovy rule in pipeline Content (please ensure you mask any confidential information): I tried to put groovy rule in pipeline, but it failed to ca… -
Automate File Transfer from SFTP to EPBCSOur current process with OIC renames the file on SFTP(Example file name: Testfile_MMDDYYYY_HHMMSS to Testfile MMM-YY) and moves the file to EPM then deletes the file on … -
OICS to load PPM Data in to EPBCSSummary Load PPM data using OICS in to EPBCSContent Hi All, In my current client there is a requirement to automate the data load from PPM to EPBCS. In the absence of di… -
Groovy rule in ASO is rounding off the values after calculationSummary: When performing a calculation on ASO using a Groovy Business rule a simple Unit*Price is resulting in an absolute value instead of giving the decimal values. Is… -
Error in groovy, The following Date is Invalid: .Hi all, we are trying to retrieve data from multiple projects in EPBCS in ASO cube we are using datagriddefinitionbuilder to read the data from the above accounts as bel…
-
Can you exlude members in a Groovy Data Export scriptSummary: We have a groovy script that moves data from one Hybrid BSO database to another. We have added an attribute value called "Entity_Closed" on Entity members that …
-
How do I use @ATTRIBUTE in business ruleSummary: Need a business rule using attributes to breakout costs into another entity/account Content (please ensure you mask any confidential information): I've used @AT… -
Securely storing a client secret for REST API OAuth2 Authentication in Groovy ruleSummary: Where can I securely store a client secret token for use in a REST API call in Groovy. Content (please ensure you mask any confidential information): I need to …
-
Use epmautomate commands in GroovySummary: Hi Team, I'm working on a Groovy script that logs in and renames our Snapshots. I wanted to use functions for reusability and avoid repeating of code. But when …
-
Error in accessing JSON file from Inbox/Outbox Explorer using groovySummary: Unable to access a text file uploaded at "Inbox/Outbox Explorer" in an EPBCS application using groovy. Content (required): Hi, I have a text file (.txt) which c…
-
Groovy jsonSlurper FailingSummary: I am trying to parse a JSON response, and I have code that works in a Groovy web console, but the exact same code does not work in a Planning Groovy business ru…
-
groovy assign variable value to rtpSummary: Assign variable value to rtp for essbase calculation part Content (please ensure you mask any confidential information): Hi All, I have retrieved the prevData v…
-
SAS URL File Download in Groovy Business RuleSummary: I have an SAS URL that works to return the contents of a file when used in a browser or curl, but it fails with 403 Authentication Error when I try to use the H…
-
How we can run three data load rule parallely via making changes in EPM Automate Scripts(.batfiles)?Summary: We want to run three data load rule parallely instead of sequentially. Content (please ensure you mask any confidential information): Hi Experts, Right now we h…
-
Groovy - The form GroovyDataGrid is Invalid when DataGridDefinitionBuilder is usedHi all, In an ASO cube, we are using CsvWriter and DataGridDefinitionBuilder to iterate through each account to generate a CSV file in Inbox/Outbox Explorer. while using…
-
How can I create a DataMap with all SmartList entries using Groovy?Does anyone have an idea how can I create a Data Map with all entries from a specific Smart List using Groovy? My application has the Smart List “SL_BP_Tipo” with 26 ent…
-
Is there any function which can be used in groovy script for suppressing the Zero value record rowsSummary: EPBCS to PowerPlan export file generating rows for which data is 0 in all the months. Check if there is a function which can be used in groovy script to suppres…
-
With Groovy, how can i get the specified attribute value of Entity from PVO (on a form)With below form, I want to pick the Entity value of 1188 and test if its "Type" attribute is equal to "Corporate". I am able to get the whope PVO but not the 1188 itself…
-
Make cells readonly for specified data rangeHello all, For a program we enter start date (01-02-2025)-dd-mm-yyy and End date (31-12-2025), From this range feb 2025 to dec 2025 the cells has to be editable remainin…
-
Create or Update All Substitution Variables Defined for the ApplicationHello, I am trying to leverage "Update Substitution Variables " REST API and below is the code: Through Postman it is working fine. I am trying to execute it as I did fo…
-
Is it possible to have a specific message show when throwing veto exception on a form rule?Summary: If a rule has a veto exception triggered when launched on save of a form it doesn't show the message on the pop up on the form, just that the rule failed. Conte…
-
Convert Json to csv using groovy scriptSummary: Hello all, Here is the json link: using this I'm able to display the content in jobs. I want to generate into csv file in inbox/outbox explorer. This is my code…
-
Groovy script getEpmAutomate issueSummary: I am trying to run EPM Automate Using Server-Side Groovy. Content (please ensure you mask any confidential information): My script is as follows: EpmAutomate AM…
-
Groovy to change the member Name and its aliasHello everyone, To reduce the Administrator's job, I want to give the planner access to modify the member name and its alias. So my question is: How can I use Groovy for… -
Download CSV file from EPBCS inbox using GroovySummary: We are looking for a groovy code to download a file from epbcs inbox/outbox explorer to local machine. Unfortunately, we can't use epmautomate. Content (please …
-
Assign Role to User via REST API (v2)Summary: We are seeking to run a Groovy script in one Planning environment to add a "User" role for a user in another Planning environment in the same domain using the R… -
Is it possible to force a line on a form to read only by row/column vs by cell using Groovy?Summary: I would like to have a groovy business rule set security on an entire column or row to read only vs having to do it by cell. Content (please ensure you mask any…
-
Calling REST/SOAP APIs in Connections via groovyHello All, Today we know that we can connect an internal or external REST APIs in connections and call them via groovy rule... For example : https://www.oracle.com/webfo… -
Groovy Rule using Substitution variable for colouring forecast monthsHi, Can we color forecast months using substitution variables (Jul to Dec)? Let's suppose I have Substitutions variable FCSTMonths (Jul to Dec). Is there any way to colo…
-
EPBCS REST API: Adding users to already existing group is throwing out errorSummary: Hi - we need to add users on the fly to an existing group. The code is also attached. we keep getting the following errors even though all parameters are define…