Groovy
Discussion List
-
How to refresh a form using a groovy rule?Summary: How to refresh a form using a groovy rule? Content (required): Dear all, I've written a Groovy rule to add some complex control before saving data. This rule is…Alain Mathon 32 views 5 comments 1 point Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning -
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…srikanth grandhe 22 views 7 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
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…
-
What's New in 21.08?Summary More cool things plus some favorites of mine!Content Well, here we are again and I'm back on my normal release date as 21.08 is set to hit your test environments… -
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… -
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…
-
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…Brian Somers 24 views 6 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning -
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?
-
Who is Registered for Kscope21 User Conference?Summary ... all the smart people!Content KScope is, in my opinion, the best Oracle EPM User Conference available in terms of number of EPM-specific deep-dive and technic…
-
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…