Groovy
Discussion List
-
how to run REST API ADD_USERS_TO_GROUPGroovy is undoubtedly a wonderful tool, it has allowed me to run jobs through REST API export and import data, metadata, security, mass rename members, form operations a…
-
Groovy to get all the jobid's running under pipelineSummary: Hi Experts, We are exploring how to get all job's under running parent pipeline job For example Pipeline has 4 dlrs , want to get job'id of each process using J…
-
Groovy-Randomly receiving "The form GroovyDataGrid_# is invalid" error that works perfectly on rerunSummary: We have rules that will occasionally fail with the above error but work perfectly when rerun with no changes. Content (please ensure you mask any confidential i…
-
How to get the name of the item in a smartlist entryHello everyone, Because of the security of the Cost Centre dimension, we need to create a smart list entry that contains all the cost centers in Cost Centre dimension by…
-
Groovy - how to print real-time log message in job console?Summary: Hi, I have a Groovy rule with long-running processes, for example the process needs to be iterate through 100 times for different combinations. I need to watch …
-
Required a code in groovy so that if the first BR is running second BR should wait for the first BRWe are using the export and import method as we need to manipulate the file because of the mapping of dimension between two cubes.Data has been doubling when we are runn…
-
How to schedule to run the report and send it via email?Hello everyone, I want to schedule to run a report in EPBCS and send it via email. Is there any function that can help with this requirement? I tried to find it in the J…
-
Groovy setSuppressMissingSuppressesZero never workSummary: Hi, With a groovy rule to build a grid like below for reading data FlexibleDataGridDefinitionBuilder gdb = cube.flexibleDataGridDefinitionBuilder() gdb.setSuppr…
-
Not able to retrieve smart list values from datagrid.datacellSummary: Hello, we need to retrieve smart list values from a grid. The smart list has entry ID of 1,2,3 and corresponding label and Names. we need to retrieve the name h…
-
How to use Groovy to create unique set of multiple chart string values via a single GridHello, I'm trying to build a Form and Groovy Script that will allow a user to update multiple "Transaction IDs" simultaneously within a Form. The form is built with a sp…
-
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…