Calc Manager
Discussion List
-
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… -
Can Groovy script produce Business Rule logs?Summary: When we run a Business Rule in could EPM, the job console does not show the log as it would when run on prem. Is it possible to generate essbase-like calculatio…
-
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…
-
Update Valid Intersections Rules via GroovySummary I want to create valid intersections rules or conditions via groovy while creating a new memberContent Hey all, I have a situation where the client has several v…
-
New Groovy version 25.10 Validation ErrorHello Experts, I have a issue when I run validation Groovy Script: My HTML Report have same error in several rules, now are working fine but I'm afraid that is not worki… -
Business Rule: Capture logged-in user ID?Summary: Is there a way to capture, say in a variable, the ID of the logged-in user? Content (please ensure you mask any confidential information): We're building a cust…
-
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…
-
Groovy getFormattedValue() not working?Summary: Content (please ensure you mask any confidential information): Hi, Just found that getFormattedValue() not working as expected, it was working correctly before.…
-
Groovy Script ValidatorSummary: Content (please ensure you mask any confidential information): Hi, With the Aug release in TEST to validate groovy rule scripting restrictions by the provided t…
-
How to get the Smart Push functionality to work in Dashboards when they are being utilized via SmartSummary When submitting data for an EPBCS Dashboard in Excel via the Smart View 11.1.2.5.910 (Build 172) add-in, the Smart Push for the underlying simple forms being sav…