Groovy
Discussion List
-
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. https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/diepm/epm_agen…
-
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…
-
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…
-
When I run the rule, the system prompts an error, but when I run it a second time, the error disappeThis is a rule written by "groovy". Groovy acts like a rule set that calls rules and gives some parameters. The JOB status is “completed with Erros” . Details content of…
-
Navigate to another URL from a form passing a dimension name in the pov throughContent Hi, does anyone know if we can navigate from a form in EPM cloud, picking up members in a pov and passing them through to another web site and surfacing that web… -
MDX Calculations with Custom Groovy Scripts In ASO Cubes.I want to write a Groovy Script in ASO cube, that should execute complex calculations involving multiple operators across various dimensions. Can anyone provide any sugg…
-
Pipeline GET Call errorSummary: Pipeline POST is successful but trying to get the status of pipeline jobs and says error occurred while processing this page. The error appears same for any 'it…
-
Read csv file using groovy scriptSummary: Hello all Below is the requirement I'm trying I have a csv file in inbox/outbox explorer which has data in a particular combination. Example : A1 jan 2024 = 100…
-
Json ArrayI have requirement of writing JsonArray data which is pulled from a wen API to a csv file Rest API url : https://jsonplaceholder.typicode.com/users Json array : [ { "id"…
-
Cross Pod Data Map - Dynamic Wildcard Mapping from Source to Target in Groovy/Smart PushSummary: We have a need for a cross-pod Smart Push to push data from a cube in one Planning environment to a cube in a another, separate Planning environment. I am loopi… -
Fastest way to export large filtered ASO data setWhat is the current consensus for the fastest method of exporting ASO plan type data? Assuming it could be a large data set with dynamic members and would need to be fil… -
EPBCS groovy CustomCalcParameters script syntax issueHi All, I'm struggling with MDX syntax to calculate actual to Date using groovy CustomCalcParameters. Although when I use RHS part of the script Sum(TupleRange(([FY20],[…
-
Using Groovy, need to select upper level members to push data to other cubesSummary: Using Groovy scripting, when pushing to other cubes, need to select upper level members to push data. Content (required): Using Groovy scripting, we need to sel…
-
Cannot find a universal way to input Date formats via Data Grid BuilderSummary: Hi, We are working with data grid builder in groovy rules. We need to upload today's date once a modification is performed. Though, we are noticing different be…
-
Executing a Refresh Job from API Using Groovy Console Continuously Poll Status AssistanceSummary: I am trying to construct a script in Groovy (not a business rule on the EPM server, but rather a pure Groovy script to be run on prem) to leverage the Planning …