Groovy
Discussion List
-
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 …
-
Groovy to loop through and agg modified row membersContent Does anyone have an example of groovy that would loop through modified members of a row dimension and agg the ancestors of each?
-
What's New in 21.03?Summary A really big Enhancement!Content Well, to say I'm excited to share this post may be an understatement and I believe you may very well share my excitement! In fac…
-
Calling a Business Rule from a Groovy script (OWP_Add Requisition_GT)Content Hi, Our client has its own version of calculating Benefits and Additional Earnings; so we created a custom business rule ("HS_Calculate Benefits Additional Earni…
-
Idea Lab - New Idea Raised to include search field in Business Rules HomepageSummary Idea Lab - New Idea Raised to include search field in Business Rules HomepageContent Hi Friends - I have raised an idea in the Idea Lab to include a search field… -
EPM Cloud 21.04 - Check out new features added!!!Content Check out what new in EPM cloud release 21.04 - EPM Cloud 21.04 -
LSIBLINGS in GroovyContent Hi All, I'm trying to write a piece of code which could mimic the behavior of @LSIBLINGS in calcscript. I have a parent with a flat list of children under it and… -
Execute a rule from a tab in a navigation flowSummary Need to execute a business rule by clicking on a tab in a navigation flowContent Hi, We would like to be able to execute a business rule from a navigation flow t…
-
@ISATTRIBUTE("STORE") equivalent MDX functionContent We are trying to convert BSO member formulas to ASO, and we got stuck with @ISATTRIBUTE("STORE"). BSO formula: IF(@ISATTRIBUTE("STORE") AND (@ismbr("Rephased Bud…Suresh Ratnala-Oracle 77 views 7 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Business Rule is failing for multiple data entries, when data is missing for one of the dataContent Hello Team, Business Rule is failing for multiple data entries, when data is missing for one of the data. We got a response from support engineer as, "its workin…
-
EPM Automate command: runPlanTypeMap Override member selectionContent Can we overreide member selection for a given data to run using epm automate command: runPlanTypeMap. Using Groovy we can do that, but there is a limitation of 1…Suresh Ratnala-Oracle 54 views 4 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
SendMail API using Groovy - Quick TipSummary Blod Post - SendMail API using Groovy - Quick TipContent Link to the post. The goal of this post is to show how to send emails using SendMail API in Groovy busin…