Calculation
Discussion List
-
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 21 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 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
-
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 72 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 91 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 -
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
-
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 81 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 407 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 41 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 227 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 61 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 41 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 133 views 4 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
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 61 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 91 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 31 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 48 views 10 comments 2 points Most recent by NK2025 Profitability and Cost Management
-
EPMAutomate RunCalc for a model in EPMCSSummary: Where do we enter the model name to run the calc in the EPMAutomate Runcalc? Content (required): epmautomate runCalc APPLICATION_NAME POV_NAME [DATA_POV_NAME] P…Rajen Patil 61 views 6 comments 0 points Most recent by Rajen Patil Profitability and Cost Management
-
Can we have MDX formulas on the new Profitability?Can we have MDX formulas on the new Profitability?yanni vossos 41 views 2 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management -
Refresh Cube before running calculationSummary: In EPCM, it has been observed that if you change the selection in the Rule and run the calculation, the system gives a message to refresh the Cube Content (requ…Rajen Patil 31 views 2 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
Essbase error (1200766) while running calculation - EPCMCSSummary: Error while running calculation Content (required): We are getting the following error when we put the model for calculation. "Cannot perform cube view operatio…Rajen Patil 31 views 1 comment 0 points Most recent by Rajen Patil Profitability and Cost Management
-
Allocation rules take too much time in EPCM and throw a warning messageSummary: Some Allocation rules take too much time in EPCM and result in an error/warning message Content (required): I have encountered this issue in which allocation ru…Gomaa Abdel Hamid Mansy 181 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management