Groovy
Discussion List
-
GROOVY SCRIPT FOR ASO data exportSummary: Hi All, I have writeen a Groovy script to export the level0 data from the ASO cube to a csv file based on few conditions. Account dimension is not a compression…Sreekumar Hariharan 651 views 17 comments 0 points Most recent by SuneelKanthala EPM Platform and Freeform -
EPM REST API SEND EMAIL V2 - Limitation in allowed characters or lines?Summary: Using REST API Send email v2. This does not trigger email when line exceeds >1 in Calc Manager (body of the email) Content (please ensure you mask any confident…
-
How to access file in DM Inbox using Groovy?Summary: How to access file in DM Inbox using Groovy? Able to access files in front end Inbox/Outbox explorer. Is it possible to access from DM Inbox or by default only …
-
EPM Automate Server-side script - Profile keeps lockingSummary: Using a EPM Automate Server-side script to execute Quick Mode rule for multiple periods in filters as this feature is still not there in Pipelines. The Business…NarayananS 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Finding current environment/application in GroovyI am trying to find what the current environment is (planning, planning-test etc) in a Groovy script so we can automatically switch of emails sent to user in test and de… -
How to search a string variable in Groovy for a specific part of a string.Summary: How to search a string variable in Groovy for a specific part of a string. Content: We're currently using an pipeline that triggers everyday and processes the f…
-
GROOVY FEATURE TO EXPORT DATA WITH ALIAS NAMESSummary: GROOVY FEATURE TO EXPORT DATA WITH ALIAS NAMES Content (required): Hi I am taking note of the new features of May 2023 for EPM Cloud. And in particular I am int…Alain Mathon 608 views 6 comments 0 points Most recent by Jonathan A Cohen EPM Platform and Freeform -
Why groovy rule for validation is not functioning properly ?Summary: We have an issue with the following Groovy rule validation command. In the current rule, the validation command "isMissing" is not functioning for the "Descript…Salma Mohamed 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Copy Version in EPCMCSSummary: Hi all, does it is possible to use the out-of-the-box copy version functionality in an EPCMCS application? I can only see the Copy Data Functionality, but i nee…
-
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… -
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 … -
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 …
-
EPM automate connectionSummary: Currently, in our Groovy business rules, we are using the EPM Automate login command to establish the connection and then execute EPM Automate commands // Login…Priyesh P. Rane 21 views 4 comments 3 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPM Freeform supportSummary: Does EPM freeform support Artefacts, Rules (Calc & Groovy) same as per Planning? Content (please ensure you mask any confidential information): Does EPM freefor…
-
Run pipeline using restapi in Groovy ScriptSummary: Hello guys, I'm trying to run a pipeline using Restapi in Groovy script. There is no error but i'm getting status 0 and it's not triggering to run the pipeline.…Makam Krishna Vamsi 333 views 11 comments 1 point Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
How to Copy Data from a combination to another combination using groovy in PCMSSummary: Need to Copy Data from a combination to another combination in a form using groovy in PCMCS Content (please ensure you mask any confidential information): Versi…Sri Harsha Panchumarthy 41 views 5 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Has anyone used server side epmautomate with a loopback (127.0.0.1) or "localhost" server name?Summary: I'm using a groovy script that uses server side epmautomate. In place of the the server name in the URL, I would like to use a loopback address like "localhost"…
-
Data push from PCM_CLC to PCM_REP using Groovy in EPCMSummary: Hi Team, I am curious to know if we can push data from Calculation cube(PCM_CLC) to Reporting cube(PCM_REP) using Groovy Script in EPCM. If anyone has tried ple… -
How to print the Duplicate data in a form in incremental order using groovySummary: Exporting the Repeated Data Combination in a form in incremental order using Groovy Content (please ensure you mask any confidential information): I want to pri…Sri Harsha Panchumarthy 21 views 1 comment 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
Business Rule behavior in PipelineSummary: Business Rule behavior in Pipeline Content (please ensure you mask any confidential information): Data Exchange Quick Mode Rule (EPM Automate Server-Side script…
-
Export specific dimensions from ASO cube to BSO cube using Groovy ScriptSummary: I've a script in groovy, basic script, it works but i need to remove a dimension that's in the row; Script: Cube cube = operation.application.getCube("CAPEX") c…
-
Need Calculation scriptsSummary: Our Company Contribution to Staff Association (1) Use the prior year’s actual contribution to staff association to forecast the contribution to staff associatio…
-
PBCS run an epm automate process through a groovy ruleHi all, i'm trying to run a epmautomate process into a ePBCS groovy rule. If i put the password into the code (or into a variable) as, for example: /*RTPS: {rtpUser}, {r…Enrico Amabile 132 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPBCS - what are the reasons for 200MB limitation for export file in EPBCS?Hi, Currently there is a limitation of 200 MB on the size of the export file when executing a Datamap in EPBCS via a Groovy Rule which is causing us a bit of a headache …AyandaKrumalo12 91 views 2 comments 0 points Most recent by AyandaKrumalo12 EPM Platform and Freeform -
OIC Gen3 Rest API to generate an OAuth2 token using EPM Groovy script.Summary: Can anyone help me as The OIC gen 3 only allows OAuth and while the EPM Groovy script facilitates only Basic and API key based authentication. Content (please e…Rahul VargheseRoy 31 views 1 comment 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
Groovy Pipeline execution - Variables are mandatory?Summary: Using a Groovy BR to trigger a pipeline (export mapping job) and it was working fine with no variables defined. When the rule was triggered today interestingly …NarayananS 11 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
Pipeline execution stop/resetSummary: When executing/invoking a pipeline (REST) from Groovy if in case the pipeline name is incorrect or if a param or comma is missed the pipeline keeps polling and …NarayananS 21 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
Groovy script error query threshold limitSummary: Hi experts, I have written a groovy rule using flexibleDataGrid to export the dynamic calc Parent members plus all stored sparse members to a csv file . while e…Sreekumar Hariharan 45 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle EPM Platform and Freeform
-
Groovy to access a file in Inbox/Outbox explorerSummary: Is there a way to access a CSV (precisely a metadata file) present Inbox/Outbox explorer using groovy? Intention is to Automate Metadata across apps Am able to …NarayananS 522 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Network Perimeter with IDCS - Issue with Clone and Groovy rulesSummary After setting network perimeters in IDCS, EPBCS cloning failContent Hello, we have just setup in our IDCS foundation primary instance network perimeters to allow…