Groovy
Discussion List
-
How can I create a DataMap with all SmartList entries using Groovy?Does anyone have an idea how can I create a Data Map with all entries from a specific Smart List using Groovy? My application has the Smart List “SL_BP_Tipo” with 26 ent… -
Is there any function which can be used in groovy script for suppressing the Zero value record rowsSummary: EPBCS to PowerPlan export file generating rows for which data is 0 in all the months. Check if there is a function which can be used in groovy script to suppres…
-
With Groovy, how can i get the specified attribute value of Entity from PVO (on a form)With below form, I want to pick the Entity value of 1188 and test if its "Type" attribute is equal to "Corporate". I am able to get the whope PVO but not the 1188 itself…
-
Make cells readonly for specified data rangeHello all, For a program we enter start date (01-02-2025)-dd-mm-yyy and End date (31-12-2025), From this range feb 2025 to dec 2025 the cells has to be editable remainin…
-
Create or Update All Substitution Variables Defined for the ApplicationHello, I am trying to leverage "Update Substitution Variables " REST API and below is the code: Through Postman it is working fine. I am trying to execute it as I did fo…
-
Creating via Groovy Rule the Excel file needed for the update of Cell-Level SecuritiesSummary: We would need to create and populate the two-tab-based Excel file needed for the Cell-Level Securities update. Is there a way to do so? Content (please ensure y…
-
Is it possible to have a specific message show when throwing veto exception on a form rule?Summary: If a rule has a veto exception triggered when launched on save of a form it doesn't show the message on the pop up on the form, just that the rule failed. Conte…
-
Convert Json to csv using groovy scriptSummary: Hello all, Here is the json link: using this I'm able to display the content in jobs. I want to generate into csv file in inbox/outbox explorer. This is my code…
-
Delay in calc manager to recognize new Smart Lists/Variables?Summary: I created a new SmartList within Planning and new Variables in Calc Manager. The SmartList isn't showing in the options for variables and the variables are givi…
-
Groovy script getEpmAutomate issueSummary: I am trying to run EPM Automate Using Server-Side Groovy. Content (please ensure you mask any confidential information): My script is as follows: EpmAutomate AM… -
Groovy to change the member Name and its aliasHello everyone, To reduce the Administrator's job, I want to give the planner access to modify the member name and its alias. So my question is: How can I use Groovy for… -
Download CSV file from EPBCS inbox using GroovySummary: We are looking for a groovy code to download a file from epbcs inbox/outbox explorer to local machine. Unfortunately, we can't use epmautomate. Content (please …
-
Assign Role to User via REST API (v2)Summary: We are seeking to run a Groovy script in one Planning environment to add a "User" role for a user in another Planning environment in the same domain using the R… -
Is it possible to force a line on a form to read only by row/column vs by cell using Groovy?Summary: I would like to have a groovy business rule set security on an entire column or row to read only vs having to do it by cell. Content (please ensure you mask any…
-
Calling REST/SOAP APIs in Connections via groovyHello All, Today we know that we can connect an internal or external REST APIs in connections and call them via groovy rule... For example : https://www.oracle.com/webfo… -
Groovy Rule using Substitution variable for colouring forecast monthsHi, Can we color forecast months using substitution variables (Jul to Dec)? Let's suppose I have Substitutions variable FCSTMonths (Jul to Dec). Is there any way to colo…
-
EPBCS REST API: Adding users to already existing group is throwing out errorSummary: Hi - we need to add users on the fly to an existing group. The code is also attached. we keep getting the following errors even though all parameters are define…
-
EPBCS Datamanagement groovy rule - with Json loopSummary: Hi Expert, I'm trying to call a groovy rule which will execute Data integration , changes source filter based on subvar for ent1 and ent2, First ent1 filter sho…
-
Pipeline invoked through Business rule REST API not sending emails on completionSummary: we have a business rule which is invoking pipeline through REST API call. The rule works as expected and the pipeline is invoked. Everything works as expected h…
-
Can not run groovy rule when attach rule to DashboardHello everyone, I have a dashboard. And now i want to attach the business rule (Groovy scrtipt) to this dashboard with the set up below: But the rule is groovy script. S…
-
Using groovy to promote a planning unit - syntaxWe are building a groovy rule that will allow users to promote a planning unit. However, our json response and body is returning 201 {"links":null,"type":"HP"} Do we hav…
-
How to provide multiple values for RTP when using groovy and REST APIHow to provide multiple values for RTP when running a business rule from REST API and groovy? Below is the code I am using: When I provide single value for RTP it is wor…
-
Groovy export to importSummary: Can anyone see why I keep getting the below Groovy validation error this script is taken almost directly from the Groovy documentation. from what I read on crea…
-
Data Integration: Passing arguments to Parameters list in Target Application using groovyHi all, Hope you guys are doing well! We have integrated BIP Report with certain arguments with EPBCS application. So, is it possible to pass the arguments using groovy?…
-
Groovy to determine the attachment in cellHello everyone, I have one question. I created a new column in a input form for user to attach the file: I want to ask: How can I write Groovy to detemine the cell have …
-
Retrieve in an EPBCS form the number of attachments of a cellSummary: Retrieve in a form the number of attachments of a cell Content (required): Hello, I want to retrieve in a form the number of attachments of a cell next to the c… -
Need to find a way to change some HomePage appearance feature via Groovy/EPM AutomateSummary: Hi, We would need to change something in the HomePage of a PBCS application via Groovy Rule / EPM Automate. It could consist in the change of background image, …
-
Promote Planning Units using GroovySummary: We're trying to manage approvals using Groovy but we're not able to fetch and apply actions like Promote, originate etc. using Groovy. We've followed all the st…
-
I am trying to use Groovy scripting to return the current user name for an account within Planning.Summary: In Planning, I am trying to return the logged user name (full name if possible) for an account which shows the initiator of the process. For example, if I log i… -
EPM Agent Integration from Sales Fusion to EPM.We have gone through the following documnetation for EPM Agent Integration. But in the above documentation it is navigated as source and Target application under Data Ma…