Calc Manager
Discussion List
-
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… -
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!
-
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 "… -
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 …
-
Cannot see Log Messages tab in Calc Manager after running a groovy rule?Summary: When I run a groovy rule in calc manager I am not getting the Log Messages tab pop up but would love to be able to see these sorts of statistics. Content (pleas…
-
Not able to Hide Prompt when a Ruleset consists of two business rules from different cubesSummary: Though all the "Hide Prompt" properties are ticked still the user gets the prompt when executing from the actions menu Content (required): We have a requirement…
-
Using Groovy to update a member property for Storage, individual cube properties aren't updatingSummary: A Groovy script that builds a map to create a member in a hierarchy is not properly updating member properties Content (please ensure you mask any confidential …
-
Business rule default values are not showing in the run-time prompts all the timeSummary: When a form is initially opened, running a business rule correctly displays its default values in the run-time prompts. However, if multiple business rules are …
-
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…
-
@allocate is not parsing a value in basisMr parameterHi , I am trying to run an allocation to emulate a copy for performance issues. This is the command: "OEP_Plan"= @ALLOCATE("No Consolidado","2.2.1. PROFESOR HORA",1,,mul…
-
Not able to get the values in Hybrid BSO (Freeform) using @calcmgrSLMember for multiple dyn parentSummary: Not able to get the values in Hybrid BSO (Freeform) using @calcmgrSLMember for multiple dynamic parent Content (required): we are trying to make the code dynami…
-
epmautomate exportEssbaseData is it same as calculation manager export data>Summary: epmautomate exportEssbaseData is it same as calculation manager export data> Content (please ensure you mask any confidential information): hi All, We were eval…
-
Suggestion to update entity-currency mapping automaticallySummary: What is the best way to update Entity-Currency mapping automatically in the form. Smart list has been created from currency dimension. Is there any way to updat…
-
@SPARENVAL did not workHello everyone, I am having trouble with @SPARENTVAL and need help from you. Thanks in advance. I have an alternate hierarchy with the WI_AD_PRO_EXP as the parent of the… -
XREF and mdshiftSummary: Hi I have a BSO and ASO architecture in the application, where BSO is used for data consolidation from different applications and ASO is used for aggrgation/rep…