Allocations
Discussion List
-
PCM Custom Calculation querySummary: In EPCM; I am trying to create Custom Calculation rule to copy data across different Entity. The difference is in the primary Entity where the data is loaded it…Muruges89 41 views 2 comments 0 points Most recent by Risingstar27 Profitability and Cost Management -
Is there a way to display the Description of a rule in Model Documentation Report?Summary: I would like my Model documentation report to display the description under the rule name on the rule page. Is that possible?Michael C Stefanavage 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Error Message upon Deploying cube: Deploying Essbase Cube Failed. Cannot unlock olap file objectSummary: We have 3 power users in PCMCS. 1 Power User has the ability to refresh the database; 2 Power Users receive the following failed message: Deploying Essbase Cube…
-
Duplicate Member Names - Free form Planninghi All, In Free form planning application, I want to use duplicate member name (Across business dimensions). I know we can have duplicate member alias, but want to know …Sucharitnarang 31 views 1 comment 0 points Most recent by Mark Zacchilli-Support-Oracle Profitability and Cost Management
-
Substitution variables not captured in Calculation Statistics and AnalysisSummary: EPCM Application/Cube level Substitution variables not captured in Calculation Statistics and Analysis. Is this an expected behaviour in EPCM? This is useful fr…NarayananS 31 views 6 comments 0 points Most recent by Padmaja Srinivasan Profitability and Cost Management
-
UDA in EPCM ruleSummary: Can i use UDA in EPCM to filter on the source dimension? I am only getting Attribute option to filter on rules. Content (please ensure you mask any confidential…Nilotpal Bhaskar 39 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Scratch cellsHi I want to know about scratch cells role and what are the use cases for it also, what is the value for substitution variable. thanksSucharitnarang 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
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 …Vikasitha 31 views 1 comment 0 points Most recent by Mark Zacchilli-Support-Oracle Profitability and Cost Management
-
Custom Date column addition in EPCM to GL write back interfaceIs it possible to add a custom date column which represents last date of accounting period in the JDBI extracted .csv file? Another requirement is to get the new date co…Aashish Kumar-248418 41 views 3 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Profitability and Cost Management
-
Filters are not working on Rules for Attributes and UDASummary Filters are not working on Rules for Attributes and UDAContent Hi, It appears that when we use filters in Rules for Attributes and UDA the rule fails during run.…Parmit Choudhury-Deloitte 77 views 3 comments 0 points Most recent by Bhavani Gajula Profitability and Cost Management
-
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 23 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 33 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 122 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 41 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 25 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 84 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 113 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 76 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 62 views 8 comments 0 points Most recent by Luis Autrique Profitability and Cost Management