To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Planning
Discussion List
-
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… -
oracle epm narrative reporting, can I choose a specific day for running reports. e.g 31/12/2022Summary: My client wants the ability to run a report, and the two grids on the report show for example, 31st June 2023, and the second grid to show 31st Dec 2022. Is thi…
-
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…
-
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…
-
Smart View on premise text member causes error when converting to cloudSummary: We have a client migrating from on-premise to cloud EPBCS. Many of their smart view files have text members imbedded in the grids that match member names in the…
-
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 …
-
Change the time zone inside Pipeline or Data Integration log filesSummary: How can we change the time zone inside log files created under Process Details when a Pipeline or Data Integration job is executed. Content (please ensure you m…
-
export data from epbcs ASO cube using BRContent Hello, Is it possible to export lvl0 data from epbcs ASO cube using business rules? I know the way to export from overview->actions, export data and same by usin…