Allocations
Discussion List
-
Alternate Offset LocationContent Hi, What is the relevance of using Alternate Offset Location in Rules. It is clear that when we use this option, data from Offset Location member combination ref…Mohit Pahuja 69 views 5 comments 1 point Most recent by Harish Kumar C 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…
-
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
-
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
-
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 -
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
-
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 …
-
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
-
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…
-
Does EPCM Custom Calculation supports String Operations on left side (Target) of the script?Summary: Targeting the results to certain ICP Dimension members ICP_**** from an alternate hierachy of Product Dimension whose parent will be CP_****. Content (required)…Sivavignesh V 61 views 2 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Can allocations be triggered using Data pipeline in EPCM?Summary: Is there a way to trigger the allocations within EPCM using Data Pipeline? If yes, could you please help with steps? Content (required): Version (include the ve…Himani Jena 53 views 2 comments 0 points Most recent by Mark Zacchilli-Support-Oracle Profitability and Cost Management
-
Calculation Manager enabled in ePCMCSSince last (08.23) patch calculation manager is available in EPCM test applications version 23.08.60. Is this expected? Is this specific to MDX scripts, or are groovy sc…EPM2000886 111 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
PCMCS Custom Calculation error: Unable to allocate resources for cube PCM_CLC for 10800 secondsSummary: Using dynamic calc member in the custom calculation to calculate stored member Content (required): Hi, we have a requirement to calculate YTD value and use that…User_S3H04 73 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
Use multiple cubes for cost allocation in EPCMSummary: Hi, I am exploring an option to use multiple ASO cubes in EPCM for separate types of allocation. If anyone tried, can you please share potential risks or downsi…Smit Shah 63 views 8 comments 0 points Most recent by Luis Autrique Profitability and Cost Management
-
PCMCS Export data using query not showing AliasesSummary: PCMCS Export data using query not showing Aliases Content (required): Hi, I am trying to export data using query from PCMCS. Even though I select Use Aliases, t…Amit Agarwal-158816 31 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management -
Transfer Pricing EPCM vs FreeformSummary: We are contemplating between EPCM vs Freeform for our Intercompany extension (transfer pricing) needs. Content (required): We need to fetch data from ERP fusion…getgaurav 83 views 1 comment 0 points Most recent by Al_DuqueEstrada Profitability and Cost Management -
Custom Allocation with IF condition in PCMCSSummary Syntax for Custom allocation using IF conditionContent Hi Everyone, I have a requirement in PCMCS where custom allocation should happen using if condition. can s…Avinash B-140267 231 views 4 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
EPCM partial allocation based on driver?Summary: Can you allocate part of the cost pool but based it off the specific driver (instead of using the percentage on definition page)? Content (required): For exampl…Steve Gan - HCG 66 views 1 comment 1 point Most recent by Aman Kothari-191377 Profitability and Cost Management -
How to automatically assign the non allocated amounts (PCM)Summary: We have a model that allocates (entity, cost center, accounts) to two other dimensions (Dim 1 and Dim 2). Content (required): We want to automatically put the n…KleePerf 62 views 4 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management -
How can I verify allocation rule calculation output/see intermediate results/source contribution?Summary: I am looking for a report which displays the calculation path / intermediate results for every output cell of EPCM allocation rules. Basically a deeper look in …
-
EPCM - Automation of Allocation and Custom calculation Rule multiple times with different PoVSummary: I have a scenario where set of data with same attributes but different PoV(actuals of previous month YTD and forecast values of current month PTD) are loaded fo…Anantha Krishnan 52 views 2 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
How to use driver data from another period when Period is a PoV dimension? (blocker)Summary: I have a scenario where my driver data for current month cost allocation is revenue amount of previous year YTD trial balance. Since period is a PoV dimension a…Anantha Krishnan 41 views 4 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
How do you create Allocation using Headcount as a Driver using an offset destination for the DeptSummary: Allocation uses department (LOB) to be allocated to other dept (LOBs) by Headcount Content (required): Source = one LOB, Destination = Multiple LOB, offset = di…
-
Rule limit for EPCM PCM_CLC cubeCan there be more than 2000 rules that can be configured within the EPCM application for a single model? Is there any impact to the performance? Content (required): Vers…Himani Jena 164 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management