Groovy
Discussion List
-
Conditional Groovy in a form comparing two accountsHello experts!! I have a requeriment to do, I have this form: And with Groovy I should get a validation in BALANCE row. My requeriment is if BALANCE is equal to C1290_CA…
-
File renaming issue in EPBCSSummary: I want to rename the file after unzipping the data export file. Content (please ensure you mask any confidential information): I tried several ways to schedule …
-
Dynamic Substring Function - Essbase Equivalent of FIND/SEARCH Function from ExcelSummary: We have a need to perform dynamic member name lookups with member names that are varying lengths (something outside of our control as they come from a source sy…
-
Decimal precision not working -groovy-csvwriter -datagrid exportSummary: Hi All, I am exporting datagrid to csv file(csvwriter) using Groovy script. The exported data has precision issues as below. For Example: In smartview, the data…
-
Groovy - How to exclude shared members from ASO createDataExporter()?Summary: HI All - I need to exclude shared members from a createDataExporter() ASO data export. Would the best way way be to create two lists : List 1 with the members f…
-
Is there a way to automate updating data map member mappings?Summary: We have a cross pod data map with member mappings. There is no ability to do dynamic member maps so we need to manually update it every time a new member is add…
-
Using groovy to move a file from the Data Management Inbox To the Oracle Planning Inbox ExplorerI am working with OTBI report(s), and this report holds master data which needs to come into EDMCS. OIC is being used as the facilitator from Oracle Fusion into the Orac…
-
Changing background color to cell in data froms using GroovySummary: Requirement to change the background color for a data cell based on certain condition Content (please ensure you mask any confidential information): Hello, We n…
-
Ruleset parallel execution issueSummary: Content (please ensure you mask any confidential information): Hi, I got a weird issue when running a ruleset with parallel execution enabled, and want to seek …
-
Error When Saving DataGrid in Production - "An error occurred while processing this page"Hi Folks, I have encountered an issue when calling the saveGrid() method to save a DataGrid in the production environment, which works fine in the cloned environment. He…
-
data export 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…
-
Utilizing UDA Members (Level 0/Parent Members) in Data Export via Data Integration Filter or GroovyWith Data Export in Data Management (Data Integration in Planning): We are experiencing difficulties in applying a filter condition for data export using UDA. The requir…
-
Update Resource Class Dimension Members Parent via GroovySummary: I am looking into the best way to update Resource Class member's Parent value via a groovy script. The reason would be to move from an ACTIVE parent to an INACT…
-
User Preferences retrieval using Rest API (uservariablevalues)Summary: I am using the following REST Resource to retrieve user variable values set for all users and all user variables: GET /HyperionPlanning/rest/{api_version}/appli…
-
Need a way to set Date Value in a Flex Form with an After Load Groovy RuleSummary: Hi, We are designing a Flex Form that displays in SmartView the current value of a Date field, taken from a different POV. To do so, we implemented a groovy rul…
-
Smartview Add Comments is Spinning for Some Users in Remote DesktopHello Oracle Community, We are facing an issue with Smartview where the Add Comments feature is spinning indefinitely for some users, specifically those working in a Rem…
-
Hide Columns validating a condition through groovySummary: I would like to validate a condition of row member and hide columns which does not satisfy that condition. Content (required): Looking for a groovy logic to see…
-
Groovy check rtps for comma and throw errorSummary: I am looking to add logic to an existing Groovy rule we have that adds dynamic children to our projects hierarchy. I need to add logic that checks the rtps.rtp_…
-
Groovy to transfer data between cubeSummary: I planned to transfer headcount data between cubes by using groovy. Content (please ensure you mask any confidential information): I have tried to use datagrid …
-
How to affect UDA to members in account dimension ?Hello, We need to affect UDA to members in account dimension thanks to the webform, where : a user can input value "1" in a particular cross of dimensions, including mem…
-
Groovy Dataexporter is not exporting Dynamic Calc membersSummary: Hi, I need to export data from EPM Planning BSO cube with "Alias". So I need to use Groovy Rule because Data Export Calc command BR create Member Name in file. …
-
Issue with getEmailAddress() Method in Oracle EPM Groovy: "Email Doesn't Exist" ErrorHi Folks, I'm encountering an issue in Oracle EPM when using the getEmailAddress() method of the User class in Groovy. When I call operation.user.getEmailAddress(), I re…
-
Groovy in Essbase 21CHi all, Sorry if I am posting the question in wrong platform. But, I did not find any better community than this. Although I have worked on EPM applications, I got curio…
-
Dynamic Children and Groovy saveMember questionSummary: Content (please ensure you mask any confidential information): Hi, With Dynamic Children enabled for a "Dynamic Calc" parent, and use Groovy(non-REST API) to ad…
-
Form Validation using groovyHi, I am trying to match two separate set of columns using groovy. (Yellow should match with Green section - the Green section is dynamic). If it's not match script shou…
-
Pipeline feature to copy file from unixSummary: Can we directly pull the file from unix box to epm inbox using Copy to Object Storage Job Type after setting up the External Web Service Connection Unixfile is …
-
how to automate a refresh member from data exchange with groovy rule?Summary: how to automate a refresh member from data exchange with groovy rule? Content (please ensure you mask any confidential information): We created a groovy rule to…
-
setRowFilterCriteriaSummary: Has anyone used the groovy dataExporter with .setRowFilterCriteria() specifying both single members and metadata conditions? I'm trying to create a data export …Nic Bonacci 44 views 2 comments 1 point Most recent by Nic Bonacci Financial Consolidation and Close
-
How to specify the column names to be exported from a cube using groovy script?Summary: We have recently added new dimensions into our Planning application. The downstream application doesn't need the new dimensions (2 of them) hence we need to upd…
-
Groovy Scripting in EPBCS ASO CubeSummary: Hi Guys, Have a requirement to do Currency Conversion(USD to CAD) within the reporting cube(ASO) of EPBCS. Currency Conversion should happen once the Data get l…