Groovy
Discussion List
-
How to create a groovy rule to check for line returns in a text fieldSummary: We our trying to prevent our end users from entering a line return in a text data type member. Content (please ensure you mask any confidential information): We… -
How to change the file name of data export to file processSummary:Hello, in PBCS, we have an integration to export some data, the filter changes, then, this data changes, how can we change the file name dynamically? Right now, …
-
The best way to get scenario start year for certain module by using groovySummary: I want to get Scenario start year & end year for workforce module by using groovy Content (please ensure you mask any confidential information): Hi All, I would… -
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
-
How to set up the EPM agent for Groovy scriptingSummary: I have used basic functionality of EPM agent, i.e extracting the data from on-premise database to EPM cloud in ASYNC mode. now i trying to get data using the AP…
-
Looking for Groovy exampleSummary: I am looking for an example of a groovy script that will make columns read only depending on an account value that is derived from a Smartlist. In this form exa…
-
Copy No_Currency data to Local Currency based on Entity base currencySummary: Is there a way to copy No_Currency data to the respective Entity base Currency with out using UDA's or Attribute assignments Content (required): In a Simplified… -
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…
-
Using Groovy trying to import mapping into the EPM data management INBOXSummary: Content (please ensure you mask any confidential information): Hi all, Can someone confirm if it is NOW possible to move an export mapping file from one cloud e… -
Cross App Data Map - Source as FCCS and Target as Free From Essbase ApplicationSummary: Cross-App Data Map - Source as FCCS and Target as Free From Essbase Application - Is this possible? Content (please ensure you mask any confidential information…Suresh Ratnala-Oracle 21 views 3 comments 0 points Most recent by Viorel "Van" Andritoiu-Oracle Planning -
Triggering OIC integration via Oracle Planning using GroovySummary: I am trying to trigger an OIC job from Oracle Planning using groovy. Content (please ensure you mask any confidential information): The connection is set up for…
-
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…
-
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…