Calculation
Discussion List
-
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 47 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 45 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 35 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 39 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 46 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 35 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 33 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 22 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 48 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 25 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 28 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 34 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 55 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 63 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 38 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 31 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 42 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 36 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 35 views 1 comment 1 point Most recent by Don Bean-Oracle Profitability and Cost Management
-
PCMCS Allocation - SalesSummary Sales Allocation Product wise in PCMCSContent Hi Expert I have an requirement for sales allocation in below said calculation mannur sales values to be allocated …
-
PCMCS Custom Calculation error: Warning: Rule cannot be enabled because it has failed Validations. TSummary We have problem with the sintax in Custom Calculations en PCM Cloud, could you help me with this issue?Content We have a PCM model with 15 dimensions, we need to…Diana Gaona 54 views 5 comments 0 points Most recent by Diana Gaona Profitability and Cost Management
-
PCMCS Custom Calculation Validation Error when using SUM and CROSSJOINSummary There is a requirement to sum a driver by Entity but based on UDA. Using SUM and CrossJoin function, formula is not getting validatedContent Hi Experts, Need som…User_2025-01-30-00-01-49-367 77 views 4 comments 0 points Most recent by User_2025-01-30-00-01-49-367 Profitability and Cost Management -
Error on Formula Validation: Dimension Signature Mismatch in function on lineSummary Formula fails to validate in TEST environment, but validated in PROD environmentContent Formula is defined as: [Adjustment In] := ([Balance], [Rule], [Functional…Luis Autrique 129 views 2 comments 0 points Most recent by Luis Autrique Profitability and Cost Management -
Deploy Cube Job in PCMCS Application is failing intermittentlyContent Hi Experts, I need help on an issue we are facing. PCMCS Deploy Cube job is failing more frequently nowadays with the error "Cannot connect to Essbase Server Can…Parmit Choudhury-Deloitte 42 views 3 comments 0 points Most recent by AndrewLaferla Profitability and Cost Management
-
PCMCS Warning "The formula length may be too long for essbase for rule"Summary PCMCS Warning "The formula length may be too long for essbase for rule"Content Hi Experts, We are getting the warning The formula length may be too long for essb…Parmit Choudhury-Deloitte 46 views 6 comments 0 points Most recent by Parmit Choudhury-Deloitte Profitability and Cost Management
-
How to use "Update Dimensions As a Job" REST API in PCMCSContent Hi Experts, Please can you explain when and under which scenarios can we use "Update Dimensions As a Job" REST API. REST Resource POST /epm/rest/{api_version}/fi…Parmit Choudhury-Deloitte 29 views 1 comment 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management
-
PCMCS query generating blank fileSummary PCMCS query generating blank fileContent Hi Friends, I have created a query in PCMCS using global context to export data. However when I run the query, it shows …
-
Run allocation for multiple periodsContent Hi, Could anyone please guide me how can I run allocation for multiple periods(I need to run it for Sep:Dec of FY20 and Jan:Dec of FY21). When I am executing it …Karthik 123456 53 views 1 comment 0 points Most recent by AndrewLaferla Profitability and Cost Management
-
Update Dimension Causing the PCMCS Instance to go down and unresponsiveContent Hi Everyone, Please can i request some one to share the best practices to update dimension into PCMCS. Currently, we are executing Rest API scripts to update dim…Parmit Choudhury-Deloitte 32 views 4 comments 1 point Most recent by Alecs Profitability and Cost Management
-
PCMCS Allocation Results do not match exactly with Manual Excel FormulaSummary PCMCS Allocation Results do not match exactly with Manual Excel FormulaContent Hi, In the process of reconciling PCMCS Allocation results using excel formula, we…User_2025-01-30-00-01-49-367 44 views 7 comments 0 points Most recent by User_2025-01-30-00-01-49-367 Profitability and Cost Management