Calculation
Discussion List
-
Creating expressions to filter the source combinations in PCM designerHello Experts, We have a requirement where the client wants the project-level allocations (currently performed in PPM) to be migrated to PCM. However, the list of projec…Himani Jena 25 views 2 comments 0 points Most recent by Himani Jena Profitability and Cost Management -
Dynamic mdx calc of driver not working in allocation rule.Summary: Hello Experts - I have calculated a dynamic driver and the results are correct when compared to manual calc of same. However, when using the driver member in th…
-
Elapsed Time does not match with the time shown in the Calculation Statistics ReportSummary: Hi everyone, I am new to PCMCS and exploring the functionality in the sample application (BksML50). I was running a simple allocation rule with reference to the…Jacky_Chan_I4MUA 19 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Validate Data Form using GroovySummary: We are capturing a percentage input on a data form in EPCM. Content (please ensure you mask any confidential information): We are capturing a percentage input o…NikhilDeshpande 21 views 2 comments 0 points Most recent by NikhilDeshpande Profitability and Cost Management -
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 193 views 4 comments 1 point Most recent by Surendra Agrawal Profitability and Cost Management -
Rounding handling in EPCMHello everyone! We have a situation that the EPCM calculating the result which is different from the using Excel for allocation. We believe it is because of the EPCM rou…GaryYip-Asc 33 views 3 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
Need to run EPCMCS Model for selective Entities via GroovySummary: Hello Experts, I am working in EPCMCS and trying to automate my Model execution for selective Entities (instead of running for all Entities defined in the Rules…
-
what is the governor limit in epcmcs for allocation rulesSummary: Hi All, was trying to run one rule but I am getting the error as below: Warning: Rule cannot be saved because it failed the following validations: Potential Sou…Akansha_Ganeriwal 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
MDX format for power(raise to) in custom calculationSummary: Hi All, I want to build below formula, [Adjustment]:=([input][account])*(1+([input][mark up]))^3 What is the format for MDX format for power function (raise to)…Anantha Krishnan 56 views 7 comments 0 points Most recent by HarshD Profitability and Cost Management
-
Features and Capabilities in PCMCSSummary: Content (please ensure you mask any confidential information): Hi, We have a client in the banking and finance industry already using the tool primarily for all…Lakshani Hettiarachchi 23 views 1 comment 0 points Most recent by Sajal Gupta1-Oracle Profitability and Cost Management
-
How can a POV or Period be locked in EPCM to block data update of any kind (Submit Data or DM)Summary: Publishing a POV (from Calcualtion Control) seems to only block any calculations being run, but data upload is still being allowed. We need to lock a POV once i…Itali Madhusmita 11 views 6 comments 0 points Most recent by Itali Madhusmita Profitability and Cost Management
-
Getting a warning for few of the Rules during calculation RunSummary: Hi, I am getting below mentioned warning for few of the rules when calculation is run, this was working fine previously. Also, the allocated results are looking…Harish Kumar C 52 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
How to configure Time Balance "Balance"/ Last for Balance Sheet/ FTE Accounts in EPCM ASO CubeSummary: We are currently configuring EPCM and had a closer look on the time balance setting/ the aggregation of accounts over the Period Dimension. We intended to use p…
-
Essbase Error(1260052): Syntax error in input MDX query on line 1 at token ')'Summary Essbase Error(1260052): while running CalculationContent I have been running calculations on PCM model and got the following error. Cannot Perform Custom Calc. E…Rajen Patil 1K views 8 comments 0 points Most recent by AnupamKumar Profitability and Cost Management
-
Any restriction on number of Data POV's maintained in EPCMSummary: Can we have any number of data povs in EPCM, will it impact on the performance? Content (please ensure you mask any confidential information): Earlier in PCMCS …Harish Kumar C 21 views 2 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Does 'Calculate Model' pipeline job create POV if it's not created?Summary: Just wanted to know if I pass new POV (which is not created in the application) will it throw an error or will it create new POV automatically in the applicatio… -
Is there any way to execute Merge Slice job using business rule?Summary: Is there any way to execute merge slice functionality using business rule? I know that we can use RestApi groovy rule to execute the same, however we need to cr…
-
EPCM - Currency conversion without custom calculation ruleSummary: Is there any way to convert allocated amounts from base(reporting) currency to respective local currencies without using custom calculation rules in EPCM? Like …Anantha Krishnan 310 views 12 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Can you pass range in povName for calculating a modelSummary: Can you pass range in povName for calculating a model in a Pipeline Content (please ensure you mask any confidential information): Can you pass range in povName…Sheetal Jain 11 views 1 comment 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Can we substitution variable in pipelines to execute forecast allocations for multipleperiod in EPCMSummary: Is there a possibility to include substitution variable in pipelines labels to execute forecast allocations for multiple periods in EPCM. We have a requirement …Bhavani Gajula 131 views 10 comments 0 points Most recent by NK2025 Profitability and Cost Management
-
Allocation Rule(s) produced zero cells.Summary: While running the rule for a particular scenario, the rule is ending up in warning with message "1 Allocation Rule(s) produced zero cells. Please review the Cal…Mohammed Abdul Suboor 110 views 5 comments 0 points Most recent by Mohammed Abdul Suboor Profitability and Cost Management
-
attribute reference in a member formula - syntax - howtoSummary: In the ASO member formula of my ePCM application I want to apply a formula to one of my driver members that reference the Attribute dimension on top of the PCM_…Erik De Rouck 64 views 1 comment 0 points Most recent by Erik De Rouck Profitability and Cost Management
-
Enterprise profitability and cost management Allocation Rule OptimizationSummary: We have developed an EPCMS (Enterprise Performance and Cost Management System) application for a client, featuring several allocation rules for managing cost an…P Avinash 51 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
EPCMCS-Calculation SegmentationSummary: Hi All, I want to know in which scenario we can use this segmentation. Is there is any standard protocol we need to follow when we use this function in allocati…
-
REST API to execute Multiple POVs does not return all Child jobsSummary: REST API to execute Multiple POVs does not return all Child jobs Content (please ensure you mask any confidential information): When executing calculation for M…NarayananS 121 views 12 comments 0 points Most recent by Ryan Fell Profitability and Cost Management
-
From full cost to variable cost (mdx in member formula)Summary: Variable cost is being recalculated at parent levels instead of aggregated. Content (please ensure you mask any confidential information): To split the full cos…Erik De Rouck 15 views 2 comments 0 points Most recent by Erik De Rouck Profitability and Cost Management
-
Allocation Rules with Selection same as source in Destination giving error (version 25.02.83)Summary: Content (please ensure you mask any confidential information): We have few allocation rules were in destination we have a selection of same as source for all di…Ashish Antony 31 views 4 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
Rounding Issue in PCMCSWe are facing an issue in rounding decimal places in a file that we are extracting from Data Mangement Interface of PCMCS. In custom calculation rules, the decimal place…Kavita Ganesan 125 views 6 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
EPCM Allocation Precision Produces Inaccurate ResultsSummary: In EPCM, when using an allocation precision of 2 and performing an SDE allocation rule allocation data from one member to various members within the same dimens…Pat_sch-eat 54 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
currency conversion in EPCMSummary: I’m using the following currency conversion rule to calculate data in AUD_Reporting for Input, Allocation In, and Allocation Out data. However, it takes too lon…