Groovy
Discussion List
-
Pipeline feature to copy file from unixSummary: Can we directly pull the file from unix box to epm inbox using Copy to Object Storage Job Type after setting up the External Web Service Connection Unixfile is … -
how to automate a refresh member from data exchange with groovy rule?Summary: how to automate a refresh member from data exchange with groovy rule? Content (please ensure you mask any confidential information): We created a groovy rule to…
-
setRowFilterCriteriaSummary: Has anyone used the groovy dataExporter with .setRowFilterCriteria() specifying both single members and metadata conditions? I'm trying to create a data export …Nic Bonacci 43 views 2 comments 1 point Most recent by Nic Bonacci Financial Consolidation and Close
-
How to specify the column names to be exported from a cube using groovy script?Summary: We have recently added new dimensions into our Planning application. The downstream application doesn't need the new dimensions (2 of them) hence we need to upd…
-
Groovy Scripting in EPBCS ASO CubeSummary: Hi Guys, Have a requirement to do Currency Conversion(USD to CAD) within the reporting cube(ASO) of EPBCS. Currency Conversion should happen once the Data get l…
-
EPM Cloud Connection requires HTTPSSummary: The December update to EPM Planning now requires that all Connections use HTTPS URLS. This was only announced as a future update for February 2025, but this cha…
-
Groovy - Read Only Using Dimension AttributesSummary: I am trying to find a way to get specific cells read only based on a combination of of an account value and a dimension attribute. It is working for the account…
-
Groovy - Issue calling calc script template inside a groovy scriptSummary: I have a groovy rule that executes a calc that references a Template. I am passing the template name using a variable. I am getting a generic error. If I print …
-
How to extract data from Fusion using GroovySummary: Instead using built-in integration, i would like to use other web service connector(For Fusion) and using that connection name in Groovy, would like to extract …Meenakshi Rajagopalan 31 views 1 comment 0 points Most recent by Sreekanth M, Oracle-Oracle Fusion Service
-
How to Exclude Shared Members in getEvaluatedMembers?Summary: How to Exclude Shared Members in getEvaluatedMembers When Loading Lvl0 Members of a Hierarchy Content (please ensure you mask any confidential information): I a…
-
Groovy Validation based on other columnHi, Please need help with below. I want to make "Departure Date" read-only if "New Pos Status" != 2. The below scripts runs without error but doesn't perform the expecte… -
I'm looking for a groovy method to update a member in the layout of the formHi everyone, In order to automate the load of metadata from EDMCS to a PBCS application, we want to delete some members in a specific alternative hierarchy. The issue is…
-
One If Statement Condition Not Working While Other Is -Both Same POVSummary: I am not able to figure out why the highlighted section of the below if statement is not working. The if above it is working fine and they are at the same "No Y…
-
Readonly cell based on smartlist (Create from member) via Groovy scriptSummary: Read-only cell based on smartlist via Groovy script Content (please ensure you mask any confidential information): Our requirement is to do cell read only based…
-
Groovy Validation on Single ColumnThe below groovy scripts is applied on the whole grid whereas I just wanted to apply for one column i.e. "Person FTE". Kindly, need help with the correcting this syntax.…
-
Update Member Alias by end userHi, I am looking for an option where an end user (not admin) can update the alias of a member. I have explored couple of options: > EPM Automate doesn't have any such co…
-
Using groovy to set substitution variables for non admin usersSummary: Content (required): I've written a groovy script to set substitution variable values using the standard method: operation.application.setSubstitutionVariableVal…
-
Groovy - Issue passing environment variable to calc script templateSummary Environment variable defined in groovy script is not passing over to calc script templateContent Hello, We are defining an environment variable in our groovy tem…
-
Call Data Export job via groovy scriptHi, I have defined a data export job in the application. Is there any way we can trigger this data export job via groovy script? Thanks in advance.
-
Add Different parents in List of getEvaluatedMembers in GroovyHello experts, I have a doubt developing a groovy script. I need to get a list of Cebes but in this case I need to take different parents at the same time. I'm using thi… -
Business Rule/Groovy Scripting to remove data in ASO with runtime promptSummary: Is there a way to run a clear script in an aso cube with the user selecting variables (runtime prompt) - e.g. for Version members? Content (please ensure you ma…
-
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…