Groovy
Discussion List
-
How to get the name of the item in a smartlist entryHello everyone, Because of the security of the Cost Centre dimension, we need to create a smart list entry that contains all the cost centers in Cost Centre dimension by… -
Groovy Scripting : Set Attribute of Custom Field Based on the Value of Standard FieldIn relation to my previous inquiry Groovy Scripting: Split / Trim, I have made it work. However, since formula text field cannot be displayed to OTBI analysis report, I … -
Triggering OIC integration while uploading changes via VB excel pluginSummary: Hi, We are using VB Excel plugin to update the BO based on which the plugin designer is configured. I need to trigger an OIC integration when we click on upload…
-
Raise a predefined or custom message (Multipart Validation Message) via Groovy in CX SalesIn the CX Sales application we can create new messages, or see predefined messages via Setup and Maintenance → Manage Messages task. Their Translations can be managed vi…
-
What is the View Object to use for creating new Lookup Code for Standard Lookups, via Groovy Script?Summary: I need to programmatically create a Lookup Code for an existing Standard Lookup Type via Groovy Script. I have found some sample scripts from Oracle documents, …
-
Groovy - how to print real-time log message in job console?Summary: Hi, I have a Groovy rule with long-running processes, for example the process needs to be iterate through 100 times for different combinations. I need to watch …
-
Required a code in groovy so that if the first BR is running second BR should wait for the first BRWe are using the export and import method as we need to manipulate the file because of the mapping of dimension between two cubes.Data has been doubling when we are runn…
-
How to schedule to run the report and send it via email?Hello everyone, I want to schedule to run a report in EPBCS and send it via email. Is there any function that can help with this requirement? I tried to find it in the J…
-
Groovy setSuppressMissingSuppressesZero never workSummary: Hi, With a groovy rule to build a grid like below for reading data FlexibleDataGridDefinitionBuilder gdb = cube.flexibleDataGridDefinitionBuilder() gdb.setSuppr…
-
Not able to retrieve smart list values from datagrid.datacellSummary: Hello, we need to retrieve smart list values from a grid. The smart list has entry ID of 1,2,3 and corresponding label and Names. we need to retrieve the name h…
-
How to use Groovy to create unique set of multiple chart string values via a single GridHello, I'm trying to build a Form and Groovy Script that will allow a user to update multiple "Transaction IDs" simultaneously within a Form. The form is built with a sp…
-
ASO Custom Calculation vs. Graphical Editor DifferenceHi folks, I'm working in a custom EPM Planning app and trying to create an ASO business rule to calculate a percentage of total headcount. I can use the graphical design… -
How to restrict account records based on Business Unit ?Summary: Hi Everyone, We have one custom field in Account object called "Business Unit", It stores account owner's Business unit. Now one user logged in and he can able …
-
Get User Status in CX Sales CloudHello Team, I am interested in obtaining the user status, whether it's Active or Suspended, from the resource directory using a Groovy script. Is there a feasible method…
-
Groovy rule in pipeline failed to initialize Epm Automate instanceSummary: Try to attach groovy rule in pipeline Content (please ensure you mask any confidential information): I tried to put groovy rule in pipeline, but it failed to ca… -
Automate File Transfer from SFTP to EPBCSOur current process with OIC renames the file on SFTP(Example file name: Testfile_MMDDYYYY_HHMMSS to Testfile MMM-YY) and moves the file to EPM then deletes the file on …
-
OICS to load PPM Data in to EPBCSSummary Load PPM data using OICS in to EPBCSContent Hi All, In my current client there is a requirement to automate the data load from PPM to EPBCS. In the absence of di… -
Data Export with Pivot DimensionSummary: Hello Wizards, I have requirement to export BSO data (Non Num as well) to csv file with Account dimension on the column (Pivot). Expected Output (StartDate and … -
sample groovy script to create a record in custom Object using BIP report outputSummary: We have created custom object 'Plant_c' We have created a bip report that fetches the Plant report. Based on this we need to create record in Custom object. nee…
-
Automate file transfer from SFTP to EPMOur current process with OIC renames the file on SFTP(Example file name: Testfile_MMDDYYYY_HHMMSS to Testfile MMM-YY) and moves the file to EPM then deletes the file on …
-
Groovy rule in ASO is rounding off the values after calculationSummary: When performing a calculation on ASO using a Groovy Business rule a simple Unit*Price is resulting in an absolute value instead of giving the decimal values. Is… -
Groovy Scripting: Split / TrimIs there a way to split / trim a string? For example: sampleAddress@email.com I only want to display sampleAddress and remove the @email.com.
-
Error in groovy, The following Date is Invalid: .Hi all, we are trying to retrieve data from multiple projects in EPBCS in ASO cube we are using datagriddefinitionbuilder to read the data from the above accounts as bel…
-
How to Invoke Party Usage API using groovy script upon save ButtonHello Team, Once a Party is created we have to tag a default custom usage. I was thing of a groovy script where it can call Party Usage API to add the custom usage once …
-
Is groovy script supported in next gen sales - redwoodSummary: Object triggers are not working in next gen sales - redwood Content (required): Hi all, I wrote one before update trigger in activity object and it is working a…
-
Can you exlude members in a Groovy Data Export scriptSummary: We have a groovy script that moves data from one Hybrid BSO database to another. We have added an attribute value called "Entity_Closed" on Entity members that …
-
How do I use @ATTRIBUTE in business ruleSummary: Need a business rule using attributes to breakout costs into another entity/account Content (please ensure you mask any confidential information): I've used @AT…