Calculation
Discussion List
-
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 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 32 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 192 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 52 views 1 comment 0 points Most recent by Omar Shubeilat. Profitability and Cost Management
-
Rule Set Execution Time IncreaseSummary Rule sets execution from one month to the next periods doubled in time with the same dataset.Content Recently we have seen that our calculation times are increas…Cloud.EPM.TMH 56 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Change Period/Scenario/Year in PCMCS QuerySummary: Need help on automatically changing the Period/Scenario/Year in PCMCS Query. Content (required): Hi Friends. We have a script to calculate markup which runs a q…Amit Agarwal-158816 41 views 7 comments 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management
-
How do I create a formula (or rule) that save information in another POV?Summary: Our POV has business unit and we 'd like to save the allocation in in another POV. Is it possible? Content (required): Version (include the version you are usin…Ana Teresa Vicentini 31 views 5 comments 0 points Most recent by Omar Shubeilat. Profitability and Cost Management
-
Use of NONENPTYTUPLE in rules to improve performanceSummary: HI, experts! I'd like to improve some rules and in documentation (https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/tsepm/custom_ca…Ana Teresa Vicentini 31 views 1 comment 0 points Most recent by Viral Soni Profitability and Cost Management
-
Is it possible to include UDA(Attribute) Dimensions inside Custom Calculation of PCMCSSummary: UDA member in Custom calculation formula Content (required): There is a requirement to restrict the Custom allocations to happen only for specific Attributes. I…Sivavignesh V 141 views 2 comments 0 points Most recent by Viral Soni Profitability and Cost Management
-
Reference Attribute member in Custom Calculation PCMCSSummary: How to Reference Attribute member in Custom Calculation PCMCS Currently, i am using the below member formula [Result] := ( ([Dim 1 Member],[Dim 2 Member],[Attr1…
-
Calculation of Average Rates at Parent LevelSummary: Average of percentages at parent level instead of aggregation in PCMCS. Content (required): Hi All, I want to calculate the average of percentages at the parent…