Groovy
Discussion List
-
Groovy to change background color for Dimension member simultaneously with cell backgroundSummary: Content (required): I need to change background color of dimension member background also with cell background Please guide with the groovy code to do the same … -
Cell color for editable cell onlyCell color for editable cell onlySummary: Cell color for editable cell only Content (required): Groovy rule for Cell color for editable cell only Version (include the version you are using, if applicabl…
-
Pass user variables from one POD to another - possible?We have a client with multiple business processes - I am trying to see if it is possible to pass user variables from one business process to another for the user that is… -
[Data Management] Is there a way to dynamically name the export file based on the run year?Summary: Hi everyone, We are extracting data from our Planning application for an external PowerBI dashboard using the "Data Export to File" target application type. Bec… -
Workforce Planning: FTE larger than 1Content Hi, The default range of FTE for adding requisition is 0 to 1. Our client has a requirement to expand this range. I changed it to -100 to 100 in both the custom … -
Dynamic update of Metadata with discarded items from FDMEEContent Hi all! I'm working on PBCS and I'm triyng to understand if it is possible, using groovy, to create some dimensions' members dynamically during and FDMEE data in… -
Groovy datagrid builder addcolumnContent Hi, I am trying to use DataGridBuilder to post values to the database. when I statically pass values to addcolumn it works okay. builder.addColumn('12356','37460…
-
Does Oracle University have any course on Groovy script development for EPBCS?Summary Does Oracle University have any course on Groovy script development for EPBCSContent Does Oracle University have any course on Groovy script development for EPBC…
-
Groovy to save Json or csv in Data Management InboxSummary Groovy to save Json or csv in Data Management InboxContent Are there anyway to use Groovy scripting within the application to save the HttpResponse as a csv or j…
-
Groovy to Get Metadata from Action Menu RowSummary Running a business rule from action menu on a row in a form and need to get metadata from that row.Content I am writing a custom employee transfer rule in groovy… -
Delete Existing Shared Members through a script in EPBCSContent Hi all, I'm looking to delete all existing shared members from the hierarchy under a single parent. How would I do that using a Groovy script? Any help is apprec…
-
Groovy rule calling RESTAPI PLAN_TYPE_MAP - not workingContent I am working on a groovy rule to call a REST API for running a data map. I would skip the API and use a smart push, however I want to bypass dimensional security… -
Update Data Map definition with groovySummary Can the definition of a data map be alter with groovyContent We have a need to allow a power user to execute a data map. It cannot be a smart push because the am…User_2025-01-30-02-55-20-807 49 views 4 comments 0 points Most recent by User_2025-01-30-02-55-20-807 Planning -
Is there a way to pass entity selection as RTP for data load rule in data integration?Content Team We have two separate instance like Finance and workforce due to security reasons. As part of monthly business activities 30 brand users are supposed to send… -
What's New in 21.07?Summary Better late than never for me to post...Content Yes, I know I'm 2 weeks later than normal. Sorry if you haven't been able to sleep at night awaiting this post bu… -
REST RulesSummary RestContent Hello, I am trying to run a simple BR by calling it using REST. It seems that RESTAPI code validates and runs but I don't see it running in the jobs …
-
Groovy Scripting combining 2 Lists using .UniqueContent We have a groovy script that identifies the Entity members that changes in a form when saved. We will then loop through this list of changed Entities and come up…
-
Groovy check if rtps enteredValue is empty; then exitContent Hi, I wonder what is the easy and proper way to check if RTP value is empty, then the groovy script will quit or exit without doing the rest of code. The attache…
-
Execution of MDX for ASO CubeSummary Execution of MDX for ASO CubeContent Hi All, We are loading a specific KPI via Data Management into ASO Cube. But this data needs to be multiplied by 1000. This …
-
EPBCS Financials how can I use OFS_Trend Based Calculation on custom Form?Content Hi all, Tried to use the OFS_Trend Based Calculation on a custom form but apparently runs but does not produce any results. I use some custom driver accounts on … -
What is recommended approach - Financial Statement reports - with FRS tool in Oracle GL or with EPMSummary What is recommended approach - Financial Statement reports - with FRS tool in Oracle GL or with EPM toolContent Looking for some expert advice about the best app…
-
Need to Delete Empty Blocks via Groovy RuleSummary Restructure & Clear Cube Not WorkingContent Hello, If possible I need to delete empty blocks from a BSO cube using a rule. The ClearBlock All function is not doi…
-
Groovy Rules Attached to Forms have a 2-3 second DelayContent We have Groovy Rules attached to our data entry Forms with the Form residing in Dashboards. Upon Save by the user, the groovy rule is executed. We have noticed r…User_2025-01-28-20-34-08-444 27 views 2 comments 1 point Most recent by User_2025-01-28-20-34-08-444 Planning
-
EPBCS : Copy parent level data to Level0 Members having Multiple generation sparse dimensionContent Hi All, We have a Department hierarchy (Sparse Member) with multiple levels/generations. We have loaded data to the department parent members with the top down T…
-
What's New in 21.06?Summary More cool ways to enhance your Oracle Cloud EPM experience!Content Wow, here we go with another monthly update! First, KScope is rapidly approaching, so be sure …
-
Can we define cell level security in EPBCS near futureContent Team , Business requirement is to define cell level security. Is it possible to do as standard security definition in EPBCS. Using Groovy, it will make cell as r…
-
Error on Groovy error Message: expected type found .Summary Converting rule to groovy rule. Rule fails to write RTP value to member. Trying to write text string entered through RTP on Action MenuContent I have a working r…
-
Getting smartlist values in groovyContent Hi, Would anyone be able to share an example of groovy where they check for a smartlist label value (or even an id) please. I am trying to use getDataAsSmartList… -
PBCS Data Integration AutomationContent Hi, we are planning to use EPM Agent and created Data Integration which directly connects to on-prem SQL server and loads to PBCS cube. Looks like we can run the…
-
Groovy to validate sum of each row should be 100%Content Hi, I wonder if anyone could share with me some sample Groovy script on this most typical usage, to check the summation of values in each row should be 100% I'm …