Calc Manager
Discussion List
-
Clearing ASO cube on RTPs with GroovySummary: I am new to EPBCS and Groovy. I have a requirement to clear partial data from ASO cube by users on recurring basis. I am trying to write a business rule which u… -
Workforce Planning Deprecated Rules in June 2026Summary: The Nov 2025 "Important Actions and Considerations" included that the following workforce rules will be updated and prior rules will be deprecated in the June 2…
-
YTD CPP and EI benefit accounts does not retain values in employee transfersSummary: When we do employee transfers between departments of one entity, the YTD CPP and EI values are not adjusted for when calculating benefits in the new department.… -
Create business rule to move employee data when they switch departmentsSummary: Content (please ensure you mask any confidential information): I need to create a business rule in Workforce to move the employee's bonus expense from their old… -
Deleted Business Rule Still Appears in ListSummary: Content (required): I asked this before, but cannot remember what the fix was, so apologies for the dup question. I have a few Business Rules that I have delete…
-
in EPM CLOUD business rule how to traverse the dimension in the order of a DATA COlumnhi All in the business rule in EPM CLoud - Planning - BSO Cube, we want to traverse all legal entities, based on a data column (PRIORITY), so primarily we need to perfor…
-
Usage of Scripts to improve the efficiency of business RuleSummary: Hi, Just wanted to confirm that I have used the following scripts in sequence at the start of business rule in designer format SET FRMLBOTTOMUP ON; SET CALCPARA…
-
groovy business rules for emailSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Export list of rules and list of rules securitySummary: Content (please ensure you mask any confidential information): Is there a way to export a list of business rules and the security (users assigned) to them? Vers…
-
How do I speed up an aggregation ruleSummary: Content (please ensure you mask any confidential information): We recently changed our subsidiary storage type to store. This has decreased refresh time in Smar…
-
Need to Run or Skip Section of Rule with Yes/No promptSummary: Content (please ensure you mask any confidential information): I have a section of a rule that copies forecast to a proforma scenario. My users would like this …
-
how to login essbase weburlSummary: How to login into Essbase Weburl. I need to calculate on ASO cube Content (please ensure you mask any confidential information): Version (include the version yo…
-
Account or Subsidiary Not AggregatingSummary: Content (please ensure you mask any confidential information): I have the below data that was loaded at a base level in Forecast, but it is not aggregating up t…
-
What is evaluation order and how does it impact aggregations?Summary: Content (please ensure you mask any confidential information): Our aggregations are running extremely slow. I'm not sure if evaluation order is impacting that. …
-
An explicit restructure causing block sizes to more than double in some cases?Summary: Running an explicit restructure on BSO cubes caused the block sizes to increase (greatly in some cases). Why is this occurring? Content (please ensure you mask … -
Attribute dimension update using groovySummary: I am looking for a solution to update non-HR positions added by a Planner during the budget process. Currently the user has service admin roles and is able to d…
-
Workforce - Use Percentage Based on AgeSummary: Content (please ensure you mask any confidential information): For our pension calculation, we need to use the employee age to identify the pension percentage. …
-
Multiple Tax ThresholdsSummary: Content (please ensure you mask any confidential information): In workforce planning, we are trying to build out payroll tax calculation for some European entit…
-
Create a Attribute member via groovy or REST APISummary Trying to use a groovy rule to update the attribute dimensionContent Hey, I want to update my attribute dimension in order to add more members. Can i do it via g…
-
Groovy error:A Method called by the script failed on Line:30 with error:Error Occurred:UNAUTHORIZEDSummary: I am running a groovy script in EPM FCCS and getting error "Groovy error : A Method called by the script failed on Line:30 with error : Error Occurred : UNAUTHO…
-
Allow users to add members to dimension with Groovy Businessrule and run a Businessrule CalculationSummary: Hi, The Client requirement is that users can create masterdata (projects in projectdimension) and those get visible in the dataform and can be used directly for…
-
Dynamic Custom Business Rule to select the number of months for each scenarioSummary: I need to develop the custom business rule in EPM Planning so that user can set the number of months for Actual,Forecast and Budge Scenario for calculation. The…
-
custom business rule not yielding expected resultsSummary: I am trying to write a simple business rule to take many discontinued entity balances and add them up and store them in a single new entity. The rule I wrote is… -
Business rule syntax error 1200400Hello, I am getting the below error while running a business rule. 1200400 ERROR Error executing formula for [ACC1] (line 0): scalar double argument expected in function…Ankita Ghosh 11 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Groovy to identify deltas in edited cells in a formSummary: I'm new to Groovy and in one implementation of Planning I need to create a rule that can identify not only which cells were modified, but what was the "delta" o… -
Groovy String Issue In Calc Script IFSummary: Running into an issue where we are trying to @SHIFT values based on an average receipt date. In the Working image below the @SHIFT is working and moving the val…
-
[sharing info] Interesting find using debug mode and edit mode with different resultsSummary: I was working on a calculation to add the ARR of a contract to a vintage month (If the contract starts in Jan 24, I want the ARR to be placed in Month 1 and the… -
How to supply member names with variables in CalcScript/Groovy?I'll make this quick; I'm just trying to save myself the chore of digging through the internet and forums for hours. We sync our labor data from HCM using CSV files. Thi…
-
Is it possible to force a line on a form to read only by row/column vs by cell using Groovy?Summary: I would like to have a groovy business rule set security on an entire column or row to read only vs having to do it by cell. Content (please ensure you mask any…