Groovy
Discussion List
-
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… -
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…
-
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…
-
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…
-
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…
-
Groovy error: calc script too longContent I'm trying to run a Groovy script to execute a calculation but the calc script is too long: The Groovy script failed to compile with internal error: Compile Erro…
-
Groovy Grid Iterator/cell.updated doesn´t work sometimesContent Hi all, In a few processes we use the Grid Iterator in Groovy to check if a cell was updated in order to just recalculate that specific point of view. in 99% of …
-
Different Security for BSO/ASO plan typeSummary How to set up different security for ASO & BSO plan typesContent I'm aware that in EPBCS the security cannot be set up at the Plan Type level. We have a situatio…User_2025-01-30-02-55-20-807 22 views 6 comments 0 points Most recent by User_2025-01-30-02-55-20-807 Planning -
Capturing Rejections In Data ManagementContent Hi , I have a requirement where i need to capture the rejections/Missing members during the Export from Data Management and send mail notifications for the same.…User_2025-02-07-09-27-55-736 30 views 5 comments 0 points Most recent by Kyle Goodfriend-Oracle Planning
-
Referencing a Member Range within a Groovy Script VariableContent Hello There! I'm trying to create a dynamic data push after running a data load within my BSO cube. The data load can load multiple periods ie from Jan - Mar or …User_2025-01-31-02-27-25-352 91 views 7 comments 0 points Most recent by User_2025-01-31-02-27-25-352 Planning
-
Using Dimension Feature with Smart List functionality has Security ImplicationsSummary Custom intra/inter segment charge process that references target "Charge To" by using Smart List featureContent We created a custom inter/intra segment charging …User_2025-01-31-02-27-25-352 52 views 13 comments 0 points Most recent by User_2025-01-31-02-27-25-352 Planning
-
Insufficient User rights Save Member OperationContent Hi all, In one of our rules we update the UDA of members in the entity dimension. This rule needs to be executed by the planner users, however they are getting t…