Calc Manager
Discussion List
-
Creation of blocks with agg missing set to off when no data existsSummary: Should aggregating data only on missing accounts create blocks when agg missing is set to off? Content (please ensure you mask any confidential information): I … -
Data Load Rule Not Picking Up Global Period Mapping Or Explicit MappingSummary: I have a data load rule that is Delimited - Numeric Data that is missing the period and year from the file and causing the below error. It doesn't make sense th…
-
How to run a rule after a smart push in a form?Summary: Hi All, What I try to achieve is the following: I have an input form for entering data in a certain cube, which triggers a few business rules upon save to have …
-
Business Rule: Error:Network error []: Connection has been closedSummary: Business Rule Runs into an Error "Error:Network error []: Connection has been closed" and I couldn't find where it goes wrong in the code. Content (please ensur…
-
@RELXRANGE not working when argument is @XRANGE with cross-dim membersSummary @RELXRANGE not working when argument is @XRANGE with cross-dim membersContent Hi all, frustrated because @RELXRANGE not working as documented. From @RELXRANGE do… -
Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using GroovySummary: Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using Groovy Content (please ensure you mask any confidential information): I want to Cop…
-
Calculation Manager Errors and Considerations EnforcementSummary: In the August 2025 Monthly Update e-mail I saw this in Important Actions and Considerations: Calculation Manager Errors and Considerations Enforcement In a futu…
-
Using Substitution Variables in CalcManagerCan I use substitution variables for variables that can be specified in CalcManager? Can I only use variables created in CalcManager? Can substitute variables be used in…
-
Using Functions and Substitution Variables in Rules in Calc ManagerWhen I set variables that use functions and substitution variables in Calc Manager, I get the following error: Error:Validation against Planning outline succeeded. Faile…
-
$value is being considered as variable in REST API get method (SharePoint Integration)Hi guys, I am trying to get data from a CSV file which is uploaded in SharePoint to EPBCS application. From Sharepoint REST API, using the following Source URL GET https…
-
SET HYBRIDBSOINCALCSCRIPT FULL; IssueSummary: Content (please ensure you mask any confidential information): Hi we encountered an error when using SET HYBRIDBSOINCALCSCRIPT FULL; Just wanted to know why it …
-
how to open/close a period in "Manage Periods" from a Groovy script in FCCS?Hi everyone, I’m working with Oracle FCCS and need to automate the process of opening and closing periods (as done manually in Manage Periods) using Groovy scripts. Does…Loren LM 61 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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…Danny P Smith 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Using getSharedMembers for cube specific shares?Summary: I am trying to find cube specific shared members using getSharedMembers since the documentation shows this should be possible, but I'm getting shared members fr… -
Threading / Multi-Processing Equivalent in GroovySummary: Is there a way to accomplish threading / multi-processing in Groovy within EPBCS? We have a number of jobs where scripts are running on a large set of Project d… -
Creating via Groovy Rule the Excel file needed for the update of Cell-Level SecuritiesSummary: We would need to create and populate the two-tab-based Excel file needed for the Cell-Level Securities update. Is there a way to do so? Content (please ensure y…
-
Error while RunningOWP_Transfer Business rule in WorkforceI am trying to call OWP_Transfer Business rule through REST APIs in groovy, its giving below error. I tried to run OWP_Transfer rule from 'Rules' card from home page, st…
-
Member Formula Works in Test but Not ProductionSummary: Content (please ensure you mask any confidential information): In our tracker dimension, we have some historical data that is sitting outside our "Closing Balan… -
Clear data based on a smart list valueSummary:I am trying to Clear data based of a smart list value. If a dimmemberX→ beg balance→NO YEAR→ Smart list value = x , Clear all data for dimmemberX for Year1, Scen…
-
How to clear PCM multiple Periods for Forecast scenario with Groovy scriptSummary: I just want to clear all the data in PCM for Forecast dimension by using groovys script for all periods before laoding it from EPM. I have tried groovy with mdw…
-
Profitability and Cost Management (EPCM) Model Calculations for multiple Periods with GroovySummary: I have a pipeline in EPM Planning that push data into EPCM for all periods of Forecast scenario/Run Model Calculations for all periods to allocate Overheads/ Pu…
-
Error with SET commands when validate a business ruleSummary Some validation error message is showing on my all business rules unexpectedly, weeks ago was working fineContent Hi, I'm getting this Warning message when valid… -
Workforce Domestic and International TaxesSummary: Content (please ensure you mask any confidential information): I have been asked to add our international team to our Workforce app. They have a number of diffe…
-
Groovy script with POST rest command creates a unexcepted filename in targetSummary: I am running a groovy script which basically copies a file ( Outbox folder ) from environment-1 to Inbox folder of the target environment-2, ait then runs the i… -
@REMOVE is not working with Shared hierarchiesSummary:@REMOVE is not working with Shared hierarchies Content (please ensure you mask any confidential information): I am trying to remove currency rates, Mexico hierar…
-
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…
-
Translate BR variable "User ID" to dimension or smart list member?Summary: Can I translate a BR variable using the User Name default value into a dimension member or Smart List value? Content (please ensure you mask any confidential in…