Groovy
Discussion List
-
Using Groovy to Pass a Smart List Value from form rows (need to pass WITHOUT quotes)Summary: Is there a supplemental Groovy function, or other technique, that can convert a pulled smart list value from a form WITHOUT quotes? Content (required): We are t… -
Ruleset Validates/Deploys and displays success message, but isn't runningSummary: We have a rule set of 5 rules that validates and deploys without issue. It is connected to an action menu item and when I select it from the right click menu, i…User_2025-02-11-06-55-16-264 21 views 2 comments 0 points Most recent by User_2025-02-11-06-55-16-264 Planning -
Which application type should we select upon conversion to EPBCS, Custom or Module?Our service was just updated, and we are ready to convert from PBCS to EPBCS. We have read the documentation (Converting a Standard or Reporting Application to an Enterp… -
Assigning value to a member derived from RTP (The member is not refreshed)Summary: we have an RTP Member which is refreshed. A child has been created under it using groovy method of add dynamic child in a different process and this member is n…
-
$value is being considered as variable in REST API get method (SharePoint Integration)Hi guys, I am trying to get data from a CSV file which is uploaded in SharePoint to EPBCS application. From Sharepoint REST API, using the following Source URL GET https…
-
How to use Groovy and REST API to filter and execute datamap, and set substitution variablesSummary: I want to find out if you can set dimension parameters when running a datamap using a REST API call in Groovy, in PBCS calc rules. Secondly, I want to know if s…
-
Removing a member using groovySummary: Hi, While designing a DataGridDefinitionBuilder can I remove a member from a Planning list ? builder2.addRow(['Entity', 'Account'], [['Lvl0Descendants("Entity")… -
Transferring a file from Inbox/Outbox Explorer to Data management using GroovySummary: Need to transfer file from Inbox/Outbox Explorer to Data Management using groovy in EPBCS. Content (required): Hi . I have a file in Inbox/Outbox Explorer as be…
-
Need to connect an On Prem Source to EPBCS using OICSummary: Need to connect an On Prem Source to EPBCS using OIC. Couldn't find much help online but wanted to understand that since we will be using REST API for the conne…
-
Grrovy : getting members with values from a datagrid.Summary: Grrovy : getting members with values from a datagrid. Content (required): Dears, I have been trying the following without success, but I guess I am pretty close…
-
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…
-
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…