Category 101
Discussion List
-
MDX Calculations with Custom Groovy Scripts In ASO Cubes.I want to write a Groovy Script in ASO cube, that should execute complex calculations involving multiple operators across various dimensions. Can anyone provide any sugg… -
Can not attach business rule in Data IntegrationSummary: Can not attach business rule in Data Integration Content (please ensure you mask any confidential information): Hello all, We tried to attach a rule in Data Int… -
Disable Oracle EPM Cell attachment featureHi All, About the Smart View Attachments feature, we can Right-click on a cell in an ad hoc sheet and click Smart View >> Cell Attachment to attach a file. Can I disable… -
Planning report from 2 sourcesSummary: Is it possible to create a report or form that pulls from 2 different cube sources? Content (please ensure you mask any confidential information): Trying to cre…
-
What are the ways of exporting Dashboards 2.0Summary: Hello , What are the ways of exporting Dashboards 2.0 ? Can someone please assist . Content (please ensure you mask any confidential information): Version (incl…
-
Pipeline GET Call errorSummary: Pipeline POST is successful but trying to get the status of pipeline jobs and says error occurred while processing this page. The error appears same for any 'it…
-
Read csv file using groovy scriptSummary: Hello all Below is the requirement I'm trying I have a csv file in inbox/outbox explorer which has data in a particular combination. Example : A1 jan 2024 = 100…
-
Is there a governor on EPM Cloud Rest API calls?Summary: I'm exporting several data slices from a Planning cube in rapid succession using the Rest API. Usually the data is returned in about 500ms but, seemingly random… -
Forms 2.0 - Add Project - Adding extra day on Start and End DateHi, Does anyone experience an issue where you enter a Project Start Date and Project End during project creation and created project has extra day added on those dates? …
-
Return a stored smartlist value as string?Is there a non-groovy way to return a stored smartlist value as string? For example, let's say I have stored smartlist value: CarMake→Begbalance = "Ford" I'm trying to r… -
Exisitng vs create a new control budget to support EPM to ERP budgetary Control integrationSummary: Content (please ensure you mask any confidential information): Hi All, We are integrating budget data from EPBCS (Module based) to Fusion ERP. Our client is cur…
-
Json ArrayI have requirement of writing JsonArray data which is pulled from a wen API to a csv file Rest API url : Json array : [ { "id": 1, "name": "Leanne Graham", "username": "…
-
Cross Pod Data Map - Dynamic Wildcard Mapping from Source to Target in Groovy/Smart PushSummary: We have a need for a cross-pod Smart Push to push data from a cube in one Planning environment to a cube in a another, separate Planning environment. I am loopi… -
Fastest way to export large filtered ASO data setWhat is the current consensus for the fastest method of exporting ASO plan type data? Assuming it could be a large data set with dynamic members and would need to be fil…
-
Webform 2.0 - Period dimension in the rows expands on POV changeSummary: I have idescendants(YearTotal) in the row of a form with "Start Expanded" unchecked. The webform open with YearTotal collapsed but when I change the POV the for…
-
How to edit work flow notification header for particular DOR type in oracle fusion HCMSummary: We need to update the Header Subject of bell notification, Previously we are having like ( A Document Record (Document Type, )) Created for Employee Name), But … -
EPMAutomate disconnects after 10 minutesSummary: Content (please ensure you mask any confidential information): Hi all Our client using EPMAutomate, have noticed that they get disconnected after 10 minutes eve… -
Are there new changes for creating blocks in business rules?Hello, we noticed that some of our calculation logics do not work anymore as expected and are wondering whether some updates from Oracle to the database could be the rea…
-
What is the "Set Current Period and Year" Options?Summary: What is the "Set Current Period and Year" option in the Period dimension of the Classic Dimension Editor? Content (please ensure you mask any confidential infor… -
Listing of all possible upload locations and their uses for EPBCSSummary: I'm looking for a listing of all possible upload/download locations and their uses for EPBCS. For example, locations such as inbox/outbox etc for use with EPMAu…
-
How to perform Data Integration without using Period Mappings?Summary: If the linked data contains Year and Period information (columns), we would like to perform Data Integration using the data in these columns without using Perio…
-
Excel array formulas and Adhoc Smartviews?Hi, Do excel array formulas work with adhoc Smartview? We are using Office 365. When we refresh an adhoc smartview (23.1) with an array formula it changes the array form…
-
Difference between Revenue/opex/capex working version and OEP_Working version?Hello everyone, When I enabled modules in Planning, it generated many related versions: But what's different purpose of these versions? Hope there are some documents abo…
-
How to get dimension security groups working in the new reports module?Summary: The new reports module seems to not enforce dimension security and our users are able to see entities outside of their security group that's assigned in the dim…
-
Management Reporting: Function for Trailing Twelve Months (using Range & Period Offset NOT working)Summary: I have a TTM (trailing twelve month) P&L report that works perfectly when i pick any period except DECEMBER. When I pick December, it gives me some strange outp… -
EPBCS groovy CustomCalcParameters script syntax issueHi All, I'm struggling with MDX syntax to calculate actual to Date using groovy CustomCalcParameters. Although when I use RHS part of the script Sum(TupleRange(([FY20],[…
-
power point slidesSummary: How to generate slide using data from EPM Cloud with a pov Content (please ensure you mask any confidential information): The use case asked by the users, is to…
-
assiging values to rtpSummary: Content (please ensure you mask any confidential information): Hi I have written the below script, but it does not work. basically i want the rule to run only i…
-
Using Groovy, need to select upper level members to push data to other cubesSummary: Using Groovy scripting, when pushing to other cubes, need to select upper level members to push data. Content (required): Using Groovy scripting, we need to sel… -
The Block size exceeded threshold. Error Threshold: 1000000, when I added the new members in AccountSummary: I have added under Account -> OWP_Employee Properties custom properties (fields in the form) for client. And faced with error Employee Properties OEP_WFP ERROR …