Groovy
Discussion List
-
Groovy code questionSummary: How can I test for a value in one column in a grid and retrieve the value of the second column if it passes the test? Content (required): I have a grid iterator…Sabrina Greensea-166456 61 views 6 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning -
PBCS/Essbase: Problem to calculate some members, because a block is not created.Summary: Content (required): Hello experts, I have written the following code to copy the Close Balance of the previous year December into the Open Balance of the curren… -
Groovy addValidationError method limitation on dashboards?Summary: I have a simple groovy rule that runs before save that highlights a cell if a value is not entered. It works just fine when accessing the data form natively but… -
Error in Groovy Calc calling the Change Planning Unit StatusContent I am trying to use this command in a groovy calc. I have gotten other direct calls to the REST API to work with this connection. I have reviewed the help for thi…
-
"An unknown error occured" in groovy while accessing substitution variablesContent (required): Hi guys! There is a small issue. I am trying to access substitution variable which contains empty,Freeze,Freeze,Freeze as highlighted in the below im…
-
Groovy validationSummary: Groovy validation Content (required): I want to change color of nitaqat% if it exceeds required % I am new to groovy and not able to cross dim. Any help will be… -
Groovy to Validated data from another formSummary: I want to validate data from another combination and change the cell background. I have a form where User will input target % in No lob-no entiy etc combination…
-
Comparing 2 double values using groovy in EPBCSSummary: Need to compare grid values which are "double" data type using groovy Content (required): Hi all, Encountering a small hurdle in groovy. I have 2 values which a…
-
Accessing JSON file and updating it using groovySummary: Hi guys, Okay, here is what I have to do. I need to maintain JSON array in a file and modify it accordingly based on requirement. So, if it is possible, can you…
-
Is Database refresh required after member property update through groovySummary: we have enabled create dynamic member at parent level and performed a refresh. Post that we are able to achieve following activities through groovy without any …
-
Update UDA using API/GroovySummary Updating member UDA upon runnen calc ruleContent Hi all, For one of our customers we want to update (assign/remove) a UDA for the entity dimension, triggerd by a…
-
Making cells read-only On clicking the action menuSummary: Making cells read-only Making cells read-only after running the groovy rule in action menu. Content (required): Hi guys, I have the groovy rule which make the c…
-
Retrieving size of JSON key using groovy script in EPBCSSummary: Need to retrieve size of keys in JSON array using EPBCS groovy script. Content (required): Hello guys, I have the following JSON array: def json_str = """{ "101…
-
Issue with Groovy RuleSummary: The requirement is to transfer the data from one department to another and if in the target department entered headcount is more than available headcount in sou…
-
Groovy to change background color for Dimension member simultaneously with cell backgroundSummary: Content (required): I need to change background color of dimension member background also with cell background Please guide with the groovy code to do the same …
-
Cell color for editable cell onlyCell color for editable cell onlySummary: Cell color for editable cell only Content (required): Groovy rule for Cell color for editable cell only Version (include the version you are using, if applicabl…
-
Pass user variables from one POD to another - possible?We have a client with multiple business processes - I am trying to see if it is possible to pass user variables from one business process to another for the user that is… -
[Data Management] Is there a way to dynamically name the export file based on the run year?Summary: Hi everyone, We are extracting data from our Planning application for an external PowerBI dashboard using the "Data Export to File" target application type. Bec… -
Workforce Planning: FTE larger than 1Content Hi, The default range of FTE for adding requisition is 0 to 1. Our client has a requirement to expand this range. I changed it to -100 to 100 in both the custom … -
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…
-
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…
-
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…