Groovy
Discussion List
-
Upload file from EPBCS inbox to files.com via REST API through 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… -
Is there a way in Groovy to throw an error based on certain validations and close the prompt screen?Summary: Hi Experts, Is there a way in Groovy to throw an error based on certain validations and close the prompt screen? In my current application, I am using throwVeto…
-
EPBCS : API call to Run Rule not fetching parametersWe have two Rules. Groovy_Rule1 should run on form save. Should pick Run time prompts and pass it to API call which will call Groovy_Rule2 to run a Data Map. Issue: For …
-
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… -
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… -
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… -
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…
-
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… -
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…