Calculation
Discussion List
-
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… -
Cannot Clear Partial Data. Essbase Error(1200503): Duplicate dimensions in a tuple in function [TUPLHello everyone, I tried to run Calculation for July but it showed the error : when I tried to run calculation for June, it ran successfully. How to fix this issue? Thank…
-
Duplicate dimensions in a tuple in function [TUPLE CONSTRUCTOR] on line [2]Hello everyone, When i ran the model calculation, it showed the error: "Unexpected error from essbase or insufficient data privileges. Cannot Clear Partial Data. Essbase…
-
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 -
Is there a way to create Counterparty transactions in EPCM?Summay: For EPCM Transfer Pricing based Application, we want to create counterparty entries of Transfer Pricing Results. Content (required): If Transfer Pricing Results …Sivavignesh V 81 views 3 comments 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management
-
Cube not deployed warning while running the calculations- possible reasonsSummary: What are the different reasons/scenarios for getting the warning 'Cube is not deployed'? Content (please ensure you mask any confidential information): I unders…Rajen Patil 11 views 2 comments 0 points Most recent by Rajen Patil Profitability and Cost Management
-
Purpose of using EPCM_GOVERNORS_OVERRIDE_KEY variable in EPCMSummary: Hi, Request anyone to let me know the purpose of using EPCM_GOVERNORS_OVERRIDE_KEY variable in EPCM. It would be helpful if any resource link is shared for the …Harish Kumar C 21 views 3 comments 2 points Most recent by Harish Kumar C Profitability and Cost Management
-
EPCM Ruleset Sequence ExecutionHow does EPCM execute the rulesets, if there are 5 rulsesets and are all sequenced as "1"? I wanted to understand if the system exectues the rulesets serially or in para…
-
Can pipeline variables be used in job fieldsSummary: I am trying to run the calculate model job in EPCM and have the sourcepov be a pipeline variable that can be put in when the pipeline is run. Is it currently po…
-
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… -
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…
-
PCM Custom Calculation querySummary: In EPCM; I am trying to create Custom Calculation rule to copy data across different Entity. The difference is in the primary Entity where the data is loaded it…Muruges89 42 views 2 comments 0 points Most recent by Risingstar27 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 172 views 3 comments 1 point Most recent by Raama Rao-Oracle Profitability and Cost Management -
Directory/File '/u02/user_projects/instance0/tmp/scratch' does not ExistSummary: Hello! For a second day I'm getting an error "Directory/File '/u02/user_projects/instance0/tmp/scratch' does not Exist" when trying to rum my allocation model. …Alexey Jodzichski 11 views 1 comment 0 points Most recent by Mark Zacchilli-Support-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
-
UDA in EPCM ruleSummary: Can i use UDA in EPCM to filter on the source dimension? I am only getting Attribute option to filter on rules. Content (please ensure you mask any confidential…Nilotpal Bhaskar 31 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Groovy script to run ML calculationSummary: Dear Experts, Im trying to trigger the Run ML in pcmcs Via FCCS ODR Groovy, script validation is fine. "/rest/v1/applications/PCM/povs/2024_At_Feb/jobs/runLedge…Sreekumar Hariharan 141 views 11 comments 0 points Most recent by Amith Kumar Madisetty 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
-
MDX Member formula too long but no errorSummary: Hello all, when I enter below's MDX member formula in EPCM ASO Cube, it validates successfully and also the refresh database is successful and works fine. Howev…
-
Merge Incremental Cells and Compact CubeSummary: We are using Merge incremental slices (merge all into main slice) and there is improvement when using this, the cost of querying inc data also reduced from 0.9 …
-
Is it possible to reference PCM_Rule as a source dimension in an allocation rule?Summary: Content (required): Hi. I have a custom calc rule that moves dollars from multiple markets to a single market prior to allocating the dollars. I would like to u…SAW23321 81 views 7 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Custom Rule cannot be enabled because it has failed Validations. Invalid dimension memberSummary: I have a member name with periods e.g. 3543.1001.100004. I can use this member as source, target, driver in Allocation rules. However, I cannot use this member …Dinesh Chand 61 views 4 comments 0 points Most recent by Dinesh Chand Profitability and Cost Management -
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…
-
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
-
Standard Target Version Use CaseSummary: I notice that the Version dimension allows for set up of a Target version. What is the use case for this in EPCM given all the cubes are ASO? I presumed you cou…Dinesh Chand 11 views 1 comment 1 point Most recent by Raama Rao-Oracle 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 61 views 2 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
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 81 views 9 comments 0 points Most recent by RakeshRanjan Profitability and Cost Management