Calculation
Discussion List
-
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 -
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 442 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 265 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 62 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 151 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…
-
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 NKW 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 41 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 191 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
New Enterpise Profitability Error with Formula on Custom RuleHi all, I created a new custom rule, with the formula below: [Adjustment In] :=Sum(CrossJoin({[TP_RnD Service],[PCM_NoRule],[PCM_Input],[Tot_OpEx]},{UDA([Department],"GA…yanni vossos 91 views 3 comments 0 points Most recent by AndrewLaferla Profitability and Cost Management
-
Using Filter in Rules increases the time to calculate in EPCMSummary: When we use a filter for one of the dimensions in the Rule, the time to calculate the rule goes into hours. Content (required): We have a model for one of our c…Rajen Patil 51 views 1 comment 0 points Most recent by Omar Shubeilat. Profitability and Cost Management