Groovy
Discussion List
-
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… -
Member relationship function to replicate "exclude" in form designContent Is there a member relationship function that can replicate the "exclude member" functionality in Planning form design? Looking to use the function in export data… -
Passing RTP within a groovy rule calling the REST API to clear cubeSummary Unable to figure out the correct syntax to pass the rtps into the HashMap - Groovy Business Rule calls "Clear Cube"Content Hello, I have a groovy rule that calls…
-
Grid spread - for multiple dimensionsContent Can we use grid spread where users wants to adjust data at top level members of three sparse dimensions (Entity/Plan element/Custom) and two dense dimensions ( A…
-
How to get current user security information in groovySummary We want to maintain Data Form row/column access based on the user RoleContent Hello Groovy experts, We have business use case where certain rows need to be read-… -
ASO Cube - Copy Data between PoVsContent Looking for a solution to copy data between PoVs (for example copy data from Actuals to Forecast) with in an ASO Cube. Version 21.03.60
-
Create a table from DataGridDefinitionBuilderContent Hi all, We are trying to create table with groovy (to include in an email message) based on a DataGridDefinitionBuilder. What is the best way to do this? The dat…
-
Update Substitution variable using GroovyContent Team, Is there a way to override the substitution variable values (OEP_CurMnth & OEP_CurWeek) for a specific rule set to execute without impacting other processe…Suresh Ratnala-Oracle 370 views 3 comments 1 point Most recent by M. Kyle Goodfriend-Oracle Planning
-
Groovy to retrieve data from EssbaseContent Hi Can somebody throw me some light how to get value from Essbase for a specific member combination? A very simple example will be much appreciated. I know how t…
-
Cube Refresh using groovy post update the metadata using Groovy ruleContent We are updating the Entity dimension attribute tagging using groovy rule. Post the update, cube refresh to be done. I don't find function to cube refresh using G…Suresh Ratnala-Oracle 221 views 5 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Determine if a user belongs to a group via GroovySummary The Groovy Class User does not provide a method to determine if a user belongs to Group.Content Is there a way to check if a user belongs to a certain group from… -
How to use Groovy validate if a text type cell is not emptyContent I have simple requirement to check if there is value in any period for a particular Account, there should be some remarks in the Comment field as well. The simpl…