Calculation
Discussion List
-
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 … -
What is causing ORA-00911 when using a UDQ within an expressionSummary: Client wants to get the number of transactions where the value on the transaction attribute6 field match. When writing the expression we are getting an invalid … -
To lock the transaction from further updates in ICMArea : Oracle Incentive Compensation (ICM - Sales CX) Summary : Analysts will update the existing transactions post approvals from management, which will generate some e…Pavan Nagalla 31 views 1 comment 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
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 -
How to configure true up commissionSummary: Hello Team, We want true up on 4th quarter i.e., from Oct to Dec. Here is the example how we are expecting true up: If we pay Quarterly participant will get 122…
-
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
-
For One transaction can we do multiple participant calculation ?Summary: For one transaction can we do multiple participants calculation ? If we use direct credit rules we can assign, but challenge is if we have 20 participants then …Rehana Tadimerri 12 views 4 comments 0 points Most recent by Rehana Tadimerri Incentive Compensation
-
Accumulate by Any Interval - What are the actual inputs that are required?Summary: Trying to understand what exact inputs are required on the pre-defined function. The documentation on docs.oracle.com are too vague and don't give examples of w…
-
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
-
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 41 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 22 views 2 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management -
Earnings are blankSummary: Content (required): I have to calculate attainment %, to achieve attainment % I have used below expression Performance Measure formula as: ROUND ( SUM ( Credit.…
-
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 261 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 111 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Prorated Commission ProcessSummary: Hello Team, We have a requirement to calculate prorated commission for the quarter of terminated participant. I have followed below link https://docs.oracle.com…Aisha Shaik 21 views 2 comments 0 points Most recent by Kim Vu-Support-Oracle Incentive Compensation
-
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 51 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 71 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 11 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 61 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 31 views 5 comments 0 points Most recent by Philip Hulsebosch Profitability and Cost Management -
Is feasible variable pay simulator of real-time transactions in Fusion ICM?Summary: Oracle ICM have the capability of providing a variable pay simulator that will allow participants to view their potential variable pay based on real time transa…
-
How to pay 50/50 on order/on payment collection?Summary: The customer scenario here is to calculate the commission earned based on the tier achieved when the order is processed. This commission rate is tied to the ord…
-
How to import individualized Plan Target IncentivesSummary: Is there an import template (either through File Import / Export or Import Management) that would allow you to import a plan target incentive at a participant l…
-
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 61 views 7 comments 0 points Most recent by Amit Agarwal-158816 Profitability and Cost Management