Calc Manager
Discussion List
-
How to create a custom folder in Calculation Manager in Enterprise Performance Management WorkspaceWe currently have rule sets in Calculation Manager. Business has multiple rule sets that are there for reference and should not be run. Is there a way under our structur… -
Schedule Remove Cells with Zero ValueIs there a way to schedule a job to run the database properties function in Calc Manager, "Remove Cells with Zero Value", on a nightly basis for a specific database or a…
-
Map members into other dimensions based on data set in Account dimension using a RuleSummary: Hello, I have a request to populate the data residing in the account dimension into 2 other dimensions, such that the intersection below copies data 25 and 35 f…
-
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, … -
Need to capture the start and end time of a Data load Rule(Data Exchange) in Groovy Rule.The Request is to get REST API output in json format like start time and end time of a Data load rule in Data Exchange. I have created groovy script to extract the log f…Radha Yerra 53 views 5 comments 2 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Unable to Export Attribute Member Consolidated Data in EPBCSCurrently, in on-prem, we are exporting data using attribute members, which means we are getting consolidated data rather than associated members through a report script…
-
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 61 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 102 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 114 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 22 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 11 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 11 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 142 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 61 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 73 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…
-
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 31 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 31 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 33 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 51 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 52 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 …