Category 146
Discussion List
-
System Report in EPCMSummary: Need information on how to create the System report in Enterprise PCM Content (required): I am trying to create a System report (Rule Details) in the EPCM envir…Rajen Patil 61 views 3 comments 0 points Most recent by Bhavani Gajula Profitability and Cost Management -
Allocation Rule fails because Essbase Error(1013295): Server Request Fails with error code [1200601]Summary: Dear experts, I created a normal Allocation Rule in EPCM and it works usually. Today, it always runs on an error ErrorAllocation Rule 'ALLOCATIONRULENAME' faile…
-
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…Sreekumar Hariharan 142 views 11 comments 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management
-
Allocation In is calculated but corresponding Allocation Out is not getting calculatedSummary: In a model for a few Rules, Allocation In is calculated but for the same Rules corresponding Allocation Out is not calculated where the 'Offset' is at the Sourc…Rajen Patil 22 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
EPCM Precision issue while allocating dataSummary: While allocating data, the Allocation In and Out values are not matching and giving out minor difference (upto 0.20) which is summing up to give out a huge diff…Vikasitha 22 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
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…Nilotpal Bhaskar 31 views 2 comments 0 points Most recent by Nilotpal Bhaskar Profitability and Cost Management
-
How to use Substitution Variables in Data Management-EPCMCSSummary: Hi All, Is this possible to use Substitution Variables in data load mapping?. Let say we already run 12 month data for working version and now we want to copy 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…Mueller 121 views 12 comments 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management
-
PCM: Can we assign Security to Rulesets in PCM?Summary: Hi All, We wanted control rules set by the security group for power users. I couldn't find any documentation or articles. Any thoughts or pointers? Content (ple…SenthilSSN 22 views 1 comment 1 point Most recent by Old_School_DCom-Oracle Profitability and Cost Management
-
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…Frank_Fec 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
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…
-
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…Vikasitha 42 views 2 comments 0 points Most recent by Crystal Eide Profitability and Cost Management
-
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…
-
Pipeline LimitationSummary: Hi All, Is there is any limitation of job under one stage. Let say in one stage how many job admin can added?? And in one pipeline process how many stage admin …
-
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…Hema R 21 views 1 comment 0 points Most recent by Old_School_DCom-Oracle Profitability and Cost Management
-
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 …
-
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…Mueller 187 views 4 comments 0 points Most recent by Luis Autrique Profitability and Cost Management
-
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
-
Is it possible to reference PCM_Rule as a source dimension in an allocation rule?Summary: Content (required): Hi. I have a custom calc rule that moves dollars from multiple markets to a single market prior to allocating the dollars. I would like to u…SAW23321 81 views 7 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Allocation Amount (Operating Expenses - Revenue) in PCMCS AllocationsSummary: Content (required): Hi All, We have a need to reference the account (Which should be the result of Expenses – Revenue instead of Net Operating Income (Revenue -…Ashok Kumar Raya 83 views 12 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
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 …Dinesh Chand 62 views 4 comments 0 points Most recent by Dinesh Chand Profitability and Cost Management -
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…Avtar 22 views 1 comment 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management
-
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…Vikasitha 22 views 3 comments 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management
-
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…
-
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…Sreenivas Rayala-Oracle 32 views 1 comment 0 points Most recent by Narayan Profitability and Cost Management -
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