Calc Manager
Discussion List
-
How to use @SHIFT(@CurrMBR in a crossdimI am trying to write a calc in calculation manager which will return a different value based on 3 different situations depending on the Period (i.e. "Jan") in the IF sta… -
How to Check if member from Plan1 exist in Plan2?Summary: Problem : Customer is copying data from one plan to another plan in planning application. Now some dimension member do not exist in target plan type. Do we have…
-
Groovy script to Validate comment entered through data formSummary: Hi, I am new to groovy BR. I am working on Groovy BR to validate "comment" entered by user using data form. A member with "Text" data type is used in data form …
-
Change in FIX AND behavior with 25.08In my business rules, I often use SET EMPTYMEMBERSETS ON; along with FIX statements to handle different branches of logic that need to occur for different years or scena… -
How to exclude intersections of different dimensional membersSummary: How to exclude an intersection of different dimensions within a FIX statement? see example below Content (required): Calc Script: In the FIX Statement is the wh…
-
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.…
-
Employees status setting to departureSummary: Content (please ensure you mask any confidential information): We have a business rule that sets active status. This has been working without issue for over a y… -
Calcmgrslmember does not return the correct cross reference value , but returns correctly in debugSummary: I have a business rule that refers to the calcmgrslmember to retrieve a SL member name and identifies the cross referenced value in an intersection. This does n… -
Independent BR assigned to Integration - runs also rules that are not assignedSummary: Hi all, I have created an Integration in EPM Planning (runs as expected) with the BR assigned to it. This business rule has been added as an Independent, event-…
-
Delay in calc manager to recognize new Smart Lists/Variables?Summary: I created a new SmartList within Planning and new Variables in Calc Manager. The SmartList isn't showing in the options for variables and the variables are givi…
-
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…
-
Newly added members not getting reflected in the Calculation ManagerAfter creating dimensions in Custom cube and refreshing the application, Member count is reflecting correctly from front end at application level however member count is…
-
Planning Calc Script - @COUNT with ConditionSummary: Hello - not sure why I am struggling so much with this but we have a rule where we want to have an IF statement to only include shared member projects that meet…
-
Workforce Rule Failing for Unknown ReasonSummary: Rule and Ruleset failing for unknown reason Content (please ensure you mask any confidential information): I have a ruleset in workforce that is scheduled in jo…
-
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…
-
Is there way to view all business rules ran within a time period?I need a full activity report/list with date or time stamps of all business rules that were ran for example in the past 30 days. Thank you!
-
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… -
Deleting file from Inbox/Outbox Explorer using REST APIHi all, We are trying to delete a csv file from Inbox/Outbox Explorer using the below REST API https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-co…
-
How to move bulk files from DM Inbox to EPM inbox using Groovy in Planning appsSummary: How to move bulk files from DM Inbox to EPM inbox using Groovy in Planning apps. Can anyone help us with syntax? Content (please ensure you mask any confidentia…
-
Groovy: Essbase Error(0) Invalid member nameHi all, I am trying to retrieve the date from a combination using DataGridDefinitionBuilder and extract year, month and day from it. The approach might be a bit long but…
-
Is it possible to assign different Admin users to 3 different cubes in the same application?Summary: Content (please ensure you mask any confidential information): Hi all I have doubt. Is it possible to give access to different ADMINS access to different CUBES … -
help with @Sumrange across two dimensionsI have an existing formula that looks like this: Fix(Dim1_member, Dim2_member) AcctX = @PRIOR(AcctX→noDept→TotalDim1→TotalDim2) Endfix What I'd like to do it change the …
-
When converting a calc script to business rule, are commands can be used to enhance performanceSummary: While converting calc script to business rule in EPM cloud, I found that CACHE HIGH command is not accepted on cloud. Are there other acceptable ways to enhance…
-
Data Exchange error Log failing on Export: ERROR [AIF]: Database "null" does not exist.Summary: Trying to Load data from an FCC instance into Planning via Data Exchange. Getting this in the error log, never seen this before: ERROR [AIF]: Database "null" do…
-
Business Rule in Pipeline Executes Only for One Year Instead of All Years in RangeSummary: We configured a Data Integration pipeline to run over multiple years (e.g., FY23 to FY25) with a Business Rule job type that runs a Calculation Manager rule. Ac…
-
ChatGPT API IntegrationSummary: Posting a small groovy snippet to allow chatGPT API integration. This is meant as a bit of fun with no practical applications at the moment. You will need to ge…
-
Run More Than One Calc Script in Groovy ScriptSummary: I am trying to run multiple pieces of calc script from one groovy script. It is executing the first piece essCalc1 and then the data push that is after essCalc1…
-
What is the OOTB rule applicable for balance sheet planning?Summary: I'm developing a B/S planning sheet using OOTB forms in EPBCS. Please let me know which rules need to be run to generate forecasts for B/S. For I/S, I ran the "… -
Calculation of percentile / quantileSummary: How to calculate percentiles / quantiles in EPM Planning BSO without considering #Missing Content (please ensure you mask any confidential information): In my c…
-
3 Month Moving Average - Multiple YearsSummary: Content (required): I am trying to calculate the average for the last 3 months and would like it to be a rolling average across years. I would like to add this …