Calc Manager
Discussion List
-
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… -
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… -
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…
-
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…
-
Calculation Performance Degradation in ProductionSummary: Production Cloned to another Instance Content (please ensure you mask any confidential information): We cloned our production environment into a parallel produc… -
Grid Definition Builder: The property [grid] is not valid for the current operation.Summary: I am using flexibleDataGridDefinitionBuilder() to get data values but getting the error: The property [grid] is not valid for the current operation. Below is a …
-
Improve Merit Member FormulaSummary: Looking to see if this formula can be improved Content (please ensure you mask any confidential information): We have the below member formula for our raise/mer…
-
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, … -
SET HYBRIDBSOINCALCSCRIPT NONE; not workingSummary: Hi, I have written one rule in Jan'25 for Retained Earning with SET HYBRIDBSOINCALCSCRIPT NONE; which worked fine but is not provide expected result in Jan'26. …