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.
Profitability and Cost Management
Discussion List
-
Cannot Clear Partial Data. Essbase Error(1200503): Duplicate dimensions in a tuple in function [TUPLHello everyone, I tried to run Calculation for July but it showed the error : when I tried to run calculation for June, it ran successfully. How to fix this issue? Thank… -
Duplicate dimensions in a tuple in function [TUPLE CONSTRUCTOR] on line [2]Hello everyone, When i ran the model calculation, it showed the error: "Unexpected error from essbase or insufficient data privileges. Cannot Clear Partial Data. Essbase…
-
modify the timezone in PCMHello everyone, When I ran the calculation and open the Job Library to trace, I found that it showed incorrect timezone (for Start Date and Endate): So my question is: W…
-
How to activate audit in oracle epm cloud profitability and cost managementHello, is there a way to track all actions done by users on pcmcs (EPM Cloud Profitability and Cost Management), even those that have been deleted by console job? Thanks -
In EPCM, is it possible to create rules and rule sets from excel / csv template?Summary: I know that we can migrate complete rules and models between instances. But I wonder if there is any tool to upload a new rule from scratch? Or we can only crea…
-
Can Power user access restricted and not allow dimension and Designer screen?Summary: I have got to download csv file from Data Management Inbox using REST API service, for the same provided the user with Power User Role, But Customer needs to re…
-
Offset not working?We have an allocation whose offset is not happening. We tried initially to offset it to a specific location in order to match the design needs. But we could not get that…
-
Are there technical specs available for the file based import method under data integration?Summary: Is there a technical doc that outlines the EPM system controls used in the file-based integration method? Content (please ensure you mask any confidential infor…
-
Unable to Execute Business Rule via EPM Automate in EPCMSummary: we are trying to execute a business rule (a custom Groovy Script) in EPCM via epm auomate command as per below doc. But it throws an error saying "Not supported…
-
Rule Dimension sync issues between Front-End and Essbase in EPCMSummary: Getting error while running rules in EPCM related to Rule dimension member sync up Content (please ensure you mask any confidential information): We are getting…
-
Examples of Custom Calculation Rules scriptsSummary: Content (please ensure you mask any confidential information): Hi all We want to know if we can use ALL the MDX functions for EPCM or if there are ANY limitatio…
-
Using Multiple Periods in calculations?We have a requirement to use a basis which is calculated from all open periods of a year (FcstMnth:Dec). Is there a good way to calculate this in EPCM? We need to divide…
-
Can we push allocated data from EPCM to ERP as journal backSummary: Can we push allocated data from EPCM to ERP as journal back. if yes please let me know what is process and what all we can do? Content (please ensure you mask a… -
are special characters in Multi Dimensional Mapping allowed in ePCM?hi, the below 2 articles seem very conflicting. in the first one: "the target values for multi-dimensional mapping must be an explicit member name. Wildcard or special c…
-
What is the best way to store archive results in PCM?We have a requirement to store and maintain 10 years of archive results for external audits for PCMCS. We are unsure if the Archive Snapshot saved off locally will be co…
-
Calculation of Model using Processing Range = All Rules also deletes data from other Models.Summary: When calculating the Model using Processing Range = All Rules the process also deletes data from other Models. Content (please ensure you mask any confidential … -
EPCM with Approval Flow and Task ManagerSummary: How to set up EPCM with Approval Flow and Task Manager? Content (required): I try to set up an EPCM process with a guided process like in task manager and to sa…
-
How to quickly select all members with assigned attributeSummary: In my Source selection for a rule I want to include only members of my Product dimension that have a certain attribute attached. There are roughly 100 that have…
-
Create grouping nodes in PCM_Rule dimensionHello, Our Customer want to regroup the PCM_Rule members in grouping nodes. Is it possible? If yes, is it recommanded given that this is a technical dimension? We are us… -
REST API to execute Multiple POVs does not return all Child jobsSummary: REST API to execute Multiple POVs does not return all Child jobs Content (please ensure you mask any confidential information): When executing calculation for M…
-
Removing members from selectionWe have multiple examples where we have to remove multiple members, or even entire hierarchies from the selection. We noticed that you aren't allow to remove more than o…
-
Including alias in data exportSummary: How to get alias into data export Content (please ensure you mask any confidential information): We have a job in Data Exchange that exports our data to a flat …
-
Cell level security in EPCMSummary: Hello all, Does Cell level security works in EPCM? Has anyone worked on that in EPCM? Content (please ensure you mask any confidential information): Version (in…
-
Is there a way to create Counterparty transactions in EPCM?Summay: For EPCM Transfer Pricing based Application, we want to create counterparty entries of Transfer Pricing Results. Content (required): If Transfer Pricing Results …
-
What's the best way to automate the process of running a rolling forecast data for 18 months in EPCMSummary: Hi All, I have 18 months of rolling forecast data from EPBCS, and I need to automate the monthly allocation process for the next 18 months. I want to avoid hard…
-
ASO Optimize AggregationSummary: Content (please ensure you mask any confidential information): Hi All, I have a few questions regarding the ‘Optimize Aggregation’ job in an ASO cube. When push…
-
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…
-
Data Integration - Create Application ErrorI am trying to create an application in data integration. The category is EPM Cloud. I complete all the information, but when I click the spinner to the right of Applica…
-
Cube not deployed warning while running the calculations- possible reasonsSummary: What are the different reasons/scenarios for getting the warning 'Cube is not deployed'? Content (please ensure you mask any confidential information): I unders…
-
Purpose of using EPCM_GOVERNORS_OVERRIDE_KEY variable in EPCMSummary: Hi, Request anyone to let me know the purpose of using EPCM_GOVERNORS_OVERRIDE_KEY variable in EPCM. It would be helpful if any resource link is shared for the …