Groovy
Discussion List
-
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… -
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…
-
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…
-
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…
-
Groovy - How to exclude shared members from ASO createDataExporter()?Summary: HI All - I need to exclude shared members from a createDataExporter() ASO data export. Would the best way way be to create two lists : List 1 with the members f…
-
Is there a way to automate updating data map member mappings?Summary: We have a cross pod data map with member mappings. There is no ability to do dynamic member maps so we need to manually update it every time a new member is add…
-
Using groovy to move a file from the Data Management Inbox To the Oracle Planning Inbox ExplorerI am working with OTBI report(s), and this report holds master data which needs to come into EDMCS. OIC is being used as the facilitator from Oracle Fusion into the Orac…
-
Changing background color to cell in data froms using GroovySummary: Requirement to change the background color for a data cell based on certain condition Content (please ensure you mask any confidential information): Hello, We n…
-
Ruleset parallel execution issueSummary: Content (please ensure you mask any confidential information): Hi, I got a weird issue when running a ruleset with parallel execution enabled, and want to seek …