Groovy
Discussion List
-
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…
-
Creating via Groovy Rule the Excel file needed for the update of Cell-Level SecuritiesSummary: We would need to create and populate the two-tab-based Excel file needed for the Cell-Level Securities update. Is there a way to do so? Content (please ensure y…
-
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 …