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
-
Groovy script to run ML calculationSummary: Dear Experts, Im trying to trigger the Run ML in pcmcs Via FCCS ODR Groovy, script validation is fine. "/rest/v1/applications/PCM/povs/2024_At_Feb/jobs/runLedge… -
I have traceability requirement in EPCM. Any design suggestion or recommendation to achieve this.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there any way to create allocation rules in custom cube in EPCMSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Groovy Script to start an Allocation RuleContent (please ensure you mask any confidential information): Dear Experts, I try to create a groovy script to start an allocation rule from Planning but always receive…
-
Clearing POV function in EPCMSummary: Hi there, Currently we have a rule set where the calculated data in Planning are getting transferred to EPCM. We have a rule which clears the data set in EPCM b…
-
PCMCS bug when we change Period = YearTotal in rule / to Period = Jan in global contextSummary: In PCMCS, we use a model with the YearTotal period defined in each rule for our Budget, because YearTotal is not accepted in the Global Context. When the Budget… -
MDX Member formula too long but no errorSummary: Hello all, when I enter below's MDX member formula in EPCM ASO Cube, it validates successfully and also the refresh database is successful and works fine. Howev…
-
Is it possible to assign security to a specific EPCM Model?Summary: The client requirement is that one user should only be able to edit, view, and execute Model 1 and User 2 should only be able to do those activities for Model 2…
-
Mass Edit "Replace member" feature in EPCM is not workingSummary: Mass Edit "Replace member" feature in EPCM is not working to remove a member. Previously to remove a member from Source/Driver, we used "Replace member" feature…
-
Level 0 Members in MDX (equivalent of @Relative)Summary: Dear All, I look for an equivalent of @Relative in MDX. My search only let me find Descendants and Level functions. Although for level function the documentatio…
-
How to define output cell in CASE Member FormulaSummary: How to define output cell in CASE Member Formula Dear all, I need to write a conditional rule to make sure all values on the parent member P1000 are 1. This 100…
-
CASE Statement-EPCMCSSummary: Hi All, How we write case statement in member formula Is this possible??? Can any one share some example from where I can refer. Thank in advance
-
Merge Incremental Cells and Compact CubeSummary: We are using Merge incremental slices (merge all into main slice) and there is improvement when using this, the cost of querying inc data also reduced from 0.9 …
-
EPCM - Divide by proper and improper zeroSummary: While performing an allocation if denominator encounters a proper zero and an improper zero how does the calc be treated/performed? Content (please ensure you m…
-
Unable to Refresh DB-EPCMCSSummary: Hi All, I am getting this error to refresh the DB. "Cube refresh failed with Essbase Cube: PCM_CLC, Error code: 1042017, Message: Network error: Timed out befor…
-
Multi Period & Multi Year Integration-RowSummary: Hi All, In My flat file Year and Period are exist in ROW and there are multiple period and multiple year existing in the same file and I want to load the file i…
-
Can anyone suggest an alternative to PCM Queries in EPCM to extract data in a specific Adhoc formatSummary: Can anyone suggest an alternative to PCM Queries in EPCM to extract data in a specific Adhoc format. We have a requirement to extract nearly 40,000 lines of dat…
-
PCM_Adjustment InSummary: Hi All, I want to allocated my cost which is store in PCM_Adjustment In but when I create normal allocation rule and run the rule it take PCM_Input member value…
-
PCM to EPCM migration Data POV issueSummary: While performing, PCM to EPCM migration, the status shows in progress for a long time and doesn't proceed forward when we included Data POVs, but the report is …
-
EPCM allocation from parent to child, is it possible in only one allocation rule?Summary: Let's say we have a product dimension with 2 levels: brands (parents BRAND 1, BRAND 2, BRAND3...etc) and products (lev 0) We need to allocate some costs we have…
-
Custom Rule cannot be enabled because it has failed Validations. Invalid dimension memberSummary: I have a member name with periods e.g. 3543.1001.100004. I can use this member as source, target, driver in Allocation rules. However, I cannot use this member … -
Export Data RuleSummary: Hi All, I am looking for some document link for how to create export data rule in EPCMCS from Data Exchange interface in .csv format. Thanks in Advance
-
I get an error adding duplicated members from UISummary: I'd like to add duplicated members across different dimensions. Content (please ensure you mask any confidential information): I'd like to add duplicated member…
-
Rule **** cannot use the Scratch Cells removal enhancement, this option is disabledSummary: Receiving this error message on Allocation rule that has previously had no issues: Rule ''****'' cannot use the Scratch Cells removal enhancement, this option i…
-
Data ExchangeSummary: Hi All, Is there is any webinar or workshop conducted by oracle for Data Exchange topic. Can any one share the Link. Thanks in Advance.
-
How do I copy rates from one member to multiple members with UDA?Summary: Attempting to copy rates from a default department member to departments with a specific UDA Content (please ensure you mask any confidential information): It f…
-
Need help in writing member formula in ASO cubeSummary: Trying to write a member formula for an account member but it's not working Content (please ensure you mask any confidential information): Trying to write a mem…
-
Unable to refresh members from source (EPBCS) application in an EPBCS to EPCM integration.Summary: In Data Management I am unable to refresh members from the source application (EPBCS Reporting cube) after registering the EPBCS application. In error log it's …Sanchari Chakraborty-Oracle 171 views 4 comments 0 points Most recent by Sanchari Chakraborty-Oracle
-
Unable to use Rule dimension in EPCM to populate Journal Line Description in Integration with ERPSummary: We are sending data from EPCM to ERP as a single journal using Data Integration. The requirement is for the user to be able to see in ERP which allocation rule …
-
EPMAUTOMATE command doesn't exist to launch pipelineSummary: EPMAUTOMATE commands are not available to launch Pipeline. Content (please ensure you mask any confidential information): Unable to launch pipeline job. Version…