Groovy
Discussion List
-
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…
-
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…
-
Groovy EPBCS - 3 double quotes is encountered in CSV file when concatenated with double quotesHi guys, We have a variable years_m in which we are concatenating double quotes as below years_m = '"'+cell.getMemberName("Years")+'"' And the variable is passed to out.…
-
ASO GROOVY Script to export data to a file for a specific scenario excluding the shared membersSummary: Hi All, Im trying to write a calc manager groovy script to export the data out of ASO reporting cube for specific scenario to a file which excludes the shared m…
-
List Files in EPBCS Planning inbox using REST APISummary: Need to have a groovy REST API code as business rule to see the list of files in the inbox (Planning) specifically just the name. we want to filter so that it j…
-
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 know CECOs and Accounts that have in different formsHello Experts, I have an assignment to do, in planning process we have all the accounts and all de cecos covered by different forms. I have maybe 50 forms with different… -
Groovy rule to get user's group and prevent that group modify data row in a formHello everyone, I have one question about groovy rule. If a have 4 users : U1, U2, U3, U4 and (U1,U2) are in group A, (U3, U4) are in group B. Now I have a form that bot…
-
Calling another Business Rule within a RuleHello, We understand there's an option to call another business as subprocess within a rule using following syntax. %Rule(name:="Rule to be called",application:="EPBCS",… -
EPM agent - Events - How can i separate the events from each integration?Summary EPM agent - Events - How can i separate the events from each integration?Content Hi all, I have several integrations via EPM integration, some of them need the u…
-
how to create a groovy script if a DFF in the contract line is null it will raise a warning messageSummary: how to create a conditional groovy script if a DFF in the contract line is null it will raise a warning message Content (please ensure you mask any confidential…
-
how to export and import using groovy scripHi eveyone, I'v 2 cubes, ASO and BSO, for dense dimensions, to ASO its Account and to BSO its Period, can i use groovy to Export and Import with this case?? I mentioned …
-
CsvIterator fails when the file size is >100Mb script gives unknown errorSummary: CsvIterator fails when the file size is >100Mb script gives unknown error when the size is reduced the same code works fine. Content (please ensure you mask any…
-
run the groovy to execute data map with Planner userHello everyone, Is there any way to run the data map when using planner users? A user with planner access facing issue while saving the data form that have the data push…
-
Sort Pipeline GET responsesSummary: Pipeline returns DM Process IDs in unsorted manner, would like to sort this Content (please ensure you mask any confidential information): Am trying to sort the…