Calculation
Discussion List
-
MDX Formula with Avg function is not working in Groovy Business Rule in PCMCS ASO cubeHi, I am creating Groovy Business Rule to calculate Average of an Account from Jan to Current Month and assign this value to other account. ([ACCT_AVG]) := (Avg(({[Perio…RakeshRanjan 31 views 9 comments 0 points Most recent by RakeshRanjan Profitability and Cost Management -
Does EPCM Custom Calculation supports String Operations on left side (Target) of the script?Summary: Targeting the results to certain ICP Dimension members ICP_**** from an alternate hierachy of Product Dimension whose parent will be CP_****. Content (required)…Sivavignesh V 12 views 0 comments 0 points Started by Sivavignesh V Profitability and Cost Management
-
Member formula or custom calc?Summary: Need to calculate average FTEs in most efficient manner Content (required): I have a requirement to calculate average FTEs for a whole list of departments. Curr…SAW23321 22 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Clarification on Simple Reclassification (SR) rulesSummary: What is a simplified calculation process for reclassification rules? Content (required): In the What's New of September 2023 is a note on simplified calculation…Philip Hulsebosch 12 views 2 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management -
Killing Calculation Rules in EPCMSummary: Need to kill the calculations Rules in EPCM Content (required): In EPCM I am trying to kill the running of Rule(s) with the 'Cancel' button. Nothing happens wit…Rajen Patil 145 views 13 comments 0 points Most recent by Dinesh Chand 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 92 views 4 comments 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 32 views 2 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
EPCM - Setting current month number in a account dimension memberSummary: Hi All, I have a scenario where I need current month and previous month in number for some mathematical expression. My plan is to set the number in account dime…Anantha Krishnan 52 views 7 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
PCMCS Custom Calculation error: Unable to allocate resources for cube PCM_CLC for 10800 secondsSummary: Using dynamic calc member in the custom calculation to calculate stored member Content (required): Hi, we have a requirement to calculate YTD value and use that…User_S3H04 32 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management
-
What is the rule dimension member [PCM_ Rule]？Summary: Why should calculation always include the rule dimension member [PCM_ Rule]? An error occurs if [PCM_Rule] is not included in the calculation. What role does [P…User_IPP4R 12 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Use multiple cubes for cost allocation in EPCMSummary: Hi, I am exploring an option to use multiple ASO cubes in EPCM for separate types of allocation. If anyone tried, can you please share potential risks or downsi…Smit Shah 52 views 8 comments 0 points Most recent by Luis Autrique Profitability and Cost Management
-
EPCM Custom Calculation Rule - Mark up for multiple entities in a single ruleSummary: Can we create single custom calculation rule for marking up cost by x% for multiple entities? Content (required): I have 50+ entities and cost of each entity ne…Anantha Krishnan 92 views 6 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
PCMCS Export data using query not showing AliasesSummary: PCMCS Export data using query not showing Aliases Content (required): Hi, I am trying to export data using query from PCMCS. Even though I select Use Aliases, t…Amit Agarwal-158816 22 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management -
EPCM-using CASE script in calculationSummary: How do I use CASE statements in formulas? Content (required): I use the following script, an error will happen. Could you tell me the correct syntax? CASE WHEN…
-
PCMCS Query - Exporting data using epmautomate with "," as delimiterSummary: Exporting Data from PCMCS using epmautomate exportQueryResults Content (required): Hi, I am trying to export data from PCMCS using a query using epmautomate exp…Amit Agarwal-158816 42 views 7 comments 0 points Most recent by Amit Agarwal-158816 Profitability and Cost Management
-
Transfer Pricing EPCM vs FreeformSummary: We are contemplating between EPCM vs Freeform for our Intercompany extension (transfer pricing) needs. Content (required): We need to fetch data from ERP fusion…getgaurav 53 views 1 comment 0 points Most recent by Al_DuqueEstrada 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 83 views 5 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
How to copy multiple periods from one version into another?Summary: A poweruser want to copy multiple periods from multiple years from one version into another. How to do this in the UI in a simple way? Content (required): In th…Philip Hulsebosch 42 views 6 comments 0 points Most recent by AndrewLaferla 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 96 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…
-
No TBLAST option available - how to work with Balance Data?Summary: Number of policies is a balance account. There is no option to specify an account to be Time Balance Last. How to resolve this best? Content (required): We want…Philip Hulsebosch 52 views 3 comments 1 point Most recent by Gerrit Haan Profitability and Cost Management
-
Seeding data using member formula & Custom calc no longer workingSummary: We are using a member formula to calculate and copy data to another intersection and are getting a zero cells updated warning. Content (required): We are creati…Adam Spiller 42 views 3 comments 0 points Most recent by Steve Gan - HCG Profitability and Cost Management
-
EPCM Copy Data using Custom Calculation RuleSummary: Hi, I want to copy set of current month Forecast data and set of previous month actual data to a single PoV location. Since process needs to be automated in fut…Anantha Krishnan 82 views 4 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
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 162 views 10 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
PCMCS Out-of-the-Box (OOTB): 4.TraceabilitySummary Traceability and transparency within PCMCS - Out of the box featuresContent Traceability is the buzz word in any regulated industry. Being able to prove the numb… -
How can I verify allocation rule calculation output/see intermediate results/source contribution?Summary: I am looking for a report which displays the calculation path / intermediate results for every output cell of EPCM allocation rules. Basically a deeper look in …
-
EPCM - Multiplication and percentage consolidation operator in dimension hierarchySummary: Hi All, I am trying to multiple 2 members using multiplication consolidation operator in dimension hierarchy, but not working as expected. Required output is AB…Anantha Krishnan 52 views 3 comments 0 points Most recent by VVikas Profitability and Cost Management
-
EPCM - Applying percentage to an amount using dimension member hierarchySummary: In EPCM, can we apply a percentage to member value using dimension consolidation operation? Scenario : Non-allocable amount of a cost needs to be calculated. We…Anantha Krishnan 72 views 6 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
Actuals and Forecast - Single rule for to aggregate different PoV dataSummary: Scenario: I have two sets of data, actuals and forecast values for same business attributes.(Cost Centre-Account-Entity combinations) Actual data POV: FEB;FY22;…Anantha Krishnan 22 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Dimension Management in PCMCS through Smartview not availableSummary Dimension Management in PCMCS through Smartview not availableContent Hi All- We know we don't have the facility of dimension management in PCMCS through Smartvie…Amit Agarwal-158816 49 views 10 comments 2 points Most recent by Nkehli Profitability and Cost Management