Rules
Discussion List
-
EPCM Substitution Variables for OptimizationSummary: Hi Team, I am just curious to explore various substitution variables available in EPCM for better optimization. Request to share if you have used in any of your…Harish Kumar C 11 views 1 comment 0 points Most recent by Harish Kumar C Profitability and Cost Management -
Mass Edit features not workingSummary: No features on the Mass Edit screen are working. Content (please ensure you mask any confidential information): Has anyone experienced an issue where the Mass E…SAW23321 23 views 1 comment 0 points Most recent by Mark Zacchilli-Support-Oracle Profitability and Cost Management -
Allocated Amount Type: Percentage-- End User Update?Pretty sure this isn't possible. We will have quite a few allocations that simply take X% of the pool and allocates it to a specific intersection, and an offset to a dif…Peter Joelson 25 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
EPCM - Managing Filters for Source and Destination MembersSummary: Not able to input a member name in the filter Content (please ensure you mask any confidential information): I am trying to utilize the Filter to exclude certai…
-
Support of MDX Functions in PCMCSSummary: Hi Team, I just wanted to check if mdx functions such as CurrentMember, CurrentMember.lag(1) are supported in PCMCS? These functions are tested in EPCM and seem…Harish Kumar C 22 views 0 comments 0 points Started by Harish Kumar C Profitability and Cost Management
-
Mass Edit "Find member" feature in EPCM is not workingSummary: Mass Edit "Find member" feature in EPCM is not working to find a "Same as Source" member when the field is left blank. We recently migrated from PCM to EPCM and…Marmitchell 11 views 3 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Job Comments not captured in Calculation Statistics and AnalysisSummary: Job Comments that are provided to model executions are not captured in Calculation Statistics and Analysis. Is this an expected behavior in EPCM? Have seen this…
-
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…
-
Use of Substitution variable in Custom Calc in EPCMSummary: Substitution Variables used in Custom Calcs are not working though rule shows as Valid. Content (required): We have a use case where we need to calculate the Cu…Kapil K Nankani-Oracle 141 views 3 comments 1 point Most recent by Raama Rao-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
-
Export and Import to a file Rules, Rule Set and Model's in EPCMSummary: The objective is to automate the creation, alteration and deletion of Models, Rule Set's, and Rules (usual artifact to configure and allocation rule and grup of…Michel_MB_PwC_ADV 82 views 2 comments 1 point Most recent by Michel_MB_PwC_ADV 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 75 views 3 comments 0 points Most recent by Bhavani Gajula 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
-
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 125 views 12 comments 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management
-
In EPCM, is it possible to create rules and rule sets from excel / csv template?Summary: I know that we can migrate complete rules and models between instances. But I wonder if there is any tool to upload a new rule from scratch? Or we can only crea…
-
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 22 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 44 views 2 comments 0 points Most recent by Crystal Eide Profitability and Cost Management
-
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…
-
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…
-
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…
-
XML edit for a modelSummary: Incomplete changes in the model after XML import Content (please ensure you mask any confidential information): While using the XML export-make changes-import p…
-
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…SAW23321 31 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Groovy Script for Copy Data in EPCMSummary: Dear Expert, Need your help about groovy script. Right now, we are copying data from 1 intersection to another intersection using DATA COPY Feature in EPCM as b…
-
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
-
Is it possible to use User Defined Attribute (UDA) in Data Management for PCMCS?Summary Is it possible to use User Defined Attribute (UDA) in Data Management for PCMCS?Content Hello experts, I want to build a a DLR in Data management to export data …Parmit Choudhury-Deloitte 134 views 5 comments 0 points Most recent by Gary Popielarczyk Profitability and Cost Management
-
Essbase Error(1260052): Syntax error in input MDX query on line 1 at token ','Summary: Essbase Error(1260052): while running Calculation Content (required): I have been running validation of custom calculations rule and got the following error. Ca…User_IPP4R 202 views 5 comments 0 points Most recent by Raama Rao-Oracle 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 174 views 4 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management