Rules
Discussion List
-
1Adding Member Matching Expressions in bulkhello - we are currently working to migrate from PCM to ePCM. We used the template to bring in all of our ruleset and rule configurations, but we do not see any option i…StevenRigby 26 views 2 comments 1 point Most recent by Don Bean-Oracle Profitability and Cost Management -
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 88 views 6 comments 1 point Most recent by BhavaniGajula Profitability and Cost Management -
Designer funsction: Same as source in targetSummary Can we have selecting Same as source option in Mass Edit?Content Hi All, Do we have a option of selecting same as source in multiple rules in Designer > Mass edi…Khushbu Premlani 32 views 2 comments 0 points Most recent by Alexey Jodzichski Profitability and Cost Management -
Write custom rule with NONEMPTYTUPLEHello everyone, I am trying to write a custom calculation to optimize the performance based on Oracle's guidance. But it seems the Oracle standard guidance is not workin…
-
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…
-
Unable to Execute Business Rule via EPM Automate in EPCMSummary: we are trying to execute a business rule (a custom Groovy Script) in EPCM via epm auomate command as per below doc. But it throws an error saying "Not supported…Harish Kumar C 32 views 4 comments 2 points Most recent by Harish Kumar C Profitability and Cost Management
-
Examples of Custom Calculation Rules scriptsSummary: Content (please ensure you mask any confidential information): Hi all We want to know if we can use ALL the MDX functions for EPCM or if there are ANY limitatio…
-
Using Multiple Periods in calculations?We have a requirement to use a basis which is calculated from all open periods of a year (FcstMnth:Dec). Is there a good way to calculate this in EPCM? We need to divide…Peter Joelson 11 views 1 comment 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
How to quickly select all members with assigned attributeSummary: In my Source selection for a rule I want to include only members of my Product dimension that have a certain attribute attached. There are roughly 100 that have…KCJ04102003 24 views 2 comments 0 points Most recent by KCJ04102003 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 21 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 21 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…
-
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 171 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 85 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 21 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 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 -
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
-
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…