Groovy
Discussion List
-
Groovy to transfer data between cubeSummary: I planned to transfer headcount data between cubes by using groovy. Content (please ensure you mask any confidential information): I have tried to use datagrid … -
Need a way to set Date Value in a Flex Form with an After Load Groovy RuleSummary: Hi, We are designing a Flex Form that displays in SmartView the current value of a Date field, taken from a different POV. To do so, we implemented a groovy rul…
-
How to affect UDA to members in account dimension ?Hello, We need to affect UDA to members in account dimension thanks to the webform, where : a user can input value "1" in a particular cross of dimensions, including mem… -
Groovy Dataexporter is not exporting Dynamic Calc membersSummary: Hi, I need to export data from EPM Planning BSO cube with "Alias". So I need to use Groovy Rule because Data Export Calc command BR create Member Name in file. …
-
Issue with getEmailAddress() Method in Oracle EPM Groovy: "Email Doesn't Exist" ErrorHi Folks, I'm encountering an issue in Oracle EPM when using the getEmailAddress() method of the User class in Groovy. When I call operation.user.getEmailAddress(), I re…
-
Groovy in Essbase 21CHi all, Sorry if I am posting the question in wrong platform. But, I did not find any better community than this. Although I have worked on EPM applications, I got curio…
-
Dynamic Children and Groovy saveMember questionSummary: Content (please ensure you mask any confidential information): Hi, With Dynamic Children enabled for a "Dynamic Calc" parent, and use Groovy(non-REST API) to ad…
-
Form Validation using groovyHi, I am trying to match two separate set of columns using groovy. (Yellow should match with Green section - the Green section is dynamic). If it's not match script shou…
-
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 32 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 …
-
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… -
Using [[PlanningFunctions.getIdForString("text")]] within a calc script in a groovy scriptHello, I am trying to save some data into a Text field using the PlanningFucntions.getIdForString within a Calc script, that is nested within a Groovy script. I have bee…
-
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…