Groovy
Discussion List
-
Rest of Year Period MemberSummary: Content (please ensure you mask any confidential information): I'd like to create a ROY (rest of year) member in my period dimension. It should be first forecas… -
Clearing of partial data failed ASO cube with groovySummary: Clearing of partial data failed: Syntax error in input MDX query Content (please ensure you mask any confidential information): hi all, trying to clear partial … -
What's New in 20.08?Summary ... some exciting stuff, as usual!Content Okay, so I'm about a week late with this post this month. I hope you haven't been having withdrawals, pacing your home … -
Groovy script not performing the bursting definition jobSummary: I need to perform a bursting definition job in NR for which the Groovy script has been developed in the EPM planning. We have established the connection for the… -
getPassword() not working what i am doing mistake here.Summary: Trying to get username and password and want use for epmautomate but getting error for getPassword() Content (please ensure you mask any confidential informatio…
-
Groovy script to save Username and Transaction date informationIn Data Form, the User inputs data and saves the Form. Using the Groovy script, I want to save the Username and Transaction date in members from Plan element Dimension i…
-
Groovy script error with IP listSummary: Content (please ensure you mask any confidential information): We are getting this error using a groovy script: Error method called bu the script failed on line… -
How to get the number of entries in a smartlist?Summary: I am trying to export the data from a smartlist to a csv file but I can't get the number of entries dynamically, does anyone know how to do it? in this example …
-
email address using GroovySummary: Fetch the email address using Groovy Content (required): Hi all Would like to find out if anyone was successful in finding out the user's email address from the…
-
Automate Creating Mappings in Data ManagementHello All, For Account Dimension, when we launch an Integration from EPRC, and finally in log of the Process details there are members that are not mapped / or don't exi… -
Exporting a custom MR report from Library to Inbox/Outbox ExplorerHi all, Good Day! We have a report developed for our client as shown below. So, is there any possibility of pushing this report to Inbox/Outbox Explorer in PDF format us…
-
How to check if member exists in Account dimensionHello experts, I have a requeriment to do. In my account dimension I have two hierarchies. First one has nevershare members like this: 600001 / 600002 / 600003 / 700001 … -
Reading a Data Integration Log in a Groovy Script to get the list of kickouts.Summary: Can we read the data integration/data management logfile in a groovy script to read the kickouts from the log and email them in a separate file? Content (please… -
Is there a way to turn of RestDataGrid Data Changes from being posted into Audit as DataSummary: We use Groovy/Rest rules to move data within Cubes and also sending data to and from Cubes. All of these transactions of sending data are being recorded in the …
-
How to create multiple members via Groovy ?Hello All, We are trying to create 50 members via groovy : from "Projet_1" to "Projet_50". For that I'm using this script (published by Shehzad KAZMI) : Instead of creat…
-
How to get a code of member from SmartList via Groovy?Hello All, We are trying to create members via groovy, and for that we created a webform with the Business Rule Groovy attached which creates members in a dimension and …
-
Groovy with hyperion planning 11.2.xHello, Is Groovy supported with hyperion planning 11.2.x ? Some references say no : https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=459791523767627&id=… -
Iterate through RESTapi resultsSummary: I return the result from the pbcsClient.listFiles command and it is in JSON format, ---{"details":null,"status":0,"items":[{"name":"apr/2023-11-01 03_09_116/acc…
-
How to notify users about non-existing members after intégration of data (Data Management) ?Hello All, my best wishes for 2024 ! :) We would like to notify users about non-existing members (errors after Data Integation/Data Management). Could you tell us please…
-
Consolidating FIX StatementsSummary: Content (please ensure you mask any confidential information): I have an out of the box/implementation rule that has multiple FIX statements. Can I consolidate …
-
unable to do the Data Export in ASO cube using groovy scriptSummary: The issue with the Groovy code can anyone please help me to resolve this Content (required): In the BSO cube, we can export the data using below Groovy Script t… -
Clearing ASO cube on RTPs with GroovySummary: I am new to EPBCS and Groovy. I have a requirement to clear partial data from ASO cube by users on recurring basis. I am trying to write a business rule which u…
-
Data Integration Export by EndUsers and SSOSummary: Situation: Data Management is currently used to allow 5 dedicated endusers to export Data for their respective entity for 15 different scenarios (categories) an…
-
updating custom attribute using groovySummary: I am trying to update custom attribute based on the value user selects in smartlist.Basically in the form, user is allowed to choose Approval status. On saving …
-
Export Datagrid to flat file that doesn't use a comma delimiterSummary: I am trying to export data from the Capital Projects reporting cube to a text file, using a DataGrid. The groovy operation to do so is operation.exportDataToFil…
-
Referencing a formula column in form while using the data grid cell iterator in groovySummary: Is there a way to reference a formula column that is on the form, while we iterate using operation.grid.dataCellIterator().each Content (please ensure you mask … -
Groovy BR REST API Send Email v2 AttachmentsSummary: Groovy business rule to send email using v2 is working except attachments. Content (required): Cannot seem to get the parameters syntax correct. Version (includ… -
append to a csv file.There was an error rendering this rich post.
-
Send a fancy looking email with a data gridI've been using sendMail with embedded html tags to send formatted emails for a while now but a came across a new challenge. I need to be able to send a data grid but fo… -
Groovy Rule: Submit Date TypeSummary Submitting values to an account of date type rejectedContent In a groovy rule, using a DataGridBuilder, values submitting to an account of Date Type are being re…