Groovy
Discussion List
-
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 500 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 254 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…
-
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 M. 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 89 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…
-
What's New in 20.12?Summary Wrap-up for a Strange YearContent Well, this concludes a strange year (to say the least) but one with lots of new features. We've snuck several more for this mon…Mark Rinaldi-Oracle 208 views 5 comments 6 points Most recent by User_2025-02-08-03-53-41-891 Planning
-
Rest API to set member alias?Summary Can a member alias be updated via Groovy / Rest API?Content I have a request to allow users to change the alias of a member. I was pretty sure it was possible. I…User_2025-01-30-02-55-20-807 42 views 2 comments 0 points Most recent by User_2025-01-30-02-55-20-807 Planning
-
execute data map as admin but triggered by power userContent Is it possible to execute data map as admin but triggered by power user using Groovy rule?
-
Linear programming within EPBCSContent Hi all, For one of our clients we want to use linear programming methods to get optimal values for some planning problems (like solver in Excel). Are there ways …
-
Add a hyperlink to an EPBCS Dashboard to execute a business ruleSummary Dashboards - Is it possible to include a hyperlink to a Commentary block?Content I have a request to have a hyperlink to execute a business rule from a Dashboard…User_2025-01-30-02-55-20-807 37 views 2 comments 0 points Most recent by User_2025-01-30-02-55-20-807 Planning
-
Could a non-admin user move a structure member?Summary Would like to allow non-admin users to move members using a groovy ruleContent We have a request to create a business rule which will move a member in a particul…User_2025-01-30-02-55-20-807 27 views 4 comments 1 point Most recent by User_2025-01-30-02-55-20-807 Planning
-
Show a member description/alias on a formSummary With the member name on a form how best to show a description/alias on screenContent Hi, We want to be able to surface the alias/description of a member on the f…
-
Copy data from ASO to ASOSummary Copy data from ASO to ASO using Data ManagementContent We have a custom workforce app (our company is too big for the delivered module) which has multiple BSO an…User_2025-01-30-02-55-20-807 549 views 12 comments 0 points Most recent by User_2025-01-30-02-55-20-807 Planning
-
Need an calculation command/essbase function which calculates the number of days for a monthSummary Need an calculation command/essbase function which calculates the number of days for a monthContent Hi This is with regards to rolling budget in Planning. We are…
-
How to optimize aggregation process in Planning using Groovy in Non-Hybrid ApplicationsSummary How to optimize aggregation process in Planning using Groovy - Full Aggregation (BSO)Content We have an EPBCS non Hybrid Application. As the application is not H…
-
Groovy script to run only on valid cellsContent Greetings! We have a form where we have valid and non-valid rows (set via valid intersection). Our groovy script is working for all the accounts present in the f…