Calculation
Discussion List
-
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 36 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 53 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 66 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 48 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 36 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 37 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 197 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 92 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 57 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 62 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 49 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 34 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 34 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 148 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…
-
New Attribute Dimension created, deploy cube failedSummary: New Attribute Dimension created, deploy cube failed Content (required): Hi- I have created a new attribute dimension in PCMCS as F_Location and assigned it to b…Amit Agarwal-158816 45 views 18 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management
-
Is there any way to stop the Ledger calculation besides resetService?Summary: Content (required): Trying to stop the ledger calculation by clicking on Stop button in job library, but it is not stopping. Is there any other way to stop the …Viral Soni 28 views 8 comments 1 point Most recent by Amith Kumar Madisetty Profitability and Cost Management -
Newly Created Attribute Dimension not showing in Reporting StudioSummary: Newly Created Attribute Dimension not showing in Reporting Studio Content (required): Hi All- I have created a new attribute dimension in out application for al…Amit Agarwal-158816 24 views 4 comments 0 points Most recent by Amit Agarwal-158816 Profitability and Cost Management
-
How to reference the account in allocation from custom calculationSummary: Hi All, We have a business need to populate an account using a formula in a custom calculation. We have defined result dimension as account and applied the form…Ashok Kumar Raya 77 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
source for Updated MDX functions listSummary: As all MDX functions might not support in PCMCS custom calculations, looking for updated/refreshed list functions that can be used in custom calculations based …Raama Rao-Oracle 26 views 2 comments 1 point Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Execution Control Run calculation stopped workingSummary: Execution Control Run calculation stopped working Content (required): When choosing to run the calc from Execution control for Data PoV and Model PoV the option…User_2025-02-05-23-55-14-602 27 views 11 comments 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
Adding dimension members through Data Management in PCMSummary Adding dimension members through Data Management in PCM is possible?Content Addition of dimension members through Data Management in PCM is possible? It was answ…User_2025-02-05-23-55-14-602 44 views 7 comments 2 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management
-
Member formulas summarizing ParentSummary: Our allocation source count is way too high. For some Segment we are using an "all value parent" but instead of taking the sum of the parent, it is multiplied b…Francois Desjardins 36 views 3 comments 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
YTD view as result of custom calculationSummary Currently YTD is dynamic calc which doesnt work for outbound integrationContent Hello, here is my issue. We have a set up in PCMCS for Periodic view as store dat…User_2025-02-06-00-44-44-141 73 views 6 comments 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management
-
How to validate data in case of high number of iteration RunSummary: Hello! In my case, around 150 allocation rules are there in 1 rule set which includes reciprocal allocation and normal allocation both (For allocating cost of o…Monish Kumar 45 views 3 comments 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management
-
Executing data load for a POV and Calculation for different POV & Lock & Send Smart View also failsSummary: Executing data load for a POV and Calculation for different POV results the calculation as success(but the calc does not run and only status gets as success) bu…User_2025-02-05-23-55-14-602 17 views 1 comment 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management
-
Calculation Rule errorContent Hi all, I'm fetching this error while running the calculation rule :- Cannot Perform Allocation. Essbase Error(1260054): Error: Dimension signature mismatch in f…User_2025-02-10-10-48-52-544 174 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Rule DimensionSummary Calculation ProgramsContent Hi All, In Rule Dimension what is the use of calculation Programs? Because we know NoRule member is used to load Input data in the ap…Mrinmoy Paul 40 views 4 comments 1 point Most recent by Mrinmoy Paul Profitability and Cost Management
-
Allocation with calculated driver not producing the desired results.Content Hi All, I need to create an allocation where expense accounts per entity need to get redistributed/adjusted with a percentage from the total expenses divided by …yanni vossos 31 views 4 comments 1 point Most recent by Rajen Patil Profitability and Cost Management