Groovy
Discussion List
-
Json ArrayI have requirement of writing JsonArray data which is pulled from a wen API to a csv file Rest API url : Json array : [ { "id": 1, "name": "Leanne Graham", "username": "… -
Cross Pod Data Map - Dynamic Wildcard Mapping from Source to Target in Groovy/Smart PushSummary: We have a need for a cross-pod Smart Push to push data from a cube in one Planning environment to a cube in a another, separate Planning environment. I am loopi… -
Fastest way to export large filtered ASO data setWhat is the current consensus for the fastest method of exporting ASO plan type data? Assuming it could be a large data set with dynamic members and would need to be fil… -
EPBCS groovy CustomCalcParameters script syntax issueHi All, I'm struggling with MDX syntax to calculate actual to Date using groovy CustomCalcParameters. Although when I use RHS part of the script Sum(TupleRange(([FY20],[…
-
Using Groovy, need to select upper level members to push data to other cubesSummary: Using Groovy scripting, when pushing to other cubes, need to select upper level members to push data. Content (required): Using Groovy scripting, we need to sel… -
Cannot find a universal way to input Date formats via Data Grid BuilderSummary: Hi, We are working with data grid builder in groovy rules. We need to upload today's date once a modification is performed. Though, we are noticing different be…
-
Executing a Refresh Job from API Using Groovy Console Continuously Poll Status AssistanceSummary: I am trying to construct a script in Groovy (not a business rule on the EPM server, but rather a pure Groovy script to be run on prem) to leverage the Planning …
-
DataGridBuilder security issueSummary: Hi, We have a rule using DataGridBuilder to do some calculation and save data back. When the rule is executed by users, data didn't get saved back. Then we figu…
-
How to upload file to inbox in EPBCS using REST API through groovy Business Rule?Summary: we are trying to upload file to inbox in EPBCS using REST API through groovy Business Rule. we are struggling on how to define the file path which is on the ser…
-
Is it possible to display a custom message when saving on a form?Summary: I would like to display a custom message after saving the form that notifies users that they need to run another step. Content (please ensure you mask any confi…
-
Groovy MDX script to get HTD valueHi Folks, Can you please help me writing MDX script in groovy to calculate HTD value or at least YTD value. Below script is throwing error: A method called by the script…
-
Planning Provider Error occurance when linking Custom Measure and standard measure in Measure DmHi Oracle Support, We created a custom measure called "Current Target" under the Measure Dimension for sales planning. Our goal was to reference this standard measure us…
-
Delete file from Outbox folderSummary: The file extract (Applicationname_1234.dat) is generated under Outbox folder. "1234" is Process ID. I am able to successfully rename the file while uploading it…
-
Running Groovy rule; could not retrieve the rule execution statusContent Hi, I was creating a simple groovy script to select a list of accounts which have certain UDA. It's pretty much the same as the example shown in a blog. https://… -
Run "Export Projects and Budget" job from GroovySummary: Hi, The "Export Projects and Budget" job can only be executed by an administrator and I'd like to give an option to run the job for power user. I've tried to ru…
-
Using for loops in Data definition builderHello, Using Data definition builder I'm trying to Display the dates in a certain combination and it's working when i tried using for loop it is throwing an error. This …
-
RTP Window not getting closedSummary: RTP Window not getting closed and data form not displaying completion status. Content (please ensure you mask any confidential information): Upon saving data fo…
-
Using groovy to set substitution variables for non admin users - REST API connection issueSummary: when we run below business rule, getting below error message, could you please check and update us. "Details: A method called by the script failed on line: 40, …
-
DataGridBuilder errorSummary: Hi, Got a weird error when building a DataGridBuilder. Here's the code snippet: /*RTPS: {RTP_Year} */ String str_Year = rtps.RTP_Year DataGridBuilder gridbuilde…
-
Can I only format background color for a cell in a data form using Groovy ?Summary: I have only found a way to change background color for a cell in a data form, but can I also e.g. add borders and change the color of the text ? Content (requir… -
Debug Groovy ScriptHi everyone, I've a groovy script based on depreciation and the logic its wrong, can i debug a groovy script?
-
Can't pass variable text into a template for use in a Planning expressionSummary: I have a groovy rule that executes a calc that references a Template. Here is a snippet: String ApproverMsg = '"' + "This is a Test" + '"' Calc =""" %Template(n…
-
Using groovy to set substitution variables for non admin users - REST API connection issueSummary: we are using groovy to set substitution variables for non admin users, but we are getting below issue , Could you please guide us. A validation error was receiv…
-
How to create a shared Member dynamically using groovySummary: I have created a groovy which will create a dynamic member under the parent A, and that is working fine. Now I want to create the same member as shared member u…
-
get attribute values associated with a member using groovySummary: I'm trying to get the attributes value associated with a member. But somehow I'm unable to make it work. I need the value to be stored in some variable for furt…
-
Groovy - awaitCompletion - An error occurred while processing this page.Hi all, Hope you guys are doing well. We are trying to use REST API to trigger a data integration from Calc Manager (EPBCS application). We have created the connection, …
-
send email using groovy scriptHello, Can anyone send me the sample code to send an email using groovy script. I have gone through some restapi files but didn't get the output. This is the code that i…
-
Groovy ASO Allocation Rule.Hi there, if anyone has any Groovy ASO allocations template please share. Thank You -
Groovy: Data map for Power UsersContent Hi all We are doing a groovy calculation to send data from BSO cube to ASO cube, and is working fine but it seems that only admin users can run a Data Map, and t… -
Error using startsWith function in IF condition within FIX ENDFIXHello, I'm trying to put an IF condition within FIX ENDFIX in an EPBCS groovy script. Need to execute the set of statements if a Custom dimension member starts with a pa…