Rules
Discussion List
-
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 32 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 93 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 76 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 24 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 129 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 41 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…Mueller 149 views 4 comments 0 points Most recent by Luis Autrique Profitability and Cost Management
-
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…
-
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
-
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
-
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 359 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 201 views 4 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Calc Manager option Disabled/Missing in EPCMCS applicationSummary: We created a EPCMCS application and couldn't see the "Calc Manager" option under 'Create and Manage'. Content (required): Version (include the version you are u…
-
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 63 views 4 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management -
Rule Balancing in EPCMSummary: When I try to refresh the rule balancing in EPCM, below error was thrown. Can anyone has faced the issue and if yes, what could be the possible issues? Else, Is…Anantha Krishnan 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
EPCM - My Rules and rule sets are not listed when schedule jobsSummary: EPCM - My Rules and rule sets are not listed when schedule jobs. I have 2 models, 6 rule sets and 300+rules across the rulesets. None of them are listed. Is sch…Anantha Krishnan 31 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
-
Refresh Cube before running calculationSummary: In EPCM, it has been observed that if you change the selection in the Rule and run the calculation, the system gives a message to refresh the Cube Content (requ…Rajen Patil 32 views 2 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
How to manage Rules in different Scenarios/Versions?Summary: EPCMCS The requirement is to try the same Rule differently or enable/disable a few Rules in different Scenarios/Versions. How can I choose a Scenario/Version fo…Rajen Patil 41 views 3 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
Rule Setup ViewSummary How to view or export rule setup in spread sheetContent Hi Experts Right now i am usging following navigatoins to view the rule setup Rule --> Rule Set --> Rule …
-
Rule definition (system) reportSummary: Where can I get the Rule definition (system) report, where the source-destination-driver members are listed? Content (required): Get a detailed report on the Ru…Rajen Patil 51 views 2 comments 0 points Most recent by Rajen Patil Profitability and Cost Management
-
Mass update of Rules in EPCM with change in Metadata MemberSummary: Need to find a quick method for all the impacted the rules to get updated on renaming a dimension member Content (required): We have a requirement in EPCM where…Kapil K Nankani-Oracle 64 views 2 comments 0 points Most recent by Kapil K Nankani-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 52 views 1 comment 0 points Most recent by Omar Shubeilat. Profitability and Cost Management
-
Visibility into Calculation LogsSummary: I am having an issue where my Driver is not being considered, and the allocation rule is conducting an even split instead of the driver I have defined. Where ca…Cullen Caballero-274444 31 views 2 comments 0 points Most recent by Cullen Caballero-274444 Profitability and Cost Management