Groovy
Discussion List
-
Does Groovy help retrieve the date of latest input data ?Hello experts, I have one question about Groovy's ability. I noticed that on the form, when you right-click, you can view the change history of the data cell. So my ques… -
How can I read full log of the jobHello experts, I am using Groovy to print the log for the job I am running. However, when I go to the Job Console to view the log, I find that it is not sufficient, and …
-
Groovy - Issue passing variable between templates within the same jobHello I have Issue passing variable between templates within the same job. In GroovyValidationReport I got error: The Groovy script failed to compile with internal error… -
Can Groovy help to prevent user promoting based on approval flow?Hello everyone, I have one question about Groovy's ability. I now have an approval flow for both Entity and Project. And I also have a form to show the validation by usi…
-
Can we call ODI package from EPM Data management?Summary: Can we call ODI package from EPM Data management? is it possible? Content (please ensure you mask any confidential information): call ODI package from EPM appli…
-
Export multiple years data to a fileHello everyone, This post is for sharing purposes. Today I’d like to share with you a topic related to multi-year data export to a file. While going through the Oracle c…
-
DataExport Period PivotingSummaryI am working in Oracle EPM Cloud (Planning) and I am trying to generate a CSV export using the DATAEXPORT command inside a business rule. The export works correct…
-
Testing nonemptytuple on Planning Custom Calculation ASO (Groovy)Summary: Now that Essbase 21C is under the hood of Planning, did anyone notice performance gains from adding NonEmptyTuple to Custom Calculations in ASO? I have been adj… -
Possible to have Groovy Popup Warning, NOT Error?Summary: We have groovy rules set for validation that we use throwVetoException to stop processes before they start, but is there a good way using groovy to just throw a…
-
We would like to know the Business rules association in EPBCS applicationSummary: We ran the system reports and found that they only display business rule associations related to forms, menus, and tasks. However, some rule associations outsid…
-
Data map is clearing data for different cost center in ASO even when CC is passed as parameterSummary: Hello Geniuses, I am facing an issue while running the datamaps using restapi connection. I am modifying the map definition in the job using rest api for cost c…
-
Groovy script to Validate comment entered through data formSummary: Hi, I am new to groovy BR. I am working on Groovy BR to validate "comment" entered by user using data form. A member with "Text" data type is used in data form …
-
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… -
Groovy - Tidy up Job Console ExportSummary: This code is to automate the job console export and format it in a more readable format Code Snippet : // #### RULE HEADER - START // // Author: Jeremie Richard…
-
groovy failing with datagriddefinationbuilderHi Team one of our Groovy BR (due to huge volumes) is failing execution with below error. Any suggestions / alternative ways? A method called by the script failed on lin…
-
Upgrade to Essbase 21.7.x for 25.11 Connections failingThere was an error rendering this rich post.
-
How to write csv file with groovy rule without adding Byte Order Mark (BOM)I am trying to create a csv file with groovy rule. All went well, except this created file contains byte-order mark (BOM), which is not needed. Automation is sending thi…
-
Push Data Failed: Error - The member does not exist for the specified cube or you do not have accessDescription: Hello, I am encountering the following error when trying to push data from an ASO cube (source) to a BSO cube (target) in Oracle PBCS: Error: "Push Data fai…
-
Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using GroovySummary: Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using Groovy Content (please ensure you mask any confidential information): I want to Cop…
-
How to return text values from a Business Rule (without using Smart Lists)?Hi everyone, I’m trying to write a Groovy Business Rule in Planning (EPBCS) that returns or assigns a text value to a member. The requirement is to store a text string (…
-
Data duplicating after Groovy runs rule set when ad hoc runs are overlappedOur implementation partner was able to configure a set of Groovy scripts to kick off the various calculations in order, which can be both scheduled and/or run ad hoc by …
-
$value is being considered as variable in REST API get method (SharePoint Integration)Hi guys, I am trying to get data from a CSV file which is uploaded in SharePoint to EPBCS application. From Sharepoint REST API, using the following Source URL GET https…
-
How to print attachment file in cell commentHello everyone, I have attached the Excel file to a cell : My question here is: How can I print all the attachments in all the cells at one time? Is there any feature or…
-
RTP in Groovy rule only shows 1 promptHello everyone, I based on Oracle document here to validate the rule: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/groov/groovy-example…
-
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…
-
epmautomate SendMail is blocking emails from being sent to specific usersSummary: I encountered strange behavior where it appears (based on the epmautomate log) that SendMail is being blocked from sending emails to a specific user. The kicker… -
Using getSharedMembers for cube specific shares?Summary: I am trying to find cube specific shared members using getSharedMembers since the documentation shows this should be possible, but I'm getting shared members fr… -
what is the syntax to update alias with groovy scriptSummary: Is there a syntax to update alias using a groovy script? We would like to update the alias of a period member based on the start period of the actual scenario. …
-
Threading / Multi-Processing Equivalent in GroovySummary: Is there a way to accomplish threading / multi-processing in Groovy within EPBCS? We have a number of jobs where scripts are running on a large set of Project d… -
Groovy Validator Missing in Production for Prebuilt ScriptHi All, We’re using a prebuilt Groovy rule in our Dev, UAT, and Production environments in Oracle EPM Cloud. In Dev and UAT, we can see the Groovy Validator Option under…