Groovy
Discussion List
-
groovy data grid multi dimensional mapping possible?I use DataGridDefinitionBuilder to power the data movement from one plan type to another and use a Map variable to do some member replacements. It works great but now I … -
EPBCS Enabled modules - Projects - Flexi Dim2 not working for relative LEV 0Summary: EPBCS Enabled modules - Projects - Flexi Dim2 not working for relative LEV 0 and works only with No Member for Flexi Dim2 Content (please ensure you mask any co… -
how can i extract the text value from a account stored as text via groovy?I need to retrieve the text info from a cell stored as text. But this code only retrieves values 0. What am i doing wrong? // Get the grid from the operation DataGrid cu…
-
Unable to retrieve data from open REST APISummary: Unable to retrieve data from an open REST API into EPM using groovy rules. Content (please ensure you mask any confidential information): Hi! I am trying to imp… -
I can't seem to change the background color on a form in a smartlist cell, from a groovy scriptSummary: I am trying to change the cell background color from a groovy script. when I run the script, there are no errors, but the color doesn't change. Content (please …
-
CreateSmartPush not pushing the dataSummary: I need to calculate values using dynamic calc parents of multiple sparse dimensions (credit = sum(debits). I have tried the HYBRIDBSOINCALCSCRIPT setting but it…
-
SmartPush with Groovy failed and very slow. Error Threshold: 500000Hello experts, I have a form with moreless 400 rows, and user should inform these 400 rows with different values. in Rows I have four dimensions with different combinati… -
FCCS : executeCalcScript(java.lang.String) is not allowed RuleSummary: Groovy function to executeCalcScript is not working in FCCS Content (please ensure you mask any confidential information): getting below error while trying to e…
-
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…