Calculation
Discussion List
-
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 71 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 21 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 21 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 40 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 31 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 66 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 41 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 11 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 171 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 36 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 27 views 4 comments 1 point Most recent by Rajen Patil Profitability and Cost Management -
Generate Data in Query with ThresholdSummary Generate Data in Query with ThresholdContent Hi - Is there a way we can generate Data through PCMCS Query with a threshold, say I would like to have only the Cos…Amit Agarwal-158816 43 views 3 comments 2 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
Period member having Member Formula: Essbase Error- 1013358Summary Running calculation for POV having Period dimension member having Member FormulaContent Hi All, So following my previous post on Cloud Customer Connect given on …Khushbu Premlani 43 views 4 comments 1 point Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
Rules: Estinated Source and Destination countSummary I am using parent members in in source and destination of a rule, that I believe increases the source count, any remedy for that?Content Hi All, I am using paren…Khushbu Premlani 30 views 3 comments 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management
-
Optimize for ReportingSummary Question about Optimize for Reporting optionContent From the Navigator -> Manage -> Calculation dialog If I only have "Optimize for Reporting" check box selected…Dawn Watson 33 views 3 comments 0 points Most recent by Dawn Watson Profitability and Cost Management -
Financial reporting web studio reports in ExcelSummary Financial reporting web studio reports in ExcelContent Hi- Can we have PCMCS Financial reporting studio reports downloaded in Excel? I see only option to run as …Amit Agarwal-158816 41 views 4 comments 1 point Most recent by Amit Agarwal-158816 Profitability and Cost Management
-
Dimension Update failing when using Excel TemplateSummary Dimension Update failing when using Excel TemplateContent Hi- I have a requirement to add around 1700 new cost centres in PCMCS. I downloaded the dimension file …Amit Agarwal-158816 30 views 8 comments 1 point Most recent by Amit Agarwal-158816 Profitability and Cost Management
-
Change in Alias does not reflect until Cube is re-deployedSummary Change in Alias does not reflect until Cube is re-deployedContent I just noticed that in PCMCS, if we change the alias of members, they won't reflect until we de…Amit Agarwal-158816 28 views 3 comments 1 point Most recent by Amit Agarwal-158816 Profitability and Cost Management
-
Migrating Essbase data from one instance to anotherSummary Migrating Essbase data from one instance to anotherContent Hi- When we migrate PCMCS "Essbase Data" snapshot from one instance to another, does it also migrate a…Amit Agarwal-158816 16 views 3 comments 1 point Most recent by Aman Kothari-191377 Profitability and Cost Management
-
Clear Adjustment values using EPMautomate ClearPOV CommandSummary Clear Adjustment values using EPMautomate ClearPOV CommandContent Hi - I would like to use ClearPOV epmautomate command in my Markup Script which calculates adju…Amit Agarwal-158816 41 views 2 comments 1 point Most recent by Amit Agarwal-158816 Profitability and Cost Management
-
Migrating one set of data from one instance to anotherSummary Migrating one set of data from one instance to anotherContent Hi- In PCMCS, is is possible to migrate only one month data set from one environment to another. Le…Amit Agarwal-158816 18 views 2 comments 1 point Most recent by Nitin.Gupta Profitability and Cost Management
-
Data Management: Addition entry of FusionSummary Addition entries appearing of related to single GL code at Data Management WorkbenchContent Hello All, I am facing this weird issue while integrating GL Data fro…Khushbu Premlani 22 views 2 comments 1 point Most recent by amaresh salagundi-Oracle Profitability and Cost Management
-
Data Management: Automation of Downloading Workbench DataSummary Automation of task of Downloading workbench data in excelContent Hi All, I wanted to know how we can automate the process of downloading workbench data from Data…Khushbu Premlani 28 views 1 comment 1 point Most recent by Thejas Shetty-Oracle Profitability and Cost Management
-
Migrating selective rules from one instance to anotherSummary Migrating selective rules from one instance to anotherContent Hi friends, We have 3 calculation instances for PCMCS and 2 of them contains around 1000 Business R…Amit Agarwal-158816 51 views 3 comments 1 point Most recent by Amit Agarwal-158816 Profitability and Cost Management
-
EPM automate : Automation of Download of HFR reportsSummary How to Automate Download of HFR reports?Content Hi All, I do have prepared 17 HFR output reports and I want to automate download if that report from Explore repo…Khushbu Premlani 58 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Profitability and Cost Management
-
Data management : Merging Costing combinationsSummary Merging of Data combination coming from two different kind of DataContent Hi, I am trying to integrate Fusion Data into PCMCS, for that I have two rule created a…Khushbu Premlani 33 views 4 comments 0 points Most recent by Thejas Shetty-Oracle Profitability and Cost Management
-
Slides on concepts/functionalities regarding PCMCSContent Hi Im looking for some slides on PCMCS with screenshots inside the application and showing the features/functionalities. Regards LakshaniLakshani Hettiarachchi 26 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
PCMCS - I am have run calculation for a POV its keep on running more than 2 hrsSummary PCMCS - I am have run calculation for a POV its keep on running more than 2 hrsContent Hi All, I have migrated the PCMCS application from one POV to another POD,…amaresh salagundi-Oracle 36 views 2 comments 0 points Most recent by amaresh salagundi-Oracle Profitability and Cost Management
-
PCMCS - Optimized PerformanceSummary Rules in PCMCS are executing quicker than they used to earlierContent Hi, All rules in our production environment for the POV: "FY21, Actual, Final" used to run …User_CX05Z 33 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
"Enable Application" in EPM automate for PCMCSSummary Relevance of "Enable Application" EPM automate command in PCMCSContent I want to understand implications of "Enable Application" EPM Automate command in PCMCS ap…Khushbu Premlani 30 views 1 comment 1 point Most recent by Don Bean-Oracle Profitability and Cost Management