Groovy
Discussion List
-
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…
-
Using getSharedMembers for cube specific shares?Summary: I am trying to find cube specific shared members using getSharedMembers since the documentation shows this should be possible, but I'm getting shared members fr…
-
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… -
Example of groovy code to send an email in EPMContent Hi, just wondering if anyone has some sample code for sending an email using groovy. If anyone has something they can share I would really appreciate it. -
Retrieve member alias for my DataExport File through DataManagementSummary Retrieve member alias for my DataExport File through DataManagementContent Hey all, I need to export on my data export to file, via Data Management, the member a…
-
Copy Percentages from different granurality dimensionsHello experts, I have a doubt about groovy/calc script code. I have to copy a percentages that I have with a specific granularity to another POV with other granularity. … -
EPM Groovy Table in Email, The Character & issue and EPM Groovy Short URLSummary: Is there a way to use Short URL/Hyperlinks in email? We desire to send reports (smart cut link) in email as a hyperlink and also with shortened URL. We are not …
-
Suggestion to update entity-currency mapping automaticallySummary: What is the best way to update Entity-Currency mapping automatically in the form. Smart list has been created from currency dimension. Is there any way to updat…
-
Is it possible to change the text color of a cell using validation rules?In Oracle PBCS, if I try to apply a validation rule that changes the text color of a cell based on certain parameters, it does not work. It seems that the only change th…
-
Error occurred in Groovy datamapsSummary: We've created a custom datamap using groovy, where We're customizing few dimension members. The script runs smoothly if we hardcode the Account members but fail…
-
Push Data Failed: Error - The member does not exist for the specified cube or you do not have accessDescription: Hello, I am encountering the following error when trying to push data from an ASO cube (source) to a BSO cube (target) in Oracle PBCS: Error: "Push Data fai…
-
Business Rule/Groovy Scripting to remove data in ASO at a specific intersectionSummary: Trying to determine if there is a way to create a business rule or groovy script which would clear data in ASO at a specific intersection utilizing members deri… -
Retrieving Base currency tagged to an Entity in EPBCS using groovyHi all, I am trying to retrieve Base currency tagged to level 0 entities in EPBCS application using groovy. As shown in the below image, for the respective level 0 entit…
-
Groovy Script is Failing with Expression exceeded the maximum number of new view instances (50)Summary: we are building Cascading feature for copying header bill to details to line level details with out Amendment for the lines where Interfaced flag is N we are en…
-
Automation of user variable limits/definitions?Summary: Is it possible to automate additions of new members in user variable definitions? Content (required): We have a number of user variables to assist in the limita…
-
how to retrieve the child job status for a Groovy DataImportRequestWhen executing a groovy rule using createDataImportRequest() the rule that calls the import will succeed even if the import fails. what is the way to check if the import…
-
Groovy failing while calling external REST API when adding date filtering conditionDear Experts, We have groovy script to generate csv file from RSET API json response. It is working fine when we don't have date parameter filter in REST API. The moment… -
Use Workforce OOB template/BR with RTPs and DTPs in a custom groovy scriptI have requirement where I need to Transfer bulk employees in the OOB WF module (Using the OOB BR OWP_Transfer, or the included OOB templates OWP_Transfer_T, & other 2).…
-
How to create a groovy rule to check for line returns in a text fieldSummary: We our trying to prevent our end users from entering a line return in a text data type member. Content (please ensure you mask any confidential information): We…
-
How to change the file name of data export to file processSummary:Hello, in PBCS, we have an integration to export some data, the filter changes, then, this data changes, how can we change the file name dynamically? Right now, …
-
The best way to get scenario start year for certain module by using groovySummary: I want to get Scenario start year & end year for workforce module by using groovy Content (please ensure you mask any confidential information): Hi All, I would…
-
how to establish a connection with an oracle database server using the REST API using groovyhow to use that connection to perform crud operations in groovy
-
How to set up the EPM agent for Groovy scriptingSummary: I have used basic functionality of EPM agent, i.e extracting the data from on-premise database to EPM cloud in ASYNC mode. now i trying to get data using the AP…
-
Looking for Groovy exampleSummary: I am looking for an example of a groovy script that will make columns read only depending on an account value that is derived from a Smartlist. In this form exa…
-
Copy No_Currency data to Local Currency based on Entity base currencySummary: Is there a way to copy No_Currency data to the respective Entity base Currency with out using UDA's or Attribute assignments Content (required): In a Simplified…