Calculation
Discussion List
-
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 53 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 25 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 16 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 994 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 22 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 303 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 132 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 75 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 62 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 52 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…
-
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 11 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…
-
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 124 views 6 comments 0 points Most recent by Narayan 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 57 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…
-
EPCMCS COPY POV FUNCTIONSummary: EPCMCS COPY POV FUNCTION Hi All, I am try to copy POV form:- "FY24,JAN,Actual,Working" to "FY24,Dec,Actual,Working". I am getting issue there i.e. In this POV "…
-
Issue running calculation after metadata update and database deployment.I have been running into issues running calculations in PCMCS after December 2024 update. We usually update our customer and account metadata periodically for allocation…Naplez 128 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Any performance tuning service provided by Oracle Support?My client possesses a vast amount of retail data combined with a highly complex data model, resulting in numerous intricate data intersections. The whole process of load…Supanut Sinphatsirikul 24 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Can we load to PCM_CalculatedDriverValue?Summary: Is it possible to load driver data to PCM_CalculatedDriverValue? Content (please ensure you mask any confidential information): We would like to clear almost al…SAW23321 32 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Can you prevent users from selecting "All Rules" in Calculation Processing RangeSummary: We have a few GL Allocations where specific Rule Sets must be run one at a time. Is there a way to prevent the users from selecting "All Rules" from the Manage …
-
Getting "Unexpected error in business logic" when trying to run a ledger calculationSummary: Hi Team, I am trying to run a ledger calc for a POV, but I am getting below error. "Unexpected error in business logic" I tried clearing entire cube and deployi…Harish Kumar C 32 views 5 comments 1 point Most recent by Harish Kumar C 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 41 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…