Calc Manager
Discussion List
-
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!
-
Is rtp a restricted word in simulateConcurrentUsage?We are experiencing an issue with simulateConcurrentUsage regarding how it is processing rtps when performing the Run Business Rule function of this command. We have att…Russ_Shellhamer 101 views 20 comments 1 point Most recent by Russ_Shellhamer EPM Platform and Freeform
-
Results of Groovy Script Validator BlankSummary: For a number of applications, all of which have Groovy code in place, the Groovy Script Validator Report is not producing any results where we were expecting th…Evan L 111 views 5 comments 0 points Most recent by Ujwala Maheshwari-Oracle EPM Platform and Freeform -
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 …
-
EPBCS Essbase Member formula NOT workingThis is so weird. Let me explain. I want to pull "Salary_By_Steps_WFP"→"Year3" value, which is $100. Assigning this code to dynamic calc member formula works perfect: "S…Ravinder Singh-63390 21 views 4 comments 1 point Most recent by Ravinder Singh-63390 EPM Platform and Freeform
-
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 …
-
How to check last execution time for business ruleSummary: Hi, Is there a way to check when was the last time a business rule was executed? I understand there is a way we can export the job console logs but that would g…Neha_R 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPCMCS-CALL GROOVY SCRIPT via EPM automateSummary: Call Groovy rule for EPM automate Hi All, I created one groovy rule in my EPCMCS instance. when I call the rule via EPM automate command i.e runBusinessRule. It…Avtar 11 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform