Groovy
Discussion List
-
Using Groovy in EPBCS to export data from EDMHello everyone, I am doing step by step to set up the Groovy rule to import metadata from EDMCS to EPBCS based on this guidance: https://www.oracle.com/webfolder/technet… -
How to use groovy script to run the allocation in PCMCS and how to load driver data using groovySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Is it possible to set attribute value from SL value?Summary: Is it possible to convert SL Value and attach it on attribute dimension. Can we do it using groovy, if yes could you please share code snippet. Content (please … -
Getting error Cannot find matching method java.util.Date#format(java.lang.String, java.util.TimeZoneSummary: Getting below error for one of the Groovy scripts in Groovy Script Validator. But we can validate and run the rule without issues Cannot find matching method ja…
-
Automation Mechanism for Approval Status SynchronizationHi Gurus, I am seeking an automation mechanism that will allow the approval status of an entity in PBCS to change based on the approval status of the same entity in FCCS…
-
Data push for large volumeContext: We need to push ~12–15 million records from a Source ASO cube to a Target ASO cube within the same application. Standard data push and Groovy-based export/impor…
-
Delay in calc manager to recognize new Smart Lists/Variables?Summary: I created a new SmartList within Planning and new Variables in Calc Manager. The SmartList isn't showing in the options for variables and the variables are givi… -
Metadata Integration between EPM Cloud ApplicationsSummary: How to integrate metadata between EPM Cloud Applications? How to transfer metadata files to other EPM applications? Content (required): Hi all, between two EPM …
-
Groovy script validatorHi Community Folks, As released by Oracle in August patch, while using Groovy script validator, I am getting below two compile errors in some of my groovy scripts writte…
-
Deleting file from Inbox/Outbox Explorer using REST APIHi all, We are trying to delete a csv file from Inbox/Outbox Explorer using the below REST API https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-co…
-
Groovy: Essbase Error(0) Invalid member nameHi all, I am trying to retrieve the date from a combination using DataGridDefinitionBuilder and extract year, month and day from it. The approach might be a bit long but…
-
how to extract Integration period in EPM Agent using GroovySummary: I am trying to extract the period for which that integration has executed , Content (please ensure you mask any confidential information): Version (include the …
-
Data workbench export to excel optionSummary: I tried to export workbench data to excel Content (please ensure you mask any confidential information): I have received a requirement from a user to export wor… -
Exporting Supporting Details to CSV via GroovySummary: Hello, I'm looking to see if there is a way to export Supporting Details/Line Item Details from EPBCS via Groovy in a CSV. As of right now we have a process of …
-
ChatGPT API IntegrationSummary: Posting a small groovy snippet to allow chatGPT API integration. This is meant as a bit of fun with no practical applications at the moment. You will need to ge…
-
Is there a way in Groovy to throw an error message with line separator in error promptSummary: Content (please ensure you mask any confidential information): Hi Experts, Is there a way to include line separators in error messages when using Groovy? I'm cu…
-
Run More Than One Calc Script in Groovy ScriptSummary: I am trying to run multiple pieces of calc script from one groovy script. It is executing the first piece essCalc1 and then the data push that is after essCalc1…
-
Attribute dimensions in FlexibleDataGridDefinitionBuilder?Summary: Do FlexibleDataGridDefinitionBuilders allow the use of attribute dimensions? Content (please ensure you mask any confidential information): I've been told multi…
-
EPM Planning : Multiple File/Report download into Local system/EPMA ServerSummary: I am using a combination of executeReportBurstingDefinition, exportLibraryDocument & downloadFile EPMA commands to download few Reports in the EPMA Server.Now I…
-
How to remove attribute from the member using groovySummary: Hi , I am trying to remove custom attribute from the member using groovy. I can see member being removed from memberproperties but it is still showing custom pr…SrikanthReddy-Oracle 45 views 4 comments 0 points Most recent by Viorel "Van" Andritoiu-Oracle Planning
-
Shared Members Showing as Dynamic Calc in Groovy toMap() MethodSummary: When filtering Alternative Cost Center Hierarchy members by "dynamic calc" using toMap(), shared members are unexpectedly included in the results alongside true…
-
generate report from NR on the EPCMSummary: Triggering burst Definition to generate report from NR on the EPCM application by using Rest API but the groovy is not working. Content (please ensure you mask …
-
Cannot see Log Messages tab in Calc Manager after running a groovy rule?Summary: When I run a groovy rule in calc manager I am not getting the Log Messages tab pop up but would love to be able to see these sorts of statistics. Content (pleas…
-
Using Groovy to update a member property for Storage, individual cube properties aren't updatingSummary: A Groovy script that builds a map to create a member in a hierarchy is not properly updating member properties Content (please ensure you mask any confidential …
-
Send email with report as attachment from the document librarySummary: I have generated different reports in the document library in PBCS using a bursting definition. Now, I want to send those reports to users through email and att…
-
Groovy to read a text fileUsing REST API I've managed to trigger my integration and get the job id, status and log file. I would like to read this log file in Groovy. I only see reader functions …
-
Unable to load Date, Data Type account through datagrid in groovy scriptSummary: Originally loaded to the same account as a Text data type with no issues. changed to Date and now not working. Hoping it's an application setting i'm missing? C…
-
Can this be optimized further?Summary: Hey All, just wondering if this can still be optimized without changing some of the parents to Dynamic Calc?. My Aggregation rule for actual data is taking appr…
-
Still no way to reliably run a Cube Refresh from a Groovy Business Rule?I know it's been asked in the past but checking to see if anyone has come up with a solution. I'd like to run a metadata update along with a cube refresh from a business… -
Is there a faster way—such as using Groovy—to retrieve all users' Smart View versions?Summary: I’m looking for a way to obtain the Smart View version for all users. Content (please ensure you mask any confidential information): I am trying to retrieve the…