Groovy
Discussion List
-
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…
-
PLAn: groovy script request an IP connectionSummary: Content (please ensure you mask any confidential information): Hi all We migrated recently to OCI and we have a firewall for which we opened various IPs and all… -
createRowData in PBCS groovy throws - An error while processing pageI am attempting to use Groovy to create a RowData object as part of an data import process. However, I am encountering an error message that states "An error occurred wh…
-
groovy script for Copy DataSummary: Summary: Dear Expert, Need your help about groovy script. Right now, we are copying data from 1 intersection to another intersection using DATA COPY Feature in …
-
Is there a way in Groovy to getEvaluatedMembers / get ancestors with Administrator permissions?Summary: Would like to know if there is a simple way of using getEvaluatedMembers (or similar) with admin permissions, to pull back names of members in the hierarchy des… -
Not able to validate if condition with member of SmartList data type when comparing with integerSummary: I have written very simple formula in free form application, where my cube Hybrid BSO. I have created a dynamic calc member MemberB with member formula mentione…
-
How to delete only descendant members of a parent in EPBCS using groovy scriptWe have a requirement to delete Purchase requisitions every time we load the transactional data. To achieve this we want to use a groovy Business rule to delete the desc… -
Create & Import a Snapshot via Groovy Rule (Valid Intersection Automation)I have been trying to find a way to do this as a way to try and automate the creation of valid intersections at a client. Ideally, I am trying to complete the following … -
Error with a Groovy codeHello, I am trying to validate the data on Form load event. But getting an error which is not very clear. PLease advice! Error: A method called by the script failed on l…
-
Groovy - Using getEvaluatedMembers with Shared MembersSummary: I am attempting to generate a custom metadata export file using Groovy to feed into some reporting solutions. We want to be able to generate a clean csv that ha… -
Is it possible to invoke rest from a groovy template?Summary: I have done an api call from a groovy business rule and it works fine. If I use the same code within a template, it gives me 403 forbidden error. Is there a lim…