Allocations
Discussion List
-
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 82 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 81 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 51 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 71 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 61 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 85 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 264 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 71 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 61 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 61 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 161 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Rule Limit in EPCMSummary:We are currently looking to migrate from PCM to EPCM and the number of existing rules is around 4000. Can we have same rule limit in EPCM as well? Content (requi…Vikasitha 111 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Is allocation percentage against each entity stored somewhere in driver based allocation?Summary: In EPCM when driver based allocation is performed, allocation percentages are computed and amounts are allocated in background. Can we pull the allocation perce…Anantha Krishnan 71 views 2 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
Dimension Management in PCMCS through Smartview not availableSummary Dimension Management in PCMCS through Smartview not availableContent Hi All- We know we don't have the facility of dimension management in PCMCS through Smartvie…Amit Agarwal-158816 48 views 10 comments 2 points Most recent by NKW Profitability and Cost Management
-
Possibility to load in Reporting Cube in PCMSummary: We use PCM for allocating Cost. From a Reporting perspective, we have few details that are not involved in allocation, its mutually exclusive accounts, which we…Mary John-Oracle 41 views 4 comments 0 points Most recent by Mary John-Oracle Profitability and Cost Management
-
Multiple Periods using EPMAutomateSummary: Is there a way to run multiple periods in PCM using EPMAutomate. Content (required): Is there a way to run multiple periods in PCM using EPMAutomate. I cannot s…MyNameisMyName 61 views 7 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
Allocation rules take too much time in EPCM and throw a warning messageSummary: Some Allocation rules take too much time in EPCM and result in an error/warning message Content (required): I have encountered this issue in which allocation ru…Gomaa Abdel Hamid Mansy 191 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Using Filter in Rules increases the time to calculate in EPCMSummary: When we use a filter for one of the dimensions in the Rule, the time to calculate the rule goes into hours. Content (required): We have a model for one of our c…Rajen Patil 51 views 1 comment 0 points Most recent by Omar Shubeilat. Profitability and Cost Management
-
Rule Set Execution Time IncreaseSummary Rule sets execution from one month to the next periods doubled in time with the same dataset.Content Recently we have seen that our calculation times are increas…Cloud.EPM.TMH 55 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Change Period/Scenario/Year in PCMCS QuerySummary: Need help on automatically changing the Period/Scenario/Year in PCMCS Query. Content (required): Hi Friends. We have a script to calculate markup which runs a q…Amit Agarwal-158816 41 views 7 comments 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management