Groovy
Discussion List
-
Groovy - Setup Scenario PeriodHello, I have my Groovy script for scenario and year changes, similar to the Planning Financial Module. I have a form with the "run before save" function associated with… -
Error occurred in Groovy datamapsSummary: We've created a custom datamap using groovy, where We're customizing few dimension members. The script runs smoothly if we hardcode the Account members but fail… -
Automated cleanup of scheduled jobs/mail notifications in DR instance post-EPBCS environment cloningIn our EPBCS application, we use the cloneEnvironment command as part of a daily automation to refresh our Disaster Recovery (DR) environment from Production. This clone…
-
Member Name contains comma for Data IntegrationSummary: Account name contains comma Content (please ensure you mask any confidential information): Hi All, I am performing an ASO to ASO cube data transfer using Data I… -
how to establish a connection with an oracle database server using the REST API using groovyhow to use that connection to perform crud operations in groovy
-
group by / sum createDataExporter aso data exportsI'd like to use createDataExporter to extract data from ASO but i'd like to extract only the totals of some dimensions. This isn't possible without extra steps because y… -
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…
-
401 Authorization Required when using /interop/rest/v2/mails/sendUsing groovy to send email in business rule: HttpResponse jsonResponse = operation.application.getConnection("SendMail").post('/interop/rest/v2/mails/send').header("Cont…
-
How to Allow Non-Admin User to Execute Groovy Rule Changing Dimension Member ParentSummary: Hi, have a groovy rule that updates a members parent member to move from one parent to another. It works for admin users but doesn't work for the non-admin busi…
-
FUTA Member Formulas Needs to Run Twice to WorkSummary: Content (please ensure you mask any confidential information): I have the below member formula for FUTA. It is kicked off by a business rule, and below is the s… -
Adding member dynamically under a parent in specific order using groovyHi Folks, Using groovy, I'm able to create new child member under a specific parent but I want to create these children in a sorted order. Let's say I have following pro…
-
Manage / Automate Valid Intersections with Groovy (Solution)Hi - The below post from @JeremieR-Oracle gave the inspiration to get over the hump on how to update Valid Intersections completely in the cloud inside of EPM. Hopefully…
-
ASO calculations do not work when converted from Designer to Script mode in GroovyService:Enterprise Performance Management Enterprise Cloud Business Process:Planning Version:25.03.60 ISSUE: Trying to convert an existing Designer template for a MDX co…
-
setBgColor on Cell not working in Forms 2.0. Is this a bug, or do I need to do something specific?Summary: setBgColor on Cell not working in Forms 2.0. Is this a bug, or do I need to do something specific? My code works perfect when I toggle to Forms 1.0. Content (pl… -
Set Text Account with Attribute ValueSummary: Is there a way to assign a Text Account with an Attribute Value? I'm trying to use a regular rule but it is not working. A couple examples of what I tried below…
-
getEvaluatedMembers for LAncestors in Shared HierarchiesSummary: We have a need to be able to grab ancestors from a specific level in a shared hierarchy in a dynamic fashion based on an RTP value. When using the Ancestors on … -
Checking null attribute in calcscriptHello experts, I have a calc script that I have to check if attribute of specific member is null or not, this is my code but is not working: FIX(@RELATIVE("Entity",0 )) … -
Upper level member for calc script & IPM insightSummary: IPM insight selection cannot be dynamic parents. Content (please ensure you mask any confidential information): Dear experts, I am trying to use the IPM insight…
-
Forms 2.0 & Groovy throwVetoException not showing error messageHi - We are doing some validation of user entry before we run calculations on a form. We have been using Forms 2.0. When the validation fails and throwVetoException is c…
-
How to get the Dimension names which are present on the Columns of a webform via groovySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
can a rest endpoint create announcementsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Groovy DataGridBuilder varying columnsSummary: Content (please ensure you mask any confidential information): Hi, I got stuck on a groovy rule to build a DataGridBuilder with varying columns and don't know h…
-
How we can set row suppression while using createDataExporter() to export data from EPBCSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Rest API for Artifact update reportsSummary: Looking to generate Artifact Update reports through rest API or EPMAutomate but dont see any resources available to get this information from automation of audi… -
Need Groovy syntax to Upload file in staging area for EDMCS from planningSummary: We need File Upload syntax in Groovy for epm cloud. Basically, We are connecting EDMCS using groovy from Planning application. And trying to upload file using G…
-
Anyway to handle the workorder not allow to create if stockSummary: Anyway to handle the workorder not allow to create if stock is not available in respective subinventory Content (please ensure you mask any confidential informa…
-
Conditional Groovy in a form comparing two accountsHello experts!! I have a requeriment to do, I have this form: And with Groovy I should get a validation in BALANCE row. My requeriment is if BALANCE is equal to C1290_CA…
-
File renaming issue in EPBCSSummary: I want to rename the file after unzipping the data export file. Content (please ensure you mask any confidential information): I tried several ways to schedule …
-
Dynamic Substring Function - Essbase Equivalent of FIND/SEARCH Function from ExcelSummary: We have a need to perform dynamic member name lookups with member names that are varying lengths (something outside of our control as they come from a source sy…
-
Decimal precision not working -groovy-csvwriter -datagrid exportSummary: Hi All, I am exporting datagrid to csv file(csvwriter) using Groovy script. The exported data has precision issues as below. For Example: In smartview, the data…