Calc Manager
Discussion List
-
Exclude negative data in member formulaSummary: hello, Need some advise on how to exclude months with negative values in the data set when taking an average. We are currently doing this within Excel's functio…Zut Alors 62 views 5 comments 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
Is rtp a restricted word in simulateConcurrentUsage?We are experiencing an issue with simulateConcurrentUsage regarding how it is processing rtps when performing the Run Business Rule function of this command. We have att…Russ_Shellhamer 104 views 20 comments 1 point Most recent by Russ_Shellhamer EPM Platform and Freeform
-
Results of Groovy Script Validator BlankSummary: For a number of applications, all of which have Groovy code in place, the Groovy Script Validator Report is not producing any results where we were expecting th…Evan L 109 views 5 comments 0 points Most recent by Ujwala Maheshwari-Oracle EPM Platform and Freeform -
EPBCS Essbase Member formula NOT workingThis is so weird. Let me explain. I want to pull "Salary_By_Steps_WFP"→"Year3" value, which is $100. Assigning this code to dynamic calc member formula works perfect: "S…Ravinder Singh-63390 24 views 4 comments 1 point Most recent by Ravinder Singh-63390 EPM Platform and Freeform
-
How to check last execution time for business ruleSummary: Hi, Is there a way to check when was the last time a business rule was executed? I understand there is a way we can export the job console logs but that would g…Neha_R 12 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPCMCS-CALL GROOVY SCRIPT via EPM automateSummary: Call Groovy rule for EPM automate Hi All, I created one groovy rule in my EPCMCS instance. when I call the rule via EPM automate command i.e runBusinessRule. It…Avtar 12 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
Groovy - Download and Upload file to other environmentSummary: Download File .csv in Source Environment and then Upload file to Target Environment - Planning EPBCS Content (please ensure you mask any confidential informatio… -
EPM planning business rule runs multiple timesHi, There used to be an issue like this decades ago, but I am getting the same behaviour in PBCS. After saving a form, and the business rule runs, if I leave the form sa…Mark Matson-Oracle 130 views 4 comments 0 points Most recent by Abhijeet Panchgam EPM Platform and Freeform
-
How to call an existing member within the @SLN function for the "lifeMbrConst" parameterHello everyone, I am trying to leverage the @SLN function within a member formula, and want to use an existing account member as the selection for the lifeMbrConst param…
-
Error while executing rule "Cannot complete operation: insufficient aggregate storage cache size"Summary: Hi, I am trying to run calculation manager custom script but getting error : Cannot complete operation: insufficient aggregate storage cache size. If i execute …JyotiSharma 62 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Error while converting RTP To Smartlist ValueSummary: We have a requirement where we're updating smartlist values based on form POV through RTP using function : "Tgt_Dept1" = @CalcMgrDoubleFromString(@SUBSTRING(@AL…
-
We are trying to write a calculation referring FCCS_YTD member but its not workingSummary: Hi Team, We are trying to write one calc script using FCCS_YTd data but rule gets stuck whenever we try to run it. This is working fine when we run it with "FCC…JyotiSharma 61 views 16 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
calculating YTD from MTD dataHi, As the data is loaded in MTD values I want to calculate the YTD value for the Balance Sheet accounts in EPM Planning. The dynamic time series only considers the curr…
-
Data Management - Passing Start Period and End Period to Business RulesContent In Data Integration I have a business rule that performs calculations post load for the period range loaded i.e. DM POV Start and End Period range. In DM Cloud, …Dinesh Chand 227 views 6 comments 2 points Most recent by Anandita Biswas-Oracle EPM Platform and Freeform -
Sumrange function used along with UDA function is not working as expectedSummary: We are trying to write a calc manager script where we want the sum of all entities tagged with Specific UDA multiplying it with respective ownership percentage …JyotiSharma 32 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
When lauching a rule via Rules I get an errorSummary: Hi everyone, When launching a rule from Rules I get following error: the dimension Year is invalid. However it is successful when launching it via calculation m…
-
Unable to launch business rule from RulesSummary: Hi all, I created a rule to copy data from one year to another year, the rule is successfully validated, saved and deployed. I can also launch it from the Calcu…
-
Script doesnt work as expectedHi we want the aggregation of a different dimension eg row 6 and 7 needed to be summed up in row 11 ie where ever the functionl area = Room Sales_FA it need to summed to…Althaf Abdullah 32 views 2 comments 0 points Most recent by Lakshani Hettiarachchi EPM Platform and Freeform
-
Dataexport not exporting #missing dataHi, I am trying to export members in a certain area regardless of whether there was data or not. My understanding is that DataExportNonExistingBlocks ON, was to export a…
-
Smart List based RTP not working in Planning InterfaceSummary: We have a Smart List based RTP. The business works fine directly in Calculation Manager but not from Planning. Details: We are encountering an issue with a DATA…adarshad 32 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
How could reversal in proportion change for YTD view correctly?Summary: In a hierarchy some entities are changing from 90% Subsidiaries to Not Consolidated method and 0% Ownership, the same entities are consolidating in a 100% in ot…AA_AlfonsoGonzalez 53 views 5 comments 0 points Most recent by Hussein M Ali Financial Consolidation and Close -
OAuth 2.0 Refresh-token based EPM Automate login failsSummary: Refresh-Token based EPM automate connection fails Content (please ensure you mask any confidential information): Groovy code to execute Recompute ownership modu…Arindam Chakravarty 44 views 1 comment 0 points Most recent by BalaR-Oracle EPM Platform and Freeform
-
How to search a string variable in Groovy for a specific part of a string.Summary: How to search a string variable in Groovy for a specific part of a string. Content: We're currently using an pipeline that triggers everyday and processes the f…
-
ASO Custom Calculation vs. Graphical Editor DifferenceHi folks, I'm working in a custom EPM Planning app and trying to create an ASO business rule to calculate a percentage of total headcount. I can use the graphical design… -
Data Export with Pivot DimensionSummary: Hello Wizards, I have requirement to export BSO data (Non Num as well) to csv file with Account dimension on the column (Pivot). Expected Output (StartDate and … -
In EPBCS, Unable to copy data from Working Version to Final Version within ASO cubeSummary: I've used MDX to copy the data from 'Working' version to 'Final' version within the ASO cube but I'm unable to do that. The Rule got successful in the validatio…
-
How to Copy Data from a combination to another combination using groovy in PCMSSummary: Need to Copy Data from a combination to another combination in a form using groovy in PCMCS Content (please ensure you mask any confidential information): Versi…Sri Harsha Panchumarthy 41 views 5 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
ASO to BSO DataSummary: What are the ways of pushing data from ASO to BSO cube. Data Map is not working. We need to push a big set of data from ASO to BSO. Content (please ensure you m…
-
How to print the Duplicate data in a form in incremental order using groovySummary: Exporting the Repeated Data Combination in a form in incremental order using Groovy Content (please ensure you mask any confidential information): I want to pri…Sri Harsha Panchumarthy 22 views 1 comment 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
Need Calculation scriptsSummary: Our Company Contribution to Staff Association (1) Use the prior year’s actual contribution to staff association to forecast the contribution to staff associatio…